[freetds] I can connect to mssql with tsql but not with isql

Hank List hanklist at ccintegration.com
Tue Sep 21 18:49:40 EDT 2004


Please help....

I am testing Freetds on a RH ES3 to send querry to a MSSQL 2000 and hoping that someone may have idea that help me troubleshoot the problem.

On my RH ES3 I download and install Freetds-0.62.4 after installing unixODBC-devel-2.2.8-2.3.0.2

I can run tsql but not isql!!!!!   If you have any idea what I did wrong please let me know.

Thank you,
Hank


*******************
I can run tsql:
  [root at localhost]# tsql -S enterprise -U saquerry
     locale is "en_US.UTF-8"   
     locale charset is "UTF-8"
     Password:    
     Msg 5703, Level 0, State 1, Server ENTERPRISE, Line 0
     Changed language setting to us_english.
     1> quit
************** end of tsql ************

but fail to run isql !!!!!!!!

************** run isql ****************
[root at borg etc]# isql -v enterprise saquerry getmedata
[S1000][unixODBC][FreeTDS][SQL Server]Unable to connect to data source
[ISQL]ERROR: Could not SQLConnect
*************** end of isql *****************

bellow is my sql.log generated by Freetds

*********************** sql.log *****************
[ODBC][15840][__handles.c][421]
                Exit:[SQL_SUCCESS]
                        Environment = 0x9286be0
[ODBC][15840][SQLAllocHandle.c][345]
                Entry:
                        Handle Type = 2
                        Input Handle = 0x9286be0
[ODBC][15840][SQLAllocHandle.c][463]
                Exit:[SQL_SUCCESS]
                        Output Handle = 0x9287360
[ODBC][15840][SQLConnect.c][3455]
                Entry:            
                        Connection = 0x9287360            
                        Server Name = [entperise][length = 9 (SQL_NTS)]            
                        User Name = [saquerry][length = 8 (SQL_NTS)]            
                        Authentication = [*********][length = 9 (SQL_NTS)]
[ODBC][15840][SQLConnect.c][3664]Error: IM002
***************************** end sql.log ********************



To compile, I ran the following command:

   # ./configure --with-tdsver=7.0 --with-unixodbc
   # make
   # make install

There was no error when I compile and make.

Freetds files are in /usr/local/bin/
and freetds.conf is in /usr/local/etc/

------ freetds.conf -------
[enterprise]
        host = 192.168.200.10
        port = 1433
        tds version = 7.0
-------------------------------

in /etc/ I have odbc.ini and odbcinst.ini

------- odbc.ini   ---------
[enterprise]
Description             = TDS MSSQL on enterprise
Driver          = TDS
Servername              = 192.168.200.10
Database                = ccicomp03
UID             = saquerry
PWD             = mypassword
Port            = 1433
--------------------------------

-------- odbcinst.ini ------------
[ODBC]
Trace           = Yes
TraceFile               = /tmp/sql.log
ForceTrace              = Yes
Pooling         = No

[TDS]
Description             = v0.60 with Protocol v7.0
Driver          = /usr/local/lib/libtdsodbc.so
Setup           = /usr/lib/libtdsS.so
FileUsage               = 1
CPTimeout               =
CPReuse         =
----------------------------------------









More information about the FreeTDS mailing list