I am working on a site in which we are connecting to MS SQL Server 2000 using FreeTDS as a bridge. PHP4.2.3 is running on RedHat7.? and Apache 1.3.27. I've got FreeTDS up and working and I am able to connect to the SQL server, which is running on a MS Windows 2000 machine at a different location.
What I need to do is figure out how to QUICKLY determine if I can connect to the SQL server from PHP so I can display some alternate text if I can connect. I've looked at timeout settings in the freetds config files and they don't appear to work. Right now, the connection takes a couple minutes to time out. There is probably a really easy solution to this, but I can't seem to get it.
Any help would be greatly appreciated.
SQL Connect Timeout
Moderator: General Moderators
fsockopen() maybe?