[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