Apache Friends Support Forum

Hello,

I installed XAMPP on a Windows Server 2003 machine but when I try to activate MSSQL the MSSQL.dll is missing.
Where can I found the right mssql.dll?

Thanks a lot!

Hi,

mssql functions are obsolet. use sqlsrv instead

best wishes,
Altrea

Thanks a lot!
On myn server is running SQLServer 2005.

Now I installed this:
; MSSQL
extension=php_sqlsrv_54_ts.dll
;extension=php_pdo_sqlsrv_54_ts.dll

And this is a part of the script:

Code: Select all

//  Connecten met sqlsrv database
$connectionInfo = array("Database"=>"TekRADIUS", "UID"=>"$SQL_gebruiker", "PWD"=>"$SQL_wachtwoord");
$conn = sqlsrv_connect($SQL_server, $connectionInfo);
if($conn === false){
        echo "Error in connection.\n";
        die(print_r(sqlsrv_errors(), true));
    }


I become this error:

Array ( [0] => Array ( [0] => IMSSP [SQLSTATE] => IMSSP [1] => -49 [code] => -49 [2] => This extension requires the Microsoft SQL Server 2012 Native Client. Access the following URL to download the Microsoft SQL Server 2012 Native Client ODBC driver for x86: http://go.microsoft.com/fwlink/?LinkId=163712 [message] => This extension requires the Microsoft SQL Server 2012 Native Client. Access the following URL to download the Microsoft SQL Server 2012 Native Client ODBC driver for x86: http://go.microsoft.com/fwlink/?LinkId=163712 ) [1] => Array ( [0] => IM002 [SQLSTATE] => IM002 [1] => 0 [code] => 0 [2] => [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified [message] => [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified ) )

I read this: http://vimalakanchanamsc.wordpress.com/2011/12/09/microsoft-sql-server-2-0-drivers-for-php-using-sqlsrv/

So I Checked php.ini and myn Compiler is MSVC9 (Visual C++ 2008).
I download php_sqlsrv_53_ts_vc9.dll and included it in php.ini.
After I restart the server I get this error:

PHP Startup: pdo_sqlsrv: Unable to initialize module
Module compiled with module API=20090626
PHP compiled with module API=20100525
These options need to match

So I thinks it's a version problem?
The .dll is to old?
Its hard to found the right .dll file.....

(sorry for myn bad English)

Hello,

SQLSRV 3.0 does not support Windows XP/Windows Server 2k3 and earlier. You will need a version of XAMPP that uses PHP 5.3.x (XAMPP 1.7.7 should work).

You will need SQLSRV 2.0 and Microsoft SQL Server 2008 R2 Native Client. Follow this thread for more information and links to more instructions: viewtopic.php?f=16&t=51070&hilit=sqlsrv

So poor they're not able to put the correct DLL in the xampp setup. WHY?