[freetds] isql connection hangs

Goyal, Pravin Shyam pravin.goyal at hp.com
Thu Jun 18 01:41:57 EDT 2009

Guys, I must admit that below happened:

# cat tds.driver.template
Description = My tds - Pravin
Driver = /usr/local/lib/libtdsodbc.so
# find /usr/local -name libtdsodbc.so
# odbcinst -i -d -f tds.driver.template
odbcinst: iniOpen failed on tds.driver.template.

I created odbcinst.ini file myself under /usr/local/etc. Is this breaking something or is there something wrong with the installation of unixODBC or FreeTDS? I am not sure. Please help.

From: Goyal, Pravin Shyam
Sent: Thursday, June 18, 2009 10:58 AM
To: 'unixodbc-support at mailman.unixodbc.org'
Subject: isql connection hangs

Hi All,

Below are my files:



        tds version = 8.0

        dump file = /tmp/freetds.log

        dump file append = no



Driver          = FreeTDS

Description     = Test SQL Swerver

Trace           = No

Servername      = \\\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. Am I missing something?

Thanks and regards,

Pravin Goyal

More information about the FreeTDS mailing list