Skip to Content.
Sympa Menu

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

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Hank List" <hanklist AT ccintegration.com>
  • To: <freetds AT lists.ibiblio.org>
  • Subject: [freetds] I can connect to mssql with tsql but not with isql
  • Date: Tue, 21 Sep 2004 15:49:40 -0700

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@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@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 =
----------------------------------------










Archive powered by MHonArc 2.6.24.

Top of Page