Connect to SQL db from PHP suggestions...?

[cliff606]

I'm working on a project where I have to query an SQL database (Microsoft SQL 2000) with PHP. The SQL database is on an external server.

I have all the connect info and am told the server's enabled in the firewall.

I've googled this several times and am quite confused with the response. Was wondering if anyone could point me to a reliable ODBC driver that's preferably free or open source.

-or-

If there's a better way for PHP to link up to the SQL database I'm open to suggestions.

My server is a Linux box with Apache2 running php 5.

Thanks in advance for any assistance/guidance you can provide.

[VelMurugan]

Even i had tried for several times to get it connected on linux server. But so far i have not done it.

But same works perfectly on windows server and localhost.

I'm working on a project where I have to query an SQL database (Microsoft SQL 2000) with PHP. The SQL database is on an external server.

I have all the connect info and am told the server's enabled in the firewall.

I've googled this several times and am quite confused with the response. Was wondering if anyone could point me to a reliable ODBC driver that's preferably free or open source.

-or-

If there's a better way for PHP to link up to the SQL database I'm open to suggestions.

My server is a Linux box with Apache2 running php 5.

Thanks in advance for any assistance/guidance you can provide.