Discussion Community

IT Acumens Forum => Programming Discussions for Engineers => Web Services in PHP => Topic started by: cliff606 on Apr 27, 2010, 08:41 AM

Title: Connect to SQL db from PHP suggestions...?
Post by: cliff606 on Apr 27, 2010, 08:41 AM
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.
Title: Re: Connect to SQL db from PHP suggestions...?
Post by: VelMurugan on Apr 28, 2010, 04:07 AM
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.