[freetds] isql connection hnags

Goyal, Pravin Shyam pravin.goyal at hp.com
Thu Jun 18 00:30:17 EDT 2009


Hi All,
Below are my files:

/usr/local/etc/freetds.conf
[SQL1]
        tds version = 8.0
        dump file = /tmp/freetds.log
        dump file append = no


/usr/local/etc/odbc.ini
[MSSQLTestServer]
Driver          = FreeTDS
Description     = Test SQL Swerver
Trace           = No
Servername      = \\16.138.74.27\BTHUYAVANA11\SQLSERVER
Port            = 1433
Database        = master


Situation:1  If I give proper user name & password, I get connected, but not getting the <SQL> prompt. Why?
# isql -v MSSQLTestServer 'sa' 'Windows2003server'

It simply hangs up

Situation:2 : If I give wrong username or password I get below
# isql -v MSSQLTestServer 'sa' '123'
[S1000][unixODBC][FreeTDS][SQL Server]Unable to connect to data source
[01000][unixODBC][FreeTDS][SQL Server]Adaptive Server connection failed
[ISQL]ERROR: Could not SQLConnect

Please help. This is very critical for me. I am trying from past 1 week.

Thanks and regards,
Pravin Goyal





More information about the FreeTDS mailing list