FreeTDS Development Group

[Osman Çinar Eren <Cinar.Eren AT isbank.com.tr>]

this is just a template file and odbcinst is used in order to create odbc.
then this is the second entry.
i go through the manual in www.unixodbc.org
so what should i do in order to set the path to the driver?

regards.

-----Original Message-----
From: Shanmugham, Abilash (London) [mailto:ShanmAbi AT exchange.uk.ml.com]
Sent: Thursday, October 10, 2002 12:03 PM
To: TDS Development Group
Subject: [freetds] RE: newbie


I am not sure if this makes a difference 
but the entry should be 
host = 10.50.104.133
port= 1433

hang on is this a freetds.conf entry or an .odbc.ini entry 
if it is the latter i think you have not set the path to the driver 

-abhi

> -----Original Message-----
> From: Osman Çinar Eren [SMTP:Cinar.Eren AT isbank.com.tr]
> Sent: Thursday, October 10, 2002 9:52 AM
> To:   TDS Development Group
> Subject:      [freetds] RE: newbie
> 
> Hi,
> 
> I installed unixodbc and then freetds with odbc support.
> i registered my odbc driver with odbcinst.
> then i created a dsn:
> 
> 
> [TESTC]
> Driver  = TDS
> Description     = sample db
> Trace   = No
> Servername      = 10.50.104.133:1433
> Database        = cinar
> UID     = cinar
> 
> when i try, isql -v TESTC  sa cinar, i get :
> 
> 
> [unixODBC]tds_connect failed
> [ISQL]ERROR: Could not SQLConnect
> 
> what may be the reason for this?
> 
> thanks in advance.
> bets regards.
> 
> -----Original Message-----
> From: Castellano, Nicholas [mailto:Nicholas_Castellano AT acml.com]
> Sent: Wednesday, October 09, 2002 5:17 PM
> To: TDS Development Group
> Subject: [freetds] RE: newbie
> 
> 
> I just went through this myself the other day.  I'm guessing you are using
> unixodbc.  My problem was that I was trying to edit the unixodbc
> configuration files by hand, and that didn't work.  The right thing to do
> seems to be to create template files and then use odbcinst to update the
> unixodbc configuration from the templates.  Have a look at
> http://www.unixodbc.org/doc/FreeTDS.html which shows you how to create and
> use the template files.
> 
> One other note... if I remember correctly, the odbcinst commands as shown
> on
> that page created /root/.odbc.ini, and I then moved that to odbc.ini in
> the
> system configuration directory (/usr/pkg/etc on my NetBSD system, probably
> /usr/local/etc on your system).
> 
> If I get a few minutes to spare, I'll try to put together a few notes on
> this and commit them along with some sample templates in the samples
> directory...
> 
> HTH,
> --entropy
> 
> -----Original Message-----
> From: Osman Çinar Eren [mailto:Cinar.Eren AT isbank.com.tr] 
> Sent: Wednesday, October 09, 2002 8:47 AM
> To: TDS Development Group
> Subject: [freetds] RE: newbie
> 
> 
> Hi,
> 
> i am on my way to use free-tds.
> i selected odbc as the api. 
> 
> The following call always returns an error immediately, although
> freetds.conf has TESTC entry and the env variable,FREETDSCONF is set:
> 
> res=SQLConnect(Connection,"TESTC",SQL_NTS,"cinar",SQL_NTS,"cinar",SQL_NTS)
> ;
> if (res!=SQL_SUCCESS)
> {
> printf("Unable to open data source (ret=%d)\n",res); CheckReturn();
> exit(1);
> }
> 
> 
> the error is:
> 
> 
> Unable to open data source (ret=-1)
> SQL error IM002 -- [unixODBC][Driver Manager]Data source name not found,
> and
> no default driver specified
> 
> 
> what do i miss?
> 
> thanks in advance.
> best regards.
> 
> ---
> You are currently subscribed to freetds as: [Nicholas_Castellano AT acml.com]
> To unsubscribe, forward this message to
> $subst('Email.Unsub')
> 
> 
> The information contained in this transmission may contain privileged and
> confidential information and is intended only for the use of the person(s)
> named above.  If you are not the intended recipient, or an employee or
> agent
> responsible for delivering this message to the intended recipient, any
> review, dissemination, distribution or duplication of this communication
> is
> strictly prohibited. If you are not the intended recipient, please contact
> the sender immediately by reply e-mail and destroy all copies of the
> original message. Please note that for certain accounts we do not accept
> orders and/or instructions by e-mail, and for those accounts we will not
> be
> responsible for carrying out such orders and/or instructions. Kindly
> refrain
> from sending orders or instructions by e-mail unless you have confirmed
> that
> we accept such communications for your account. Please also note that to
> satisfy regulatory requirements we review the outgoing and incoming e-mail
> correspondence of staff members serving certain functions.
> 
> 
> 
> ---
> You are currently subscribed to freetds as: [cinar.eren AT isbank.com.tr]
> To unsubscribe, forward this message to
> $subst('Email.Unsub')
> 
> ---
> You are currently subscribed to freetds as: [ShanmAbi AT exchange.uk.ml.com]
> To unsubscribe, forward this message to
> $subst('Email.Unsub')


---
You are currently subscribed to freetds as: [cinar.eren AT isbank.com.tr]
To unsubscribe, forward this message to
$subst('Email.Unsub')