Moodle MS drivers for SQL Server for PHP problem

[bert113]

Can anyone offer me some advice with a Moodle windows build..

 

I successfully built a box using the WAMP installation this works fine except for when there is a load on it and it crashes and freezes a lot. So I decided to build a full blown Moodle Windows server with MSSQL all was going well until I got to the Moodle installation screen, I can't get past the Database settings. Even though I have tested PHP and installed SQL following all of the instructions I get the error "Microsoft Drivers for SQL Server for PHP are not installed or not configured properly". I have checked this as much as I can (and spent several hours on it) but I can't get past this page. I've downloaded the DLL specified and added it to the PHP config file ([php_SQLSRV]

extension=php_sqlsrv_53_nts_vc9.dll ) but I still get the problem - has anyone got any ideas /advice?

 

Thanks in advance

 

D

 

[Steve21]

Did you actually install the SQL drivers as well as the server? Need the SQL Native Drivers 2012 normally for things like that

 

Steve

[Steve21]

Also which PHP version are you on? As pretty sure it's up to about 56~ nowadays.

 

php_sqlsrv_53_nts_vc9.dll is an older 2.0 one, unless you specifically need that

 

Steve

[unixman_again]

I believe you've selected the wrong driver - I can't be sure as I've only ever run MySQL. Anyway, you said that you've installed MSSQL but your left had screen shot shows you are selecting the MySQL driver. You need the SQL Server Microsoft driver further down the list (which I guessing you haven't installed since it says not available).

[bert113]

Thanks Steve, that was the problem - checked the version of PHP and replaced the DLL with the correct one and this worked a treat - thanks again - D

 

Also which PHP version are you on? As pretty sure it's up to about 56~ nowadays.

 

php_sqlsrv_53_nts_vc9.dll is an older 2.0 one, unless you specifically need that

 

Steve