isql connection hnags
"Goyal, Pravin Shyam" <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <95D24D994076904F8B79DB0C981F4F984B564A57E3@GVW0440EXB.americas.hpqcorp.net> |
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