Skip to Content.
Sympa Menu

freetds - Re: [freetds] ODBC Connection problem

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "shiv kumar" <shivblore2000 AT gmail.com>
  • To: freetds AT lists.ibiblio.org
  • Subject: Re: [freetds] ODBC Connection problem
  • Date: Thu, 21 Sep 2006 20:32:35 +0530

Thanks James,
The TDSERVER env variable was not set, this is the problem.

Date: Thu, 21 Sep 2006 10:02:24 -0400
From: "Lowden, James K" <james.k.lowden AT alliancebernstein.com>
Subject: Re: [freetds] ODBC Connection problem
To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
Message-ID:
<3778FAB3D61A7A40833F1CB3B8C173AA054FCEE9 AT AC2KAMA0107.ac.lp.acml.com>
Content-Type: text/plain; charset="us-ascii"
From: shiv kumar
Sent: Thursday, September 21, 2006 9:07 AM

I have installed the FreeTDS(0.63 ) and Unix ODBC(2.2.11) over our
Solaris machine. When I tried to connect the SYBASE server using
isql, it is throwing me the following error.
...
ask@logan:UODBC> cat ./etc/odbc*.ini
^^^^^^^^^
The '*' makes it unclear what the real name of the file is, and
the relative path makes it unclear where it is.

[SASA]
Driver = FreeTDS
^^^^^^^ No, should be the .so e.g.:
Driver = /export/home/ask/TDS/lib/libtdsodbc.so

Description = Test Sybase Database with FreeTDS
Trace = No
Server = 172.25.8.135
Port = 4100
TDS Version = 5.0
^ should be TDS_Version, note underscore.

Database = shiv_1

[FreeTDS]
Description = v0.63 with protocol v8.0
Driver = /export/home/ask/TDS/lib/libtdsodbc.so
UsageCount = 1

A TDSDUMP log would show any authentication problems. If none is
created, it's because the driver wasn't called, which normally means
odbc.ini isn't set up correctly. You can also verify your login with
tsql.

I have installed the FreeTDS in non roort directory i.e., not in
/usr/local directory. Will this is a problem?

No. The software doesn't care where it is or who owns it. Normal
installation sets permissions correctly.

HTH.

--jkl




Archive powered by MHonArc 2.6.24.

Top of Page