Accessing MSSQL 2005 from PHP

[Claus Mygind]

I am currently running:

1. xP Windows 32 bit
2. Apache 2.2.11.0 http server
3. PHP 5.3.3.0

I want to enable connecting php with MS SQL server 2005 to read files.

I see that php_mssql.dll is no longer supported from php version 5.3 on

After reading numerous online post about the topic, I have not been able to find or install the newer sqlsrv.dll file needed for php 5.3.x

I am in the process of converting an older dBase app to php on my web server. With dBase, I have no trouble connecting to the MS SQL server via the ODBC. Since sqlsvr.dll uses the ODBC connection and my dBase app can connect with the server, this seems the way to go.

Could someone provide a link for downloading sqlsrv.dll? And also provide some step by step instructions of how to add to my existing php installation?

I am hoping is is something like:
1. download sqlsvr.dll into your c:\php\ext folder
2. modify your php.ini to include the line - extension=php_sqlsvr.dll
3. restart web server.

[Dormilich]

I would recommend PDO with the ODBC driver.

[omerbutt]

you are having issues because you need to look in the TS(thread safe) AND NON TS(non thread safe) DLL files for sqlsrv only one particular link wont help you u need to install all these diferent types and try them one by one as all the dll are compiled differently for different versions of php i had a project of DOC - > IMAGE conversion where it has to use the IMAGICK OPENOFFICE AND SQLSRV ALONG WITH PHP TO MAINTAIN LOGS AND RECORDS, i had php version 5.2.3 , i would recommend you to use that verson if there is not any specific / strict requirement for the project

REGARDS,
Omer Aslam

[omerbutt]

look here , i think it is negating wot u said php 5.3 is supported, DORMILICH GUIDED you the right way, follow the links that it has included
HERE

[Claus Mygind]

Thank you both for your answers. I have done some further checking and I see I need the following.

1) Install SQL Native Client on my Apache Web Server machine, I believe that must be on the CD that came with MS SQL server which we have installed on another machine.

2) My version of php is 5.3.3 which seems to fall right between the cracks. Looking at snapshot.txt in the php folder, I see my version is compiled with V6, So I must select those .dll files to install.

3) Also I see that my php5ts.dll so I have to select the

php_sqlsrv_53_ts_vc6.dll and php_sqlsrv_53_ts.dll

or

php_pdo_sqlsrv_53_ts_vc6.dll and php_pdo_sqlsrv_53_ts.dll

I think I have to get my files from SQLSRV20.EXE as it is compiled with C++ v6 and not the SQLSRV30.EXE which I believe is compiled with C++ v9

I will do further review on the links you have provided.

So my question is this. Do I load both the php_pdo_sqlsrv_53_ts_vc6.dll and php_pdo_sqlsrv_53_ts.dll in my php.ini file?

[Dormilich]

haven’t had to use PDO with SQL server yet, but I can point you to the PDO SQL Server Driver page: http://www.php.net/manual/en/ref.pdo-sqlsrv.php

[Claus Mygind]

Thanks, I been there. And when you read the installation instructions, you can see why I say my installation of php v 5.3.3 falls between the cracks.

When I look in the snapshot.txt file found in the folder where my php.exe is installed, I see this

Version: 5.3.3
Branch: HEAD
Build: D:\php-sdk\snap_5_3\vc6\x86\obj\Release_TS

That tells me I need to download SQLSRV20.EXE Because I need the .dll files compiled with c++ 6.

Again the installation instructions are not clear about which files to install. There are 3 relevant files in the bunch.

php_pdo_sqlsrv_53_ts.dll
php_pdo_sqlsrv_53_ts_vc6.dll
php_pdo_sqlsrv_53_ts_vc9.dll

From this I take it to mean that I at least need the.
php_pdo_sqlsrv_53_ts_vc6.dll

But I also need to install Microsoft SQL Server 2008 R2 Native Client.

Thanks again for all the help.

[Claus Mygind]

Thanks to the help here, I was able to install the right "SQL Server Native Client" and the correct php SQL .dll file on my Apache Web Server so I can now use php script to access data on our SQL Server in addition to our MySQL server.

Because there are different versions of php and SQL servers. I am only going to describe my steps, but instructions on how to properly install for other configurations can be gleaned from the links provide here.

Here are the steps needed to connect.

1. first you have to determine what files are needed. Using a text editor, I opened the "snapshot.txt" file found in the folder where my php is installed. From that I determined, I had the following
php v. 5.3.3
Thread Safe "ts"
compiled with c++ v6

A good link to use to determine your configuration is this http://msdn.microsoft.com/en-us/library/cc296170.aspx

2. Since my web server is a different computer than my SQL server, I had to install SQL Server Native Client. For my setup I installed v 10. which I downloaded from
this link http://www.microsoft.com/en-us/downl...s.aspx?id=3522. Since I am running XP on my webserver I chose the "X86 Package (sqlncli.msi) - 4504 KB"

3. Next I needed to install the correct .dll php driver. From the data I gathered from the snapshot.txt file, I saw that I needed "SQLSRV20.EXE. Which I had figured out from this link http://php.net/manual/en/ref.pdo-sqlsrv.php, I scrolled down the page and clicked on the http://download.microsoft.com/downlo...1/SQLSRV20.EXElink.

4. When I ran SQLSRV20.EXE, I choose my /php/ext folder to extract all the .dll files. It also come with the appropriate API docs so you can read the appropriate syntax for your setup.

5. The last installation step needed was to include the right .dll file to be loaded into my php.ini file. I loaded both regular sqlservr and pdo by adding these lines in the .ini file

• extension=php_sqlsrv_53_ts_vc6.dll
• extension=php_pdo_sqlsrv_53_ts_vc6.dll

So I could choose the syntax that suited me best.

6. Then it was just a matter of reading API docs to write the correct connection script.