can anyone point me in the right direction for information, regarding how to connect to MS SQL SERVER 2005 via PHP
The location of this seems to be varied depending upon what you read.
Configuration File (php.ini) Path C:\WINDOWS
Loaded Configuration File C:\xampp\apache\bin\php.ini
PHP Warning: PHP Startup: Unable to load dynamic library 'C:\\xampp\\php\\ext\\php_sqlsrv.dll' - The specified module could not be found.\r\n in Unknown on line 0
extension_dir C:\xampp\php\ext\
- Code: Select all
[b]Loaded [/b]Configuration File C:\xampp\apache\bin\php.ini
PHP Warning: PHP Startup: Unable to load dynamic library 'C:\\xampp\\php\\ext\\php_sqlsrv.dll'
Did you have this extension?
The File php_sqlsrv.dll was placed into folder c:\xampp\php\ext
this is the extensions folder referenced in phpinfo()
extension=php_sqlsrv.dll to enable connection to mssql server
The File php_sqlsrv.dll was placed into folder c:\xampp\php\ext
XAMPP was downloaded from http://www.apachefriends.org/en/xampp-windows.html
There was NO reference to either the standard or thread safe version of the ms-sql driver dll's in it.
Sure. Just read the documentation, which is part of the Microsoft SQL Server Driver for PHP package, more carefully...
It was that the sqldrv.dll and sqldrv-ts.dll drivers files
did not come with xampp, (at least not mine) I had to go and get them.
I then read the MS documentation that told me which files, and where to put them.
I then edited the php.ini file and anything else needed to get them installed properly and did what it said,
- Code: Select all
extension=php_sqlsrv.dll
Microsoft wrote:Installation
When you unpack the downloaded files for this release, you will find the php_sqlsrv_ts.dll and php_sqlsrv.dll files. These files correspond to a thread-safe version and a non–thread-safe version (respectively) of the SQL Server 2005 Driver for PHP. Follow the installation instructions in the "Loading the Driver" topic in the documentation to install the driver.
Note: The php_sqlsrv_ts.dll file is compatible with php5ts.dll, and php_sqlsrv.dll is compatible with php5.dll.
Did you think "extension=php_sqlsrv.dll" is correct, if you have a thread safe PHP and a "php5ts.dll"?
Microsoft wrote:Note: The php_sqlsrv_ts.dll file is compatible with php5ts.dll,
extension=php_sqlsrv_ts.dll
Microsoft say one thing, then another site says something else,
Users browsing this forum: No registered users and 266 guests