CODEWITHSUNDEEP
phpsql-server-2008windows-10
Jon Freynik
Jon Freynik

Reputation: 369

Configure Windows 10 WAMP PHP to connect to SQLServer 2008

I have been spending days on this project trying to connect to a database and have reached some what of a stand still. I'm hoping someone has some experience with this.

I have been given Remote Desktop credentials to a Windows Server(R) 2008 box. There is a database running on that machine, and the client would like to pull data out of it from another domain - it is running SQLServer 2008.

As a test I am trying to connect to it via a local WAMP install. I was able to get the following .dll's running in my local PHP after downgrading it to its 32 bit version: - php_pdo_sqlsrv_55_ts.dll - php_sqlsrv_55_ts.dll

However, when I try to use PDO or the sqlsrv_connect function to connect, I receive the error message:

SQLSTATE[IMSSP]: This extension requires the Microsoft ODBC Driver 11 for SQL Server to communicate with SQL Server. Access the following URL to download the ODBC Driver 11 for SQL Server for x86: http://go.microsoft.com/fwlink/?LinkId=163712

When I try to download and install the Microsoft ODBC Driver 11 (https://www.microsoft.com/en-us/download/details.aspx?id=36434) - I receive the following error message:

Installation of this product failed because it is not supported on this operating system. For information on supported configurations, see the product documentation.

My question is, is there a way to connect to a SQLServer 2008 database from a WAMP install on a Windows 10 machine? - as far as I can tell it is not supported on Windows 10.

Thank you for your time.

Upvotes: 1

Views: 2602

Answers (1)

Ken
Ken

Reputation: 41

I'm on Windows 10. I have the 64bit wamp server installed running php 7.0.10.

I was able to connect to a Microsoft Azure database.

I had to install The Microsoft® ODBC Driver 11 for SQL Server® - Windows this version of it 

ENU\x64\msodbcsql.msi

This is the url: https://www.microsoft.com/en-us/download/details.aspx?id=36434

I also had to load "php_pdo_sqlsrv_7_ts_x64.dll" file to the folder C:/wamp64/bin/php/php7.0.10/ext

and add the 

extension=php_pdo_odbc.dll
extension=php_pdo_sqlsrv_7_ts_x64.dll

to the php.ini file

this was for a Cakephp 3.55 project

Upvotes: 1

Related Questions