freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

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

From: jklowden AT schemamania.org
To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
Subject: Re: [freetds] Problems Connecting Debian --> MSSQL through odbc
Date: Tue, 14 Jul 2009 11:31:33 -0400

On Tue, Jul 14, 2009 at 05:21:12PM +0200, Jaap van Arragon wrote:
>
> I had multiple freetds.conf files.
>
> I've found the right one and I can now connect through tsql.
>
> BUT I can't connect through isql.
>
> SERVER:# isql -v TEST -w
> [S1000][unixODBC][FreeTDS][SQL Server]Unable to connect to data source
> [ISQL]ERROR: Could not SQLConnect

What does src/apps/osql report? TDSDUMP?

Are you sure TEST is configured correctly in odbc.ini?

Likely problems:

1. two odbc.ini files, or one where unixODBC is not looking.
2. using servername instead of server or vice-versa.
3. leaving TDS_Version out of the odbc.ini section.
4. misidentifying the driver in odbc.ini.

--jkl

Re: [freetds] Problems Connecting Debian --> MSSQL through odbc , (continued)
- Re: [freetds] Problems Connecting Debian --> MSSQL through odbc, Steve Langasek, 07/10/2009
  - Re: [freetds] Problems Connecting Debian --> MSSQL through odbc, Jaap van Arragon, 07/13/2009
    - Re: [freetds] Problems Connecting Debian --> MSSQL through odbc, Jaap van Arragon, 07/14/2009
      - Re: [freetds] Problems Connecting Debian --> MSSQL through odbc, Frediano Ziglio, 07/14/2009
        
        Re: [freetds] Problems Connecting Debian --> MSSQL through odbc, Jaap van Arragon, 07/14/2009
        
        Re: [freetds] Problems Connecting Debian --> MSSQL through odbc, Frediano Ziglio, 07/14/2009
        
        Re: [freetds] Problems Connecting Debian --> MSSQL through odbc, Jaap van Arragon, 07/14/2009
        Re: [freetds] Problems Connecting Debian --> MSSQL through odbc, James K. Lowden, 07/14/2009
        Re: [freetds] Problems Connecting Debian --> MSSQL through odbc, Jaap van Arragon, 07/14/2009
        Re: [freetds] Problems Connecting Debian --> MSSQL through odbc, jklowden, 07/14/2009
        Re: [freetds] Problems Connecting Debian --> MSSQL through odbc, Jaap van Arragon, 07/14/2009
        Re: [freetds] Problems Connecting Debian --> MSSQL through odbc, jklowden, 07/14/2009
        Re: [freetds] Problems Connecting Debian --> MSSQL through odbc, Jaap van Arragon, 07/14/2009
        Re: [freetds] Problems Connecting Debian --> MSSQL through odbc, jklowden, 07/14/2009
        Re: [freetds] Problems Connecting Debian --> MSSQL through odbc, Jaap van Arragon, 07/15/2009
        Re: [freetds] Problems Connecting Debian --> MSSQL through odbc, Frediano Ziglio, 07/15/2009
        Re: [freetds] Problems Connecting Debian --> MSSQL through odbc, Jaap van Arragon, 07/15/2009
        Re: [freetds] Problems Connecting Debian --> MSSQL through odbc, Frediano Ziglio, 07/15/2009
        Re: [freetds] Problems Connecting Debian --> MSSQL through odbc, Jaap van Arragon, 07/15/2009
        Re: [freetds] Problems Connecting Debian --> MSSQL through odbc, Frediano Ziglio, 07/15/2009