Jump to content


Photo

Connect PHP to MSSQL


  • Please log in to reply
2 replies to this topic

#1 colmtourque

colmtourque
  • New Members
  • Pip
  • Newbie
  • 2 posts

Posted 24 April 2006 - 03:26 PM

I have installed PHP 5 on an server 2003 IIS Box running MSSQL.

I have the latest version of ntwdblib.dll as and have uncommneted the mssql extension yet I am still getting the following error when I attempt to connect.
"
PHP Warning: PHP Startup: Unable to load dynamic library 'c:\php\ext\php_mssql.dll' - The specified module could not be found. in Unknown on line 0
"

Driving me quite insane, any help would be appreciated or the path to an exceedingly detailed turtorial on getting mssql and php to play nice, I would really love to be able to get this to work and not have to go back to using ASP. I have done php and mysql, php and postgresql, by Bill does not seem to want to play nice. In case you wondering the sql server is already in place so it can't be removed from the equation.

#2 ober

ober
  • Staff Alumni
  • Advanced Member
  • 5,337 posts
  • LocationEast Coast, USA

Posted 27 April 2006 - 12:05 PM

Make sure you've done this:
The extension requires the MS SQL Client Tools to be installed on the system where PHP is installed. The Client Tools can be installed from the MS SQL Server CD or by copying ntwdblib.dll from \winnt\system32 on the server to \winnt\system32 on the PHP box. Copying ntwdblib.dll will only provide access. Configuration of the client will require installation of all the tools.

Info: PHP Manual


#3 colmtourque

colmtourque
  • New Members
  • Pip
  • Newbie
  • 2 posts

Posted 27 April 2006 - 12:34 PM

Thanks, I actually got it fixed, I used a modified install version of php (it's worked in the past). But I got fed up blew it all out an then did the manual install and got it all working.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users