Skip to Content.
Sympa Menu

freetds - RE: unixODBC woes

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Bill Thompson" <thompbil AT exchange.uk.ml.com>
  • To: freetds AT franklin.oit.unc.edu
  • Subject: RE: unixODBC woes
  • Date: Thu, 5 Sep 2002 10:55:01 -0400


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




Archive powered by MHonArc 2.6.24.

Top of Page