FreeTDS Development Group

["Bill Thompson" <thompbil AT exchange.uk.ml.com>]

Hi Leon,

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

Of course. I didn't intend to be condescending, just informative :-)

> > $<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.

I may have been misleading here ( I edited my file before posting it, for
obvious reasons ). In my config the section header ( [MS_GLOSS] in my
example ) needs to be the same as the Servername entry ( = MY_SERVER in my
example )
So I've given you a bad example. sorry.

I think this is the part in the unixodbc explanation which wasn't clear.

> 
> > $<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?
> 

Dont worry - you only need freetds.conf


> > $<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?

Yes.

Hope this doesn't confuse you even further :-)

Bill