WampServer

I have installed the 32 bit of Wampserver 2.4

All working fine.

Now trying to acess MSSQL but getting the following Apache error:

PHP Warning: PHP Startup: Unable to load dynamic library 'D:/Wamp/bin/php/php5.4.16/ext/php_mssql.dll' - The specified module could not be found.\r\n in Unknown on line 0

Where can I get this file from?

I have Wampserver 2.0 on another server and have it operating perfectly. Just can't get it with this newer version of Wampserver.

Regards,
dClark

This page from the PHP manual should answer your question Installing php_mssql

You will need the Thread Safe libraries to run with WAMPServers Apache-PHP configuration and the SQLSRV 3.0 drivers are probably your best option.

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>
Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-



Edited 1 time(s). Last edit at 08/26/2014 02:09PM by RiggsFolly.

Hi there RiggsFolly.

Thanks for the quick reply.

I have now managed to get a connection using:

$connDynacom = sqlsrv_connect( $myServer, $connectionInfo);

My code used to be:

$connDynacom = new COM ("ADODB.Connection" or die("Cannot start ADO";

$connStr = "PROVIDER=SQLOLEDB;SERVER=".$myServer.";UID=".$myUser.";PWD=".$myPass.";DATABASE=".$myDB;
$connDynacom->open($connStr); //Open the connection to the database

The connect queries are now not working. They are coded as such:

$query = 'SELECT .......";

$rs = $connDynacom->execute($query);

while (!$rs->EOF)
{
blah blah
}

Will I have to change the way they are written now?

Regards,
dClark

I dont actually use MSSQL but it would appear that you may have in fact been using a COM object to make the connections and not the php_mssql extension at all.

See [php.net]

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>
Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-



Edited 1 time(s). Last edit at 08/26/2014 03:45PM by RiggsFolly.