Skip to Content.
Sympa Menu

freetds - [freetds] FreeTDS 0.62.3

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Jeremiah McElroy <jeremiah AT facility9.com>
  • To: freetds AT lists.ibiblio.org
  • Subject: [freetds] FreeTDS 0.62.3
  • Date: Sun, 25 Apr 2004 11:23:18 -0400

Hello,

I'm attempting to use FreeTDS 0.62.3 to connect to an MS SQL Server 2000 database housed on a remote server. When I try to connect, I see the following error message:

$ isql -v MSSQL USERNAME PASSWORD
[unixODBC][FreeTDS][SQL Server]Unable to connect to data source
[ISQL]ERROR: Could not SQLConnect

Thanks in advance,

Jeremiah McElroy


here is my odbc.ini:

[MSSQL]
Description = TDS MSSQL
Driver = TDS
Servername = www.facility9.com
Database = facility9
UID = USERNAME
PWD =
Port = 2433

Here is my sql logfile:

[ODBC][31010][__handles.c][399]
Exit:[SQL_SUCCESS]
Environment = 0x97683c0
[ODBC][31010][SQLAllocHandle.c][338]
Entry:
Handle Type = 2
Input Handle = 0x97683c0
[ODBC][31010][SQLAllocHandle.c][462]
Exit:[SQL_SUCCESS]
Output Handle = 0x9768ab8
[ODBC][31010][SQLConnect.c][3184]
Entry:
Connection = 0x9768ab8
Server Name = [MSSQL][length = 5 (SQL_NTS)]
User Name = [f9_whore][length = 8 (SQL_NTS)]
Authentication = [*********][length = 9 (SQL_NTS)]
UNICODE Using encoding ASCII 'ISO8859-1' and UNICODE 'UCS-2LE'

DIAG [S1000] [FreeTDS][SQL Server]Unable to connect to data source

[ODBC][31010][SQLConnect.c][3569]
Exit:[SQL_ERROR]
[ODBC][31010][SQLError.c][401]
Entry:
Connection = 0x9768ab8
SQLState = 0xbfeaf810
Native = 0xbfeaf808
Message Text = 0xbfeaf820
Buffer Length = 500
Text Len Ptr = 0xbfeaf80e
[ODBC][31010][SQLError.c][438]
Exit:[SQL_SUCCESS]
SQLState = S1000
Native = 0xbfeaf808 -> 0
Message Text = [[unixODBC][FreeTDS][SQL Server]Unable to connect to data source]
[ODBC][31010][SQLError.c][401]
Entry:
Connection = 0x9768ab8
SQLState = 0xbfeaf810
Native = 0xbfeaf808
Message Text = 0xbfeaf820
Buffer Length = 500
Text Len Ptr = 0xbfeaf80e
[ODBC][31010][SQLError.c][438]
Exit:[SQL_NO_DATA]
[ODBC][31010][SQLError.c][481]
Entry:
Environment = 0x97683c0
SQLState = 0xbfeaf810
Native = 0xbfeaf808
Message Text = 0xbfeaf820
Buffer Length = 500
Text Len Ptr = 0xbfeaf80e
[ODBC][31010][SQLError.c][518]
Exit:[SQL_NO_DATA]
[ODBC][31010][SQLFreeHandle.c][254]
Entry:
Handle Type = 2
Input Handle = 0x9768ab8
[ODBC][31010][SQLFreeHandle.c][305]
Exit:[SQL_SUCCESS]
[ODBC][31010][SQLFreeHandle.c][188]
Entry:
Handle Type = 1
Input Handle = 0x97683c0







Archive powered by MHonArc 2.6.24.

Top of Page