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: Brian Bruns <brian.bruns AT gmail.com>
To: brad_mcneely AT excite.com, FreeTDS Development Group <freetds AT lists.ibiblio.org>
Cc:
Subject: Re: [freetds] MS SQL Server access works with tsql but not with isql
Date: Mon, 13 Dec 2004 20:02:40 -0500

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
> FileUsage = 1
>
> /etc/unixODBC/odbc.ini
> [mssql]
> Description = TDS
> Driver = 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
> Text Len Ptr = 0xbfffebde
> [ODBC][8246][SQLError.c][461]
> Exit:[SQL_SUCCESS]
> 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]
> 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
>

[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