Skip to Content.
Sympa Menu

freetds - [freetds] unixODBC failing to connect.

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Jeff Honey <jhoney AT psmanagement.net>
  • To: freetds AT lists.ibiblio.org
  • Subject: [freetds] unixODBC failing to connect.
  • Date: Tue, 15 Apr 2003 10:06:55 -0400

FreeTDS .61 (stable)
unixODBC 2.2.5

I have had a tremendously difficult time in getting what at first appeared
to be a relatively simple thing to work. Everything compiled and installed
flawlessly but after a number of earnest attempts, I am still without ODBC
to my MSSQL server from my linux box. tsql testing seems to bear out that
FreeTDS works connecting directly to the server, though. Below are snippets
of configuration files and error msgs. Any help would be appreciated. If I
am being redundantly redundant and my answers are already answered
elsewhere, my apologies.





contents of SQL trace:
[ODBC][23568][__handles.c][399]
Exit:[SQL_SUCCESS]
Environment = 0x804e920
[ODBC][23568][SQLAllocHandle.c][338]
Entry:
Handle Type = 2
Input Handle = 0x804e920
[ODBC][23568][SQLAllocHandle.c][462]
Exit:[SQL_SUCCESS]
Output Handle = 0x804f018
[ODBC][23568][SQLConnect.c][3184]
Entry:
Connection = 0x804f018
Server Name = [testserver][length = 10 (SQL_NTS)]

User Name = [sa][length = 2 (SQL_NTS)]
Authentication = [][length = 0 (SQL_NTS)]
UNICODE Using encoding ASCII 'ISO8859-1' and UNICODE
'UCS-2LE'

DIAG [S1000] Client unable to establish connection

[ODBC][23568][SQLConnect.c][3569]
Exit:[SQL_ERROR]
[ODBC][23568][SQLError.c][401]
Entry:
Connection = 0x804f018
SQLState = 0xbffff4b0
Native = 0xbffff4a8
Message Text = 0xbffff4c0
Buffer Length = 500
Text Len Ptr = 0xbffff4ae
[ODBC][23568][SQLError.c][438]
Exit:[SQL_SUCCESS]
SQLState = S1000
Native = 0xbffff4a8 -> 1
Message Text = [[unixODBC]Client unable to establish
connection]
[ODBC][23568][SQLError.c][401]
Entry:
Connection = 0x804f018
SQLState = 0xbffff4b0
Native = 0xbffff4a8
Message Text = 0xbffff4c0
Buffer Length = 500
Text Len Ptr = 0xbffff4ae
[ODBC][23568][SQLError.c][438]
Exit:[SQL_NO_DATA]
[ODBC][23568][SQLError.c][481]
Entry:
Environment = 0x804e920
SQLState = 0xbffff4b0
Native = 0xbffff4a8
Message Text = 0xbffff4c0
Buffer Length = 500
Text Len Ptr = 0xbffff4ae
[ODBC][23568][SQLError.c][518]
Exit:[SQL_NO_DATA]
[ODBC][23568][SQLFreeHandle.c][254]
Entry:
Handle Type = 2
Input Handle = 0x804f018
[ODBC][23568][SQLFreeHandle.c][305]
Exit:[SQL_SUCCESS]
[ODBC][23568][SQLFreeHandle.c][188]
Entry:
Handle Type = 1
Input Handle = 0x804e920

contents of TDSDUMP:
2003-04-15 09:32:38.219047 iconv will convert client-side data to the ""
character set
2003-04-15 09:32:38.220719 IP address pointer is NULL
2003-04-15 09:32:38.220741 Server SYBASE not found!

ODBC.INI:
[testserver]
Driver = TDS
Description = Northwind sample database
Trace = yes
Servername = 192.168.1.15
Database = Northwind
UID = sa

ODBCINST.INI:
[TDS]
Description = v0.61 with protocol v8.0
Driver = /usr/local/freetds/lib/libtdsodbc.so
FileUsage = 1

FREETDS.CONF:
[global]
tds version = 4.2
initial block size = 512
swap broken dates = no
swap broken money = no
text size = 64512

[testserver]
host = testserver.foo.com
port = 1433
tds version = 8.0


¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤
Jeff Honey
PS Management Company
2255 Crescent Drive
Mount Dora, FL 32757
352-385-0114 x111 voice
352-385-0118 fax
¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤¤




Archive powered by MHonArc 2.6.24.

Top of Page