Skip to Content.
Sympa Menu

freetds - [freetds] New FreeTDS/unixODBC install

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Tim Sawyer <tsawyer AT us.ibm.com>
  • To: freetds AT lists.ibiblio.org
  • Subject: [freetds] New FreeTDS/unixODBC install
  • Date: Mon, 3 May 2004 13:45:59 -0700

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@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@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@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@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




Archive powered by MHonArc 2.6.24.

Top of Page