[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