XAMPP 1.8.3 and MSSQL

Problems with the Windows version of XAMPP, questions, comments, and anything related.

XAMPP 1.8.3 and MSSQL

Postby richardv » 11. October 2013 07:33

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!
richardv
 
Posts: 4
Joined: 10. October 2013 21:15
Operating System: Windows server2003

Re: XAMPP 1.8.3 and MSSQL

Postby Altrea » 11. October 2013 08:07

Hi,

mssql functions are obsolet. use sqlsrv instead

best wishes,
Altrea
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 8290
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64

Re: XAMPP 1.8.3 and MSSQL

Postby richardv » 13. October 2013 20:08

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 ) )
richardv
 
Posts: 4
Joined: 10. October 2013 21:15
Operating System: Windows server2003

Re: XAMPP 1.8.3 and MSSQL

Postby richardv » 15. October 2013 21:48

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)
richardv
 
Posts: 4
Joined: 10. October 2013 21:15
Operating System: Windows server2003

Re: XAMPP 1.8.3 and MSSQL

Postby hackattack142 » 21. October 2013 22:11

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
XAMPP Control Panel Developer
Latest CP: viewtopic.php?f=16&t=48932
hackattack142
 
Posts: 703
Joined: 20. May 2011 23:29
Operating System: Windows 7 Ultimate SP1 64-Bit

Re: XAMPP 1.8.3 and MSSQL

Postby xcy7e » 16. October 2014 09:20

So poor they're not able to put the correct DLL in the xampp setup. WHY?
xcy7e
 
Posts: 1
Joined: 16. October 2014 09:19
Operating System: Windows 7


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 69 guests