Dear all,
I have the SC version 9.0.004 and created a project with 16 applications. It works fine with the local “MySQL” database. Now I would like to run the same application with accordings database and tables/views on a MicroSoftSQL-DB (SQL Server 2008 R2). What I tried:
-
I installed all needed Microsoft ODBC Driver 11 for SQL Server from the Microsoft-Website:
>> php_pdo_sqlsrv*.dll
>> php_sqlsrv_7_*.dll -
I copied them all into the folder C:\Program Files\NetMake\v9\components\php\ext
-
I edit the php.ini file in the folder C:\Program Files\NetMake\v9\components\php where I added the severel extensions
>> extension=php_pdo_sqlsrv_7_nts_x64.dll
>> extension=php_sqlsrv_7_nts_x64.dll
>> extension=php_pdo_sqlsrv_7_ts_x64.dll
>> extension=php_pdo_sqlsrv_7_ts_x86.dll>> extension=php_sqlsrv_7_nts_x64.dll
>> extension=php_sqlsrv_7_nts_x86.dll
>> extension=php_sqlsrv_7_ts_x64.dll
>> extension=php_sqlsrv_7_ts_x86.dll -
I set the correct extension path in php.ini to the folder where the dll’s are copied in:
>> extension_dir = “C:/Program Files/NetMake/v9/components/php/ext” -
I restart the apache server via SC Apache Service Monitor
-
I started SC again and created a new blank project in SC with database connection MSSQL
-
The MSSQL server is in the same VLAN segment like my development PC so I can create a database connection without any problem with an other DB connect tool to the desired DB and the tables, BUT:
-
If I choose in SC “MSSQL Server Native SRV” I get the error message:
>> Connection Error
>> SQLState: IMSSP
>> Error Code: -49
>> Message: This extension requires the Microsoft ODBC Driver 11 or 13 for SQL Server. Access the following URL to download the ODBC Driver 11 or 13 for SQL Server for x64: >> http://go.microsoft.com/fwlink/?LinkId=163712 -
If I choose “MSSQL Server Native SRV PDO”
>> Connection Error
>> Connection attempt failed: SQLSTATE[IMSSP]: This extension requires the Microsoft ODBC Driver 11 for SQL Server to communic … -
In case of “MSSQL Server”
>> The extension is not loaded on the php.ini file.
>> Click on the help icon for more informations.
What do I do wrong? ANY TIPS AND HINTS FOR ME?
Kind regards,
bysystem