Page 1 of 1

SQL Connect Timeout

Posted: Thu May 08, 2003 4:27 pm
by webdvl
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.

Posted: Sat May 10, 2003 4:00 pm
by m3mn0n