dan.cook Messages: 3 Registered: June 2010 Location: Cardiff, Wales
I would just like to thank you for your response to this question as it solved my issue completely.
PHP was installed using the Microsoft Web Platform Installer, and I have been trying to connect to a SQL Express 2008 database for days.
I have read alot online about the php_mssql.dll, php_odbc.dll, php_sqlsrv.dll etc.... And only on here did I find any mention of the php_pdo_mssql.dll extension which fixed my problem.
I initially downloaded the binary zip file from the PHP website and copied across the required dll, but it would not seem to load every time I restarted IIS. Then tried the non-thread safe version and now I can connect successfully.
I thought I would share my experience, in case anyone in the future is looking to fix the "Couldn't locate driver mssql" error message.