sqlsrv driver issues

[krazykev]

Hi all,

 

this is driving me crazy - I must be doing something obviously wrong.  I want to load the Microsoft PHP PDO drivers.  I have checked my phpinfo and found the following:-

 

PHP Version 5.3.8

Loaded Configuration File C:\Program Files (x86)\PHP\php.ini

extension_dir                         C:\Program Files (x86)\PHP\ext

 

So I put the file 'php_pdo_sqlsrv_53_ts_vc9.dll' in the extension dir.

 

I then added the following line the correct php.ini file:-

 

;;;;;;;;;;;;;;;;;;;;;;

; Dynamic Extensions ;

;;;;;;;;;;;;;;;;;;;;;;

extension=php_pdo_sqlsrv_53_ts_vc9.dll

 

But when I check php info the sqlsrv driver does not appear to be loaded, not even after a reboot.  All I see is:

 

PDO drivers mysql, odbc, sqlite

 

Not sure what I have missed.  How can I tell if PHP has tried to load the sqlsrv drivers?

 

Thanks

 

Kev

[kicken]

Make sure you are loading the correct dll file.

 

Along with the version you need to match up the compiler (vc6 / vc9) and thread safety (ts / nts).  You should be able to find that info in your phpinfo output if you are not sure what you have.

 

 

[krazykev]

I wondered about that so decided to go down the route of uninstalling and re-installing.  Never thought to look for that in phpinfo! DOH!!!

[krazykev]

I must have had a mis-match somewhere although I thought I tried every possible combination.

 

I have just installed PHP 5.3.10 nts and using php_pdo_sqlsrv_53_nts_vc9.dll and it seems ok for now.

 

Thanks for your suggestion.