Re: MS SQL Server access works with tsql but not w: msg#00226 db.tds.freetds

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@xxxxxxxxx > wrote:
From: Brian Bruns [mailto: brian.bruns@xxxxxxxxx]
To: brad_mcneely@xxxxxxxxxx, freetds@xxxxxxxxxxxxxxxxx
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@xxxxxxxxxx> 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 > FileUsage = 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] > 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 > Tex
t 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 > 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][8500][SQLConnect.c][3452] > Entr
y: > 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@xxxxxxxxxxxxxxxxx >
http://lists.ibiblio.org/mailman/listinfo/freetds > 

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

Previous by Date:	Re: MS SQL Server access works with tsql but not with isql, Brian Bruns
Next by Date:	Re: MS SQL Server access works with tsql but not with isql, Brad McNeely
Previous by Thread:	Re: MS SQL Server access works with tsql but not with isql, Brian Bruns
Next by Thread:	Re: MS SQL Server access works with tsql but not with isql, Brad McNeely
Indexes:	[Date] [Thread] [Top] [All Lists]

Re: MS SQL Server access works with tsql but not with isql: msg#00226

db.tds.freetds

Free Magazines