Skip to Content.
Sympa Menu

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

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Frediano Ziglio <freddy77 AT gmail.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Problems Connecting Debian --> MSSQL through odbc
  • Date: Fri, 10 Jul 2009 17:16:21 +0200

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




Archive powered by MHonArc 2.6.24.

Top of Page