Skip to Content.
Sympa Menu

freetds - RE: newbie

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Osman Çinar Eren <Cinar.Eren AT isbank.com.tr>
  • To: 'TDS Development Group' <freetds AT franklin.oit.unc.edu>
  • Subject: RE: newbie
  • Date: Thu, 10 Oct 2002 16:50:50 +0300


hi,

my template files are OK.
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

-----Original Message-----
From: Castellano, Nicholas [mailto:Nicholas_Castellano AT acml.com]
Sent: Thursday, October 10, 2002 4:47 PM
To: TDS Development Group
Subject: [freetds] RE: newbie


Please have a look at the unixodbc templates and scripts that I committed to
CVS yesterday in the samples directory. They should help get you up and
running. Let me know if you need more help after that.

Cheers,
--nick

-----Original Message-----
From: Osman Çinar Eren [mailto:Cinar.Eren AT isbank.com.tr]
Sent: Thursday, October 10, 2002 5:12 AM
To: TDS Development Group
Subject: [freetds] RE: newbie


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')

---
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')




Archive powered by MHonArc 2.6.24.

Top of Page