freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
- 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
-
unixODBC woes,
Leon Brooks, 09/05/2002
- <Possible follow-up(s)>
- RE: unixODBC woes, Thompson, Bill D (London), 09/05/2002
- Re: unixODBC woes, James K. Lowden, 09/05/2002
- RE: unixODBC woes, Leon Brooks, 09/05/2002
- RE: unixODBC woes, Lowden, James K, 09/05/2002
- RE: unixODBC woes, Bill Thompson, 09/05/2002
- RE: unixODBC woes, Brian Bruns, 09/05/2002
- RE: unixODBC woes, Varley, David(CBorn at Alcoa), 09/05/2002
Archive powered by MHonArc 2.6.24.