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

Jaap van Arragon j.vanarragon at lukkien.com
Mon Jul 13 02:27:46 EDT 2009


Correct the current release for freetds is 0.82-4 but I am using etch!

I've updated the unixodbc, unixodbc-bin, freetds, freetds-dev packages to
the latest version

ii  unixodbc                          2.2.11-16
ii  unixodbc-bin                      2.2.11-16
ii  freetds-common                    0.82-4
ii  freetds-dev                       0.82-4

How can I proceed and test my connection? Even after updating the packages I
am getting:

Server:~# isql -v GROUP -w
[S1000][unixODBC][FreeTDS][SQL Server]Unable to connect to data source
[ISQL]ERROR: Could not SQLConnect


On 7/10/09 6:43 PM, "Steve Langasek" <vorlon at dodds.net> wrote:

> On Fri, Jul 10, 2009 at 05:03:24PM +0200, Jaap van Arragon wrote:
> 
>> 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
> 
> Is this description accurate, or historical?  The current Debian release has
> FreeTDS 0.82.




More information about the FreeTDS mailing list