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

Steven Orton sorton9999 at usa.net
Mon Jan 5 15:59:49 EST 2004



"Daughterson, Adam [EPM/BOU/MMI]" <Adam.Daughterson1 at EmersonProcess.com>
wrote:

> 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

  Correct me if I'm wrong, but don't you need to have 
       "--with-unixodbc=(toplevel unixODBC directory)"
  ?

  steve---


> 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
> _______________________________________________
> FreeTDS mailing list
> FreeTDS at lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
> 



-------------------------------
Steven Orton
sorton9999 at usa.net
--
"Put your hand on a hot stove for a minute,
 and it seems like an hour.
 Sit with a pretty girl for an hour, and it
 seems like a minute. THAT'S relativity."
        -- Albert Einstein
-------------------------------




More information about the FreeTDS mailing list