how connect to SQL Server 2008 R2 using php from windows 10

hi

Sql Server database I was able to connect on Windows 8.1, Windows 10, but the following error:

SQLSTATE[IM003]: Specified driver could not be loaded due to system error 126: The specified module could not be found. (ODBC Driver 11 for SQL Server, C:\Windows\SysWOW64\msodbcsql11.dll).1


Please help to solve my problem.

Thanks :)

SQL Server 2008 R2

Windows 10

PHP V : 5.6



  • Edited by webafra Thursday, July 30, 2015 6:57 AM
July 30th, 2015 6:25am

Please check if this file exists C:\Windows\SysWOW64\msodbcsql11.dll. I think this file is missing. Please refer to this too.

https://social.technet.microsoft.com/Forums/sqlserver/es-ES/d8f7b935-4cb8-4152-9b87-fcd5c4b78b8e/system-error-126?forum=sqltools

https://krithikav.wordpress.com/2008/04/10/system-error-126-for-odbc-configuration/

Free Windows Admin Tool Kit Click here and download it now
July 30th, 2015 1:44pm

Hi! Read the following article: 

How to: Connect Using SQL Server Authentication

This may also be useful:

Microsoft Drivers for PHP for SQL Server

July 30th, 2015 2:34pm

Hello,

SQL Server 2008 and SQL Server 2008 R2 are not supported on Windows 10 as mentioned on the following Microsoft Support article:

https://support.microsoft.com/en-us/kb/2681562

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com

Free Windows Admin Tool Kit Click here and download it now
July 31st, 2015 12:29am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics