newbie

Osman Çinar Eren Cinar.Eren at isbank.com.tr
Thu Oct 10 13:11:44 EDT 2002


as i said before, i correctly registered the odbc driver with the unixodbc.
of course, i looked for the location of libtdsodbc.so in my system.

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


Dear Cinar 
I persume you  have an entry like this 


[TDS] 
Description     = v0.52 with protocol v4.2 
Driver          = /usr/local/freetds/lib/libtdsodbc.so 

this manual seems to be written sometime back before freeTDs 0.6 
from freetds 0.6 onwards the installtion directory has changed 
from /usr/local/freetds to /usr/local 
so the Driver entry now should be /usr/local/libtdsodbc.so 

HTH 
 abhi
 



> -----Original Message-----
> From:	Osman Çinar Eren [SMTP:Cinar.Eren at isbank.com.tr]
> Sent:	Thursday, October 10, 2002 10:01 AM
> To:	TDS Development Group
> Subject:	[freetds] RE: newbie
> 
> 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')
> 
> ---
> 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')



More information about the FreeTDS mailing list