PHP and MS SQL SERVER

revez2002

Hello,

We are running PHP 5 on a local Windows 2003 server that also has IIS 6.0 installed. There is no problem viewing web pages, and PHP seems to be working, as there are no errors when using a number of different PHP functions.

However, when we attempt to call mssql functions, we receive the following error:

Fatal error: Call to undefined function mssql_connect() in D:\Web\Projema\pro_authenticate.php on line 2

We have enabled the mssql extension (extension=php_mssql.dll) in the php.ini, but we continue to receive the previous error.

Has anyone out there had a similar issue?

Revez

Houdini

What shows in phpinfo() when you run it?
you should have a table that looks something like the below.

mssql
MSSQL Support enabled
Active Persistent Links 0

Active Links 0

Library version 7.0

Directive Local Value Master Value
mssql.allow_persistent On On
mssql.batchsize 0 0
mssql.compatability_mode Off Off
mssql.connect_timeout 5 5
mssql.datetimeconvert On On
mssql.max_links Unlimited Unlimited
mssql.max_persistent Unlimited Unlimited
mssql.max_procs Unlimited Unlimited
mssql.min_error_severity 10 10
mssql.min_message_severity 10 10
mssql.secure_connection Off Off
mssql.textlimit Server default Server default
mssql.textsize Server default Server default
mssql.timeout 60 60

of coourse it will be in a table, that is just the raw information. I am not sure about IIS PHP installs but I believe that the php.ini would be located in WINDOWS\system or WINDOWS\system32 folder. Anyway did you restart the server after you made the changes? Also you might want to do a hard drive search for php.ini and be sure there are not more than one of them and if so edit them one at a time to enable the MS SQL then restart and run phpinfo() till it changes, then make a note of the location where the php.ini that just caused the change and edit it from now on since that is apparently the 'active' php.ini