Re: Problems Connecting Debian --> MSSQL through odbc

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" <[email protected]> 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" <[email protected]> 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
> [email protected]
> http://lists.ibiblio.org/mailman/listinfo/freetds