Skip to Content.
Sympa Menu

freetds - [freetds] Trouble with SqlConnect

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Stephen <knucerdouw AT chyovirton.mailexpire.com>
  • To: freetds AT lists.ibiblio.org
  • Subject: [freetds] Trouble with SqlConnect
  • Date: Fri, 10 Sep 2004 11:33:09 -0500

Greetings,

I have recently installed FreeTDS and unixODBC on my Mandrake 10 box using the default packages. Now, I posted this same problem to the unixODBC support list, and I got nowhere, so I figured you guys might know more..

Thanks in advance!

-Stephen.

/etc/odbcinst.ini
-----------------
[TDS]
Description = TDS
Driver = /usr/lib/libtds.so.2
Setup = /usr/lib/libtdsS.so.1
FileUsage = 1

/etc/odbc.ini
-------------
[XBDB]
Description = XBDB
Driver = TDS
Servername = XBDB
Database = XBDB
UID = [masked]
PWD = [masked]
Port = 1433


/etc/freetds.conf
-----------------
[XBDB]
host = [masked]
port = 1433
tds version = 4.2
try domain login = yes
try server login = yes
nt domain = [masked]


What I tried
------------
- Connecting to XBDB with tsql, everything works great
- Connecting to XBDB with isql:
> isql -v XBDB [masked] [masked]
[IM004][unixODBC][Driver Manager]Driver's SQLAllocHandle on SQL_HANDLE_HENV failed
[ISQL]ERROR: Could not SQLConnect

Contents of sql.log
-------------------
[ODBC][1073][__handles.c][421]
Exit:[SQL_SUCCESS]
Environment = 0x8050e60
[ODBC][1073][SQLAllocHandle.c][345]
Entry:
Handle Type = 2
Input Handle = 0x8050e60
[ODBC][1073][SQLAllocHandle.c][463]
Exit:[SQL_SUCCESS]
Output Handle = 0x80515e0
[ODBC][1073][SQLConnect.c][3244]
Entry:
Connection = 0x80515e0
Server Name = [XBDB][length = 5 (SQL_NTS)]
User Name = [[masked]][length = 7 (SQL_NTS)]
Authentication = [*****][length = 5 (SQL_NTS)]
UNICODE Using encoding ASCII 'ISO8859-1' and UNICODE 'UCS-2LE'

[ODBC][1073][SQLConnect.c][1146]Error: IM004
[ODBC][1073][SQLError.c][424]
Entry:
Connection = 0x80515e0
SQLState = 0xbfffeff0
Native = 0xbfffefe8
Message Text = 0xbffff000
Buffer Length = 500
Text Len Ptr = 0xbfffefee
[ODBC][1073][SQLError.c][461]
Exit:[SQL_SUCCESS]
SQLState = IM004
Native = 0xbfffefe8 -> 0
Message Text = [[unixODBC][Driver Manager]Driver's SQLAllocHandle on SQL_HANDLE_HENV failed]
[ODBC][1073][SQLError.c][424]
Entry:
Connection = 0x80515e0
SQLState = 0xbfffeff0
Native = 0xbfffefe8
Message Text = 0xbffff000
Buffer Length = 500
Text Len Ptr = 0xbfffefee
[ODBC][1073][SQLError.c][461]
Exit:[SQL_NO_DATA]
[ODBC][1073][SQLError.c][504]
Entry:
Environment = 0x8050e60
SQLState = 0xbfffeff0
Native = 0xbfffefe8
Message Text = 0xbffff000
Buffer Length = 500
Text Len Ptr = 0xbfffefee
[ODBC][1073][SQLError.c][541]
Exit:[SQL_NO_DATA]
[ODBC][1073][SQLFreeHandle.c][268]
Entry:
Handle Type = 2
Input Handle = 0x80515e0
[ODBC][1073][SQLFreeHandle.c][317]
Exit:[SQL_SUCCESS]
[ODBC][1073][SQLFreeHandle.c][203]
Entry:
Handle Type = 1
Input Handle = 0x8050e60


There was no freetds.log




Archive powered by MHonArc 2.6.24.

Top of Page