[prev in list] [next in list] [prev in thread] [next in thread] 

List:       freetds
Subject:    Re: [freetds] isql connection hangs
From:       "Goyal, Pravin Shyam" <pravin.goyal () hp ! com>
Date:       2009-06-18 5:41:57
Message-ID: 95D24D994076904F8B79DB0C981F4F984B564A584F () GVW0440EXB ! americas ! hpqcorp ! net
[Download RAW message or body]

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
/usr/local/lib/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@mailman.unixodbc.org'
Subject: isql connection hangs


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



Thanks and regards,

Pravin Goyal

_______________________________________________
FreeTDS mailing list
FreeTDS@lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds


[prev in list] [next in list] [prev in thread] [next in thread]