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: Jaap van Arragon <j.vanarragon AT lukkien.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Problems Connecting Debian --> MSSQL through odbc
  • Date: Tue, 14 Jul 2009 09:02:28 +0200

Does anyone know where the problem exists? Is it the odbc connection or
custom data such as dbname etc.. That is causing the isql to fail?


On 7/13/09 8:27 AM, "Jaap van Arragon" <j.vanarragon AT lukkien.com> wrote:

> 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.
>
>
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds






Archive powered by MHonArc 2.6.24.

Top of Page