PHP don't connect MSSQL server

Anon

Localhost write: "call to undefined function mssql_connect()". What to do?

lobobr

You have to enable MS SQL support on php.ini.

From PHP Official site:

"The MSSQL extension is enabled by adding extension=php_mssql.dll to php.ini."

Do a search for "php_mssql.dll" on php.ini. If this line exists and starts with a semicolon, it is commented. Just delete the starting semicolon.

If the line doesn't exists, create it.

Best regards,

Er Gakvão Abbott

purgy

I did as described in php manual.

Library php_mssql.dll is where has to be, but PHP cannot load it. SQL
Server drivers are installed and MSDE 2000 is running on my machine on Windows 2000 Professional.

When I try execute any php file i get:

A popup WARNING:
Unable to load dynamic library 'c:\program
files\php\extensions\php_mssql.dll' - The specified module could not be
found.

Then i click OK button and i get following text :

X-Powered-By: PHP/4.1.1 Content-type: text/html

The line of code I used, is the following:

$db =

mssql_connect("MyComp","myUserName","myPassword");

Please Help !!

lobobr

This is not a syntax error of your connect statement. This popup error is previous to any mssql function.

This is a php.ini error.

PHP can't find the mssql dll so it doesn't run anything.

1) Are you 110% sure that the dll is on "c:\program
files\php\extensions\" ?

I have PHP on C:\PHP, so my dll is on C:\PHP\extensions

2) Are you 110% sure that the extensions directory specified on the extension_dir variable matches your?

As on my computer, my extension_dir is setted like this:

extension_dir = c:/php/extensions

3) Have you tried stop and restarting IIS or even rebooting the machine?

Hope it helps.

looialex

Hi,

I do not understand your step 2:

2) Are you 110% sure that the extensions directory specified on the extension_dir variable matches your?

As on my computer, my extension_dir is setted like this:

extension_dir = c:/php/extensions

Please advise me how I go about doing it.

Many Thanks!

PhiSYS

Make sure that PHP/IIS (IUSR_YOURMACHINE) have the right NTFS permission to read/execute the dlls in this directory.

looialex

I am sorry but I am not very familiar with all these settings.
So how do I go about doing it?

PhiSYS

Right-click the extensions directory or dlls, then "properties", then go to "security" tab and ADD the user IUSR_WhatEverYourComputerNameIs with read/execute permission

looialex

Ok I actually didn't add in that extension statement (extension_dir = c:/php/extensions) into the php.ini file.

Now there is another error.
It says :

"
An error occurred trying to update the database
Changed database context to 'forum'.
"

Any advice?