Solved

PHP on IIS7 + MS SQL

Posted on 2010-08-18
4
848 Views
Last Modified: 2013-12-13
i have setup PHP to run on IIS with no issues, but am now trying to connect to MS SQL 2005 and am having issues, i have tried several different code samples and just get a blank page, I ran PHP from C:\PHP in a command prompt and got the below 2 errors, which i am guessing is part of the problem, just not sure how to fix - what do i need to do?

c:\PHP>php
PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\php5\php_mssql.dll
' - The specified module could not be found.
 in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\php5\php_wincache.
dll' - The specified module could not be found.
 in Unknown on line 0
0
Comment
Question by:dkilby
  • 2
  • 2
4 Comments
 
LVL 8

Expert Comment

by:Jessie Gill, CISSP
ID: 33470707
It looks like you are missing the DLL files

you should have a folder called ext in your PHP root directory.  This is where teh above dll's need to be.  Once they are copied restart IIS.
0
 

Author Comment

by:dkilby
ID: 33470725
Inside the php folder there is a 'ext' folder and inside i can see php_mysql.dll and php_mysqli.dll, cant see the php_wincache, will try and find it, but the sql one i can see
0
 

Author Comment

by:dkilby
ID: 33470728
ok just realized what i was reading as MS is actually MY SQL - where can i get php_mssql.dll from?
0
 
LVL 8

Accepted Solution

by:
Jessie Gill, CISSP earned 500 total points
ID: 33470827
I acually got mine from version 5.2.14 , You could take teh DLL from taht and give it a try.  You are probably using 5.3

here is a link that may help

http://php.net/manual/en/install.windows.extensions.php
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Both Easy and Powerful How easy is PHP? http://lmgtfy.com?q=how+easy+is+php (http://lmgtfy.com?q=how+easy+is+php)  Very easy.  It has been described as "a programming language even my grandmother can use." How powerful is PHP?  http://en.wikiped…
This article discusses four methods for overlaying images in a container on a web page
The viewer will learn how to count occurrences of each item in an array.
The viewer will learn how to create a basic form using some HTML5 and PHP for later processing. Set up your basic HTML file. Open your form tag and set the method and action attributes.: (CODE) Set up your first few inputs one for the name and …

932 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now