[freetds] isql error when connecting with SYBASE using unixODBC

shiv kumar shivblore2000 at gmail.com
Wed Sep 20 09:16:27 EDT 2006

I have installed the FreeTDS(0.63 ) and Unix ODBC(2.2.11) over our Solaris
machine. When I tried to connect the SYBASE server using isql, it is
throwing me the following error.  I have tried with various user name and
password but no of use. At the same time I am able connect successfully from
the Windows using the Sybase native driver. Please not that I am passing
the correct user name and password.

ask at logan:bin> isql -v

[IM010][unixODBC][Driver Manager]Data source name too long

[ISQL]ERROR: Could not SQLConnect

ask at logan:bin> isql -v SAS

[IM002][unixODBC][Driver Manager]Data source name not found, and no default
driver specified

[ISQL]ERROR: Could not SQLConnect

ask at logan:bin> isql -v SASA system system

src/tds/login.c: tds_connect: Connection timed out

[S1000][unixODBC][FreeTDS][SQL Server]Unable to connect to data source

[08S01][unixODBC][FreeTDS][SQL Server]Server is unavailable or does not

[ISQL]ERROR: Could not SQLConnect

*ask at logan:bin> isql -v SASA system system*

*[S1000][unixODBC][FreeTDS][SQL Server]Unable to connect to data source*

*[28000][unixODBC][FreeTDS][SQL Server]Login incorrect.*

*[08S01][unixODBC][FreeTDS][SQL Server]Read from SQL server failed.*

*[ISQL]ERROR: Could not SQLConnect*

ask at logan:UODBC> cat ./etc/odbc*.ini


Driver          = FreeTDS

Description             = Test Sybase Database with FreeTDS

Trace           = No

Server          =

Port            = 4100

TDS Version      = 5.0

Database                = shiv_1


Description             = v0.63 with protocol v8.0

Driver          = /export/home/ask/TDS/lib/libtdsodbc.so

UsageCount              = 1

ask at logan:UODBC>



More information about the FreeTDS mailing list