[freetds] Re: Re: RE: freeTDS unixODBC...Which one isn't working

Daughterson, Adam [EPM/BOU/MMI] Adam.Daughterson1 at EmersonProcess.com
Mon Jan 5 14:33:21 EST 2004


Thank you again,


So I started from scratch and here's what I've got now:
I had to compile/configure unixODBC first (to use isql for testing) and
couldn't find any reason 
to pass any arguments to the ./configure && make && make install.

Then I ran ./configure --with-unixodbc --with-tdsver=8.0
and let it install freetds in the default /usr/local prefix.

I edited /usr/local/etc/freetds.conf and tested with tsql.  OK so far.
/usr/local/etc/dumpo(for debugging) is the glad recipient of TDSDUMPCONFIG.
After tsql, I get lots of nice info about the successful connection to DB.

Now to experiment, I selectively move the odbc.ini and odbcinst.ini around
to ~, and /usr/local/etc (among other places), it 'works' in both ~, and
/usr/local/etc.  ('works' because isql gripes that there aren't any data
sources by that name when the odbc*.ini files are not in ~, or
/usr/local/etc)

Here are the files as they stand now:

root at USBOU1-DHDLINUX:/usr/local/etc# cat odbc.ini
[ODBC Data Sources]
esp_ms_sql = MS SQL Server

[esp_ms_sql]
Driver =        /usr/local/lib/libodbc.so
Description =   MS SQL Server
Trace = No
Server =        usbou1-scallog
Port =          1433
Address =       155.177.99.17
TDS_Version =   8.0
UID =           esp_it
Database =      esp35_it
[Default]
Driver =        /usr/local/lib/libodbc.so

root at USBOU1-DHDLINUX:/usr/local/etc# cat odbcinst.ini
[TDS]
Description             = v062
Driver          = /usr/local/lib/libodbc.so
FileUsage               = 2

I tried using /usr/local/lib/libtdsodbc.so as the driver in both ini files
and it immediately errors out with Unable to SQLConnect.  Using the
/usr/local/lib/libodbc.so, when running:

isql -v dsn user passwd

It hangs indefinitely.  No output, no error, just blank line on the console.
I feel like the FreeTDS part is working, but the unixODBC part has the bug.
How does this look to you?
Is there anything else that I could include to make this more concise?
AD


More information about the FreeTDS mailing list