SQLSRV Driver [message #4722] |
Sat, 09 May 2015 11:44 |
rafs
Messages: 69 Registered: May 2015
|
Member |
|
|
I am like a chicken with my head cut-off trying to install and configure a SQLSRV driver on Windows 7 (in a multi database configuration).
I am on Windows 7. I used the XAMPP install packages. My main database is MySQL to handle audit, dict, menu, and workflow databases. So in my config.inc file 'dbms' = 'mysql'. That is working. I have fixed my include_path, by hard-coding it into C:\xampp\php\config\php.ini. (I wasn't able to get Apache to load my htaccess.txt files.)
I have 3 variations working in Administrative Tools >> ODBC:
ODBC Driver 11 for SQL Server
SQL Server
SQL Server Native Client 11.0
In my php extensions folder (C:\xampp\php\ext) I installed the SQL Server drivers:
php_sqlsrv_54_ts.dll
php_sqlsrv_54_nts.dll
...
php_sqlsrv_56_ts.dll
...
In php.ini, I have loaded this last one, using:
extension=php_sqlsrv_56_ts.dll
In my config.inc, I have tried dozens of permutations for multi database configuration.
(I will post the config.inc details in a separate post.)
|
|
|