unixODBC woes

Leon Brooks leon at cclinic.com.au
Thu Sep 5 23:37:09 EDT 2002


On Thu, 5 Sep 2002 14:45, Thompson, Bill D (London) wrote:
> I'm not trying to be smartarse here, but there is a section in the FreeTDS
> user guide on how to get this configuration working. There is also (as I
> remember) something on the UNIXODBC web site about configuring with
> FreeTDS.

Yes. I've read both of them, several times, very carefully.

> $<unixodbc>/etc/odbcinst.ini   :

> [FREETDS]
> Description     = Freetds latest snapshot
> Driver      = /home/thompbil/freetds/lib/libtdsodbc.so
> FileUsage       = 1

Did this. I just called mine [TDS].

> $HOME/.odbc.ini   :

> [MS_GLOSS]
> Driver      = FREETDS
> Description     = Gloss SQL Server
> Trace       = No
> Servername      = MY_SERVER
> Database        = mydb
> UID     = myuid

Did this, but I called it TSDdev2. Using `Driver = TDS' failed for me (it 
couldn't find the driver file) but putting `Driver = /path/to/driver.so' did 
work for the EasySoft ODBC bridge and did stop the can't-load-driver errors 
for FreeTDS.

> $<freetds>/interfaces :

> MY_SERVER
>     query tli tcp /dev/tcp \x000207760b9f343250000000000000000

I don't have one of these. Does it go in the --prefix directory (/usr in my 
case) or the --sysconfdir directory (/etc)? What is the magic hex number for?

> $<freetds>/etc/freetds.conf :

> [MY_SERVER]
>     host = 123.456.789.12
>     port = 1632
>     tds version = 8.0

Did this for TDSdev2 (but TDS 7.0 for SQL Server 7, and port 1433).

> The <freetds>/interfaces file and the <freetds>/etc/freetds.conf are
> alternatives in freetds.

Meaning that I only need one of them?

-- 
Computer Clinic (WA) P/L     Lasting good health for your network!
+61-8-9207-3686              http://www.cclinic.com.au/

linux.conf.au 2003           The Australian Linux Technical Conference
http://conf.linux.org.au/    22-25 January 2003 in Perth, Western Australia




More information about the FreeTDS mailing list