freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Re: [freetds] MS SQL Server access works with tsql but not with isql

From: "Brad McNeely" <brad_mcneely AT excite.com>
To: freetds AT lists.ibiblio.org, brian AT bruns.com
Cc:
Subject: Re: [freetds] MS SQL Server access works with tsql but not with isql
Date: Mon, 13 Dec 2004 20:50:26 -0500 (EST)

Sorry, please disregard. It's working. I was fat fingering something on
isql. Thanks a done for you help.

Regards,
Brad McNeely

--- On Mon 12/13, Brad McNeely < brad_mcneely AT excite.com > wrote:
From: Brad McNeely [mailto: brad_mcneely AT excite.com]
To: brian AT bruns.com, freetds AT lists.ibiblio.org
Date: Mon, 13 Dec 2004 20:46:03 -0500 (EST)
Subject: Re: [freetds] MS SQL Server access works with tsql but not with isql

 OK. I'm still not there. New error. I get isql -v
mmssql [IM002][unixODBC][Driver Manager]Data source name not found, and no
default driver specified with this
config /etc/unixODBC/odbc.ini [mssql] Description =
TDS Driver = TDS Servername = TDS Database
= pubs UID = bmcneely PWD = Port
= 1433 /etc/freetds.conf [TDS] host =
192.168.1.101 port = 1433 tds version = 7.0 Here's the
ODBC trace file: [ODBC][4144][__handles.c][421] 
Exit:[SQL_SUCCESS] Environment =
0x8052488 [ODBC][4144][SQLAllocHandle.c][345] Entry: 
Handle Type = 2 Input Handle =
0x8052488 [ODBC][4144][SQLAllocHandle.c][463] 
Exit:[SQL_SUCCESS] Output Handle =
0x8052c08 [ODBC][4144][SQLConnect.c][3452] Entry:
 Connection = 0x8052c08 
Server Name = [mmssql][length = 6 (SQL_NTS)] 
User Name = [][length = 0 (SQL_NTS)] 
Authentication = [][length = 0
(SQL_NTS)] [ODBC][4144][SQLConnect.c][3661]Error:
IM002 [ODBC][4144][SQLError.c][424] Entry:
 Connection = 0x8052c08 
SQLState = 0xbfffeef0 
Native = 0xbfffeee8 Message Text =
0xbfffef00 Buffer Length = 500
 Text Len Ptr =
0xbfffeeee [ODBC][4144][SQLError.c][461] Exit:[SQL_SUCCESS]
 SQLState = IM002
 Native = 0xbfffeee8 -> 0 
Message Text = [[unixODBC][Driver Manager]Data source
name not found, and no default driver
specified] [ODBC][4144][SQLError.c][424] Entry:
 Connection = 0x8052c08 
SQLState = 0xbfffeef0 
Native = 0xbfffeee8 Message Text =
0xbfffef00 Buffer Length = 500
 Text Len Ptr =
0xbfffeeee [ODBC][4144][SQLError.c][461] 
Exit:[SQL_NO_DATA] [ODBC][4144][SQLError.c][504] Entry:
 Environment = 0x8052488 
SQLState = 0xbfffeef0 
Native = 0xbfffeee8 Message Text =
0xbfffef00 Buffer Length = 500
 Text Len Ptr =
