PHP odbc_connect : sql error

"Rowland, TJ (LVA)" <[email protected]>
Newsgroups gmane.comp.db.tds.freetds
Message-ID <DC72670C131EB245A9035168A3FB31DB0A24EE@COVMSGCES-EMB05.cov.virginia.gov>
Hi all.

I am attempting to connect to MS Sql Server from Linux (RHEL 5) via ODBC/FreeTDS and PHP, but keep having troubles and was wondering if anyone could steer me in the right direction.

I can connect to SQL Server with both tsql and isql, and also from a shell using the php command. However, whenever I attempt to access the php page through a browser, I receive the following error:

odbc_connect() [function.odbc-connect]: SQL error: [unixODBC][FreeTDS][SQL Server]Unable to connect to data source, SQL state S1000 in SQLConnect in /var/www/html/mysqltest.php on line 12

I checked my freetds.log file and the following errors were noted:
net.c:204:Connecting to 10.1.1.51 port 1214 (TDS version 5.0)
net.c:258:tds_open_socket: connect(2) returned "Permission denied"
util.c:334:tdserror(0xa618960, 0xa61db08, 20009, 13)
odbc.c:2102:msgno 20009 20003
util.c:368:tdserror: client library returned TDS_INT_CANCEL(2)
util.c:389:tdserror: returning TDS_INT_CANCEL(2)
net.c:303:tds_open_socket() failed
mem.c:609:tds_free_all_results()
error.c:409:odbc_errs_add: "Unable to connect to data source"

I thought it might be a firewall problem, but after disabling my firewall (/etc/init.d/iptables stop) the problem persists. 

Also, I created a simple phpinfo.php file (<?php phpinfo()  ?>) to check for differences in configuration between the php shell cmd and php called from the browser, but found no major differences. So I'm stumped.

If anyone could lend a hand, point me in the right direction or share some insight, it would be greatly appreciated. Thank you.
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.