[freetds] New FreeTDS/unixODBC install

Tim Sawyer tsawyer at us.ibm.com
Mon May 3 16:45:59 EDT 2004


I'm setting up a FreeTDS/ODBC on Redhat 9 to be used with PHP. I found 
rpm's for both FreeTDS unix ODBC.  I can connect with tsql but not with 
isql. It gives 

[root at alrsrpt01 etc]# isql sqlprod2 MyUserID MyPassword -v
[unixODBC][FreeTDS][SQL Server]Unable to connect to data source
[ISQL]ERROR: Could not SQLConnect 

Here's my odbcinst.ini
[root at alrsrpt01 etc]# cat odbcinst.ini 
[TDS]
Description     = v0.62 with protocol v4.2 and v7
Driver          = /usr/lib/libtdsodbc.so
Setup           = /usr/lib/libtdsS.so
FileUsage       = 1

and my odbc.ini
[root at alrsrpt01 etc]# cat odbc.ini 
[sqlprod2]
Description = FreeTSD to sqlprod2
Driver = TDS
Servername = sqlprod2.phs.com
Database = AdminWorkFlow_Reports
UID = MyUserID
PWD = MyPassword 
Trace = No
Protocol = 4.2
Port = 1433

and my freetds.conf
[root at alrsrpt01 etc]# cat freetds.conf
[sqlprod2]
        host = sqlprod2.xxxxx.com
        port = 1433
        tds version = 7.0

[sqldev03]
        host = sqldev03.xxxxx.com
        port = 1433
        tds version = 7.0

#[TDS]
#        host = sqlprod2.xxxxx.com
#        port = 1433
#        tds version = 7.0

Thanks for helping with this!

Tim Sawyer
Office: (562) 797-3408

Tim Sawyer
Office: (562) 797-3408



More information about the FreeTDS mailing list