0xbfffeeee [ODBC][4144][SQLError.c][541] 
Exit:[SQL_NO_DATA] [ODBC][4144][SQLFreeHandle.c][268] 
Entry: Handle Type = 2 Input
Handle = 0x8052c08 [ODBC][4144][SQLFreeHandle.c][317] 
Exit:[SQL_SUCCESS] [ODBC][4144][SQLFreeHandle.c][203] 
Entry: Handle Type = 1 Input
Handle = 0x8052488 I feel like i'm getting closer. It was
much easier to configure the DB2 ODBC driver.
Thanks. Regards, Brad --- On Mon 12/13, Brian Bruns <
brian.bruns AT gmail.com > wrote: From: Brian Bruns [mailto:
brian.bruns AT gmail.com] To: brad_mcneely AT excite.com,
freetds AT lists.ibiblio.org Date: Mon, 13 Dec 2004 20:02:40
-0500 Subject: Re: [freetds] MS SQL Server access works with tsql but not
with isql in the odbc.ini "Servername" is a reference to the
freetds.conf file, "Server" would be a hostname (or IP as in this case) so
either use Servername = TDS or Server =
192.168.1.101 but don't mix them. If you use the later (ODBC-only
style) you'll probably want to use TDS_Version in odbc.ini as
well. On Mon, 13 Dec 2004 19:33:04 -0500 (EST), Brad
McNeely <brad_mcneely AT excite.com> wrote: > > Using the rpms >
freetds-0.62.1-1.i586.rpm > freetds-unixodbc-0.62.1-1.i586.rpm > >
from the freetds web site I'm up and running. I'm able to connect to an
MSSQL Server database using tsql but not isql. Here are my files: >
/etc/unixODBC/odbcinst.ini > [TDS] > Description = TDS
Test > Driver = /usr/lib/libtdsodbc.so > Setup =
/usr/lib/unixODBC/libtdsS.so.1 > File
Usage = 1 > > /etc/unixODBC/odbc.ini > [mssql] >
Description = TDS > Driv er = TDS > Servername
= 192.168.1.101 > Database = pubs > UID
= bmcneely > PWD = > Port = 1433 >
 > /etc/freetds.conf > [TDS] > host = 192.168.1.101 > port =
