Skip to Content.
Sympa Menu

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

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Steven Orton <sorton9999 AT usa.net>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [[freetds] Re: Re: RE: freeTDS unixODBC...Which one isn't working]
  • Date: Mon, 05 Jan 2004 15:59:49 -0500



"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@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@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
-------------------------------






Archive powered by MHonArc 2.6.24.

Top of Page