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 18:09:34 +0200

Osql reports:

SERVER:# osql -S TEST -U admin -P pass
osql: error: no potential directory strings in "/usr/bin/isql"
isql strings are:
+ /lib/ld-linux.so.2

TDSDUMP: nothing but succesfull results when I connect through isql nothing
is being written in the log file.

Odbc.ini:

[TEST]
Driver = FreeTDS
Description = A good description of your DB
Trace = Yes
Server = [IP ADDRESS]
Port = 1433
#UID = [admin]
#PWD = [pass]
#LogonUser = [admin]
#LogonAuth = [pass]
TDS_Version=7.0


1. I have multiple odbc.ini but odbcinst -j looks at /etc/odbc.ini
/etc/odbc.ini
/etc/php5/conf.d/odbc.ini
/etc/php5/conf.d/pdo_odbc.ini
/root/.odbc.ini
/usr/src/freetds-0.82/samples/odbc.ini
2. I am using IP to connect
3. I have TDS_Version in my odbc.ini
4. how can I check this point? Driver = FreeTDS

Thank you!!


On 7/14/09 5:31 PM, "jklowden AT schemamania.org" <jklowden AT schemamania.org>
wrote:

> 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
> _______________________________________________
> 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