1433 > tds version = 7.0 > > Here's the error: > isql -v mssql
bmcneely > [S1000][unixODBC][FreeTDS][SQL Server]Unable to connect to data
source > [ISQL]ERROR: Could not SQLConnect > > and here's the
sql.log from the ODBC trace: > [ODBC][8246][__handles.c][421] >
Exit:[SQL_SUCCESS] > Environment =
0x8052488 > [ODBC][8246][SQLAllocHandle.c][345] >
Entry: > Handle Type = 2 >
Input Handle = 0x8052488 > [ODBC][8246][SQLAllocHandle.c][463] >
Exit:[SQL_SUCCESS] > Output Handle =
0x8052c08 > [ODBC][8246][SQLConnect.c][3452]<br >>
Entry: > Connection = 0x8052c08 >
Server Name = [mssql][length = 5 (SQL_NTS)] >
User Name = [][length = 0 (SQL_NTS)] >
Authentication = [][length = 0 (SQL_NTS)] > UNICODE Using
encoding ASCII 'ISO8859-1' and UNICODE 'UCS-2LE' > >
DIAG [S1000] [FreeTDS][SQL Server]Unable to connect to data source > >
[ODBC][8246][SQLConnect.c][3820] > Exit:[SQL_ERROR] >
[ODBC][8246][SQLError.c][424] > Entry: >
Connection = 0x8052c08 > SQLState =
0xbfffebe0 > Native = 0xbfffebd8 >
Message Text = 0xbfffebf0 > Buffer
Length = 500 > Text Len Ptr = 0xbfffebde >
[ODBC][8246][SQLError.c][461] > Exit:[SQL_S 
UCCESS] > SQLState = S1000 >
Native = 0xbfffebd8 -> 0 > Message Text =
[[unixODBC][FreeTDS][SQL Server]Unable to connect to data source] >
[ODBC][8246][SQLError.c][424] > Entry: >
Connection = 0x8052c08 > SQLState =
0xbfffebe0 > Native = 0xbfffebd8 >
Message Text = 0xbfffebf0 > Buffer
Length = 500 > Text Len Ptr = 0xbfffebde >
[ODBC][8246][SQLError.c][461] > Exit:[SQL_NO_DATA] >
[ODBC][8246][SQLError.c][504] > Entry: >
Environment = 0x8052488 > SQLState =
0xbfffebe0 > Native = 0xbfffebd8 >
Message Text = 0xbfffebf0 > Buffer
Length = 500<br >> Text Len Ptr = 0xbfffebde >
[ODBC][8246][SQLError.c][541] > Exit:[SQL_NO_DATA] >
[ODBC] [8246][SQLFreeHandle.c][268] > Entry: >
Handle Type = 2 > Input Handle
= 0x8052c08 > [ODBC][8246][SQLFreeHandle.c][317] >
Exit:[SQL_SUCCESS] > [ODBC][8246][SQLFreeHandle.c][203] >
Entry: > Handle Type = 1 >
Input Handle = 0x8052488 > [ODBC][8500][__handles.c][421] >
Exit:[SQL_SUCCESS] > Environment =
0x8052488 > [ODBC][8500][SQLAllocHandle.c][345] >
Entry: > Handle Type = 2 >
Input Handle = 0x8052488 > [ODBC][8500][SQLAllocHandle.c][463] >
Exit:[SQL_SUCCESS] > Output Handle =
0x8052c08 > [ODBC][8
500][SQLConnect.c][3452] > Entry: >
Connection = 0x8052c08 > Server Name =
[mssql][length = 5 (SQL_NTS)] > User Name =
[bmcneely][length = 8 (SQL_NTS)] > Authentication
= [][length = 0 (SQL_NTS)] > UNICODE Using encoding ASCII
'ISO8859-1' and UNICODE 'UCS-2LE' > > DIAG [S1000]
[FreeTDS][SQL Server]Unable to connect to data source > >
[ODBC][8500][SQLConnect.c][3820] > Exit:[SQL_ERROR] >
[ODBC][8500][SQLError.c][424] > Entry: >
Connection = 0x8052c08 > SQLState =
0xbfffebd0 > Native = 0xbfffebc8 >
Message Text = 0xbfffebe0 > Buffer
Length = 500 > Text Len Ptr = 0xbfffebce >
[ODBC][8500][SQLError.c][461] > Exit:[SQL_SUCCESS] >
SQLState = S1000 > Native =
0xbfffebc8 -> 0 > Message Text =
[[unixODBC][FreeTDS][SQL Server]Unable to connect to data source] >
[ODBC][8500][SQLError.c][424] > Entry: >
Connection = 0x8052c08 > SQLState =
0xbfffebd0 > Native = 0xbfffebc8 >
Message Text = 0xbfffebe0 > Buffer
Length = 500 > Text Len Ptr = 0xbfffebce >
[ODBC][8500][SQLError.c][461] > Exit:[SQL_NO_DATA] >
[ODBC][8500][SQLError.c][504] > Entry: >
Environment = 0x8052488 > SQLState =
0xbfffebd0 > Native = 0xbfffebc8 >
Message Text = 0xbfffebe0 > Buffer
Length = 500 > Text Len Ptr = 0xbfffebce >
[ODBC][8500][SQLError.c][541] > 
Exit:[SQL_NO_DATA] > [ODBC][8500][SQLFreeHandle.c][268] >
Entry: > Handle Type = 2 >
Input Handle = 0x8052c08 > [ODBC][8500][SQLFreeHandle.c][317] >
Exit:[SQL_SUCCESS] > [ODBC][8500][SQLFreeHandle.c][203] >
Entry: > Handle Type = 1 >
Input Handle = 0x8052488 > > Any help is greatly
appreciated. > > Regards, > Brad McNeely > >
_______________________________________________ > Join Excite! -
http://www.excite.com > The most personalized portal on the Web! >
_______________________________________________ > FreeTDS mailing
list > FreeTDS AT lists.ibiblio.org >
http://lists.ibiblio.org/mailman/listinfo/freetds > _______________________________________________ Join
Excite! - http://www.excite.com The most personalized portal on the
Web! _______________________________________________ FreeTDS mailing
list FreeTDS AT lists.ibiblio.org http://lists.ibiblio.org/mailman/listinfo/freetds 

_______________________________________________
Join Excite! - http://www.excite.com
The most personalized portal on the Web!

[freetds] MS SQL Server access works with tsql but not with isql, Brad McNeely, 12/13/2004
- Re: [freetds] MS SQL Server access works with tsql but not with isql, Brian Bruns, 12/13/2004
- <Possible follow-up(s)>
- Re: [freetds] MS SQL Server access works with tsql but not with isql, Brad McNeely, 12/13/2004
- Re: [freetds] MS SQL Server access works with tsql but not with isql, Brad McNeely, 12/13/2004