[freetds] FreeTDS 0.62.3

Зверев Виталий Борис Зверев Виталий Борис
Sun Apr 25 15:31:58 EDT 2004


Hello Jeremiah.
Perhaps you have misprint in odbc.ini. The driver manager has been directed
to use a wrong driver in accordance with "Driver          = TDS".
Try to use a real path to real library like "Driver          =
/usr/local/lib/libtdsodbc.so" or include default driver section:
[Default]
Driver          = /usr/local/lib/libtdsodbc.so

Sincerely yours.

------------------------------------------------------------
Vitaly Zverev, Oracle Applications DBA,
Genesis Ltd., S.Petersburg, Russia


-----Original Message-----
From: freetds-bounces at lists.ibiblio.org
[mailto:freetds-bounces at lists.ibiblio.org] On Behalf Of Jeremiah McElroy
Sent: Sunday, April 25, 2004 7:23 PM
To: freetds at lists.ibiblio.org
Subject: [freetds] FreeTDS 0.62.3


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



_______________________________________________
FreeTDS mailing list
FreeTDS at lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds



More information about the FreeTDS mailing list