Skip to Content.
Sympa Menu

freetds - RE: unixODBC woes

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Leon Brooks <leon AT cclinic.com.au>
  • To: "TDS Development Group" <freetds AT franklin.oit.unc.edu>
  • Subject: RE: unixODBC woes
  • Date: Thu, 5 Sep 2002 22:37:09 +0800


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





Archive powered by MHonArc 2.6.24.

Top of Page