FreeTDS Development Group

["James K. Lowden" <jklowden AT schemamania.org>]

Vladimir Petrov <vpetrov AT episteme.no> wrote:
> Has anybody succeed conneting unixODBC->FreeTDS to Sybase Anywhere
> 5.5.0.5 on Windows? Yes, I know it's an old DB, but I can't replace it
> now...  I tried several configs w/o success... Here's mine configs:
> #odbcinst.ini
> [Sybase]
> Description     = Sybase ODBC source
> Driver          = /usr/lib/libtdsodbc.so
> Setup           = /usr/lib/libtdsS.so
> UsageCount      = 1
> CPTimeout       =
> CPReuse         =
> 
> #odbc.ini
> [episteme]
> Description     = Company database
> Driver             = Sybase
> Servername    = company
> Database        = companydb
                    ^^^^^^^^^
> 
> #freetds.conf
> [company]
   ^^^^^^^
>         host = dbhost.company.com
>         port = 1433
>         tds version =5.0

Try making your freetds.conf section name match the name of the database
(not server) you're trying to connect to.  That is, call it "[companydb]",
not "[company]".  

FreeTDS passes this string as part of the login packet.  ASA is the only
TDS server that cares what it is.  

Hälsingar, 

--jkl