newdude Posted December 22, 2010 Share Posted December 22, 2010 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 Quote Link to comment https://forums.phpfreaks.com/topic/222394-using-wampserver-20i-with-ms-sql2000/ Share on other sites More sharing options...
trq Posted December 23, 2010 Share Posted December 23, 2010 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. Quote Link to comment https://forums.phpfreaks.com/topic/222394-using-wampserver-20i-with-ms-sql2000/#findComment-1150553 Share on other sites More sharing options...
newdude Posted December 23, 2010 Author Share Posted December 23, 2010 Hi, thanks for the input. Ill look into this and report back with any successes or failures. Many thanks. Quote Link to comment https://forums.phpfreaks.com/topic/222394-using-wampserver-20i-with-ms-sql2000/#findComment-1150762 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.