[freetds] Problems Connecting Debian --> MSSQL through odbc

Frediano Ziglio freddy77 at gmail.com
Fri Jul 10 11:16:21 EDT 2009


2009/7/10 Jaap van Arragon <j.vanarragon at lukkien.com>:
> Hello,
>
> I am having a problem connecting my MSSql database through ODBC (FreeTDS).
>
> I can¹t connect through isql it gives the error:
>
> [S1000][unixODBC][FreeTDS][SQL Server]Unable to connect to data source
> [ISQL]ERROR: Could not SQLConnect
>
> Here are my DSN and Driver:
>
> [GROUP]
> Driver = FreeTDS
> Description = A good description of your DB
> Trace = No
> Server = [10.10.10.10]
> Port = 1433
> Database = [327]
> UID = [xx]
> PWD = [xx]
> LogonUser=[xx]
> LogonAuth=[xx]
>
> [FreeTDS]
> Description = FreeTDS 0.63-3, unixodbc 2.2.11-13
> Driver = /usr/lib/odbc/libtdsodbc.so
> TraceFile = /tmp/sql.log
> Trace = Yes
>
> Any Idea?
>
> Thanks
> Sincerely
>
> Jaap

Well.. you could try to update...
PWD, UID, LogonUser and LoonAuth are ignored. You are using correct
drivers (message came from FreeTDS).
Try also setting TDSCONFIGDUMP environment to stderr to see possible errors.

freddy77


More information about the FreeTDS mailing list