Jump to content


Photo

Connecting to MS SQL


  • Please log in to reply
6 replies to this topic

#1 urisk23

urisk23

    Newbie

  • New Members
  • Pip
  • 2 posts

Posted 11 January 2013 - 03:34 PM

I am pretty new to php, and I feel like I am missing something pretty fundamental. I am trying to connect to SQL Server.

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:
extension=php_sqlsrv_53_ts.dll

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.

#2 kicken

kicken

    Wiser? Not exactly.

  • Gurus
  • 2,731 posts
  • LocationBonita, FL

Posted 11 January 2013 - 06:59 PM

Did you install the Microsoft SQL Server 2012 Native Client?  You need that for the driver to work properly.  You can download it from http://www.microsoft...s.aspx?id=29065
Recycle your old CD's, don't trash them!
Did I help you out?  Feeling generous? I accept tips via Paypal or Bitcoin @ 14mDxaob8Jgdg52scDbvf3uaeR61tB2yC7

#3 urisk23

urisk23

    Newbie

  • New Members
  • Pip
  • 2 posts

Posted 28 January 2013 - 02:42 PM

Sorry I didn't reply earlier. Yes. I installed the Native Client. No luck.

#4 budimir

budimir

    Advanced Member

  • Members
  • PipPipPip
  • 462 posts
  • LocationCroatia

Posted 05 May 2013 - 03:42 AM

Did you mange to fix you're problem?

 

You should try with this:

 

extension=php_sqlsrv_53_ts_vc9.dll


I'm learning..... Still don't know nothing!

#5 wmeredith

wmeredith

    Member

  • Members
  • PipPip
  • 23 posts

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

 

Any thoughts?



#6 Boxerman

Boxerman

    Advanced Member

  • Members
  • PipPipPip
  • 222 posts

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.



#7 wmeredith

wmeredith

    Member

  • Members
  • PipPip
  • 23 posts

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

Cheap Linux VPS from $5
SSD Storage, 30 day Guarantee
1 TB of BW, 100% Network Uptime

AlphaBit.com