Skip to Content.
Sympa Menu

freetds - RE: newbie

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Shanmugham, Abilash (London)" <ShanmAbi AT exchange.uk.ml.com>
  • To: "'TDS Development Group'" <freetds AT franklin.oit.unc.edu>
  • Subject: RE: newbie
  • Date: Thu, 10 Oct 2002 10:02:34 +0100


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





Archive powered by MHonArc 2.6.24.

Top of Page