FreeTDS Development Group

["Brad McNeely" <brad_mcneely AT excite.com>]

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!