Connecting to MS SQL
Posted 11 January 2013 - 03:34 PM
A little background: I have a wamp server that I am using personally for my own web applications. At work we use SQL Server, and my Boss wants me to explore adding a bit of web functionality to our applications. We use SQL Server at work.
I thought it would be less disruptive to the our work environment if I start by using my personal wamp server on my workstation.
So I downloaded SQLSRV30.EXE and installed the files in C:\wamp\bin\php\php5.3.10\ext.
I have added the following line to the C:\wamp\bin\php\php5.3.10\php.ini file in the Extensions section:
and restarted the server.
I have seen other web sites that tell me I should see sqlsvr in the Registered PHP Streams (in the phpinfo page). I do not. And of course the sqlsvr calls don't work.
I receive errors like: Fatal error: Call to undefined function sqlsrv_connect()
Here is at least one piece I really don't understand. In my phpinfo page the "Loaded Configuration File " reads, "C:\wamp\bin\apache\Apache2.2.21\bin\php.ini" However, this doesn't seem to be the case. I have renamed that file, and I have modified that file in various ways, and it seems to have no affect. However, when I modify the C:\wamp\bin\php\php5.3.10\php.ini, and restart the server, it clearly does have affect. For instance, I tried the nts version and when I restarted the server, it failed pretty dramatically.
jic, I put the extension line in both php.ini files.
Anyway, I feel like I am missing something pretty fundamental. Any help would be appreciated.
Posted 11 January 2013 - 06:59 PM
Did I help you out? Feeling generous? I accept tips via Paypal or Bitcoin @ 14mDxaob8Jgdg52scDbvf3uaeR61tB2yC7
Posted 28 January 2013 - 02:42 PM
Posted 05 May 2013 - 03:42 AM
Did you mange to fix you're problem?
You should try with this:
Posted 05 August 2013 - 10:38 PM
I'm having the same problem. I made the additions needed to the php.ini and added the "php ext" path, installed Microsoft SQL Server 2012 Native Client,
but when runnin the phpinfo script it doesn't reflect that the php drivers are loaded for SQL SRV.
Also the dll files that should be loaded according to documentatiion is php_sqlsrv_54_nts_vc9.dll but the extracted files don't have that file listed. The one listed is php_sqlsrv_54_nts.dll
Posted 06 August 2013 - 10:01 PM
How are you hosting?
WAMP? if so make sure you installed the right version (i.e 32 bit for 32 bit) most people get this when they install the 32bit on a 64 bit system.
Posted 06 August 2013 - 10:18 PM
I figured it out. I was making changes to the wrong php.ini file. The phpinfo page revealed where the actual php.ini file was residing and when I added the changes it worked!
You would thing it would be c:\php and c:\php\ext for all the needed extentions but no it was "C:\Program Files (x86)\PHP\php.ini" and "C:\Program Files (x86)\PHP\ext"
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users