Using WampServer 2.0i with MS SQL2000

[newdude]

Hi all,

 

I've been using PHP for a a few months now with some success using the WampServer 2.0i (Apache 2.2.11 , MYSQL 5.1.36 and php5.3.0) setup and so far ive had no problems.

 

Im now being asked to use Apache and PHP to connect to an MS SQL 2000 backend now though and that is where the problems are starting.

 

Im aware that the PHP_MSSSQL.DLL support is for earlier versions of PHP and is no longer supported/being developed and that MS have introduced V2 of their own PHP SQL driver (see http://msdn.microsoft.com/en-us/sqlserver/ff657782). I have downloaded and installed this successfully via my PHP.INI config file but thats where the success ends.

 

The problem is that this driver requires SQL2005 or SQL2008 and im on SQL2000. The error that returns when I attempt to connect to the SQl server is "The SQL Server Driver requires SQL Server 2008 native Client ODBC Driver (SP1 or later) to communicate with SQL server" A link is then provide to download the Native client ODBC driver - which I have downloaded and installed but have had no success in connecting.

 

Has anybody overcome this issue? Do i have to downgrade my version of PHP to support the old MSSQL.DLL functionality or is there anyway to use the new MSSQL V2 drivers with an earlier version of SQL?

 

Cheers for any reponses guys,

 

newdude

 

 

 

[trq]

You are better off using ODBC to connect to MSSQL. Really though, if you can get the chance to move away from MSSQL I would. I had nothing but trouble getting it to play nicely with PHP at work.

[newdude]

Hi, thanks for the input. Ill look into this and report back with any successes or failures.

 

Many thanks.