Help: Fatal error: Call to undefined function mssql_connect()

I have PHP Version 5.0.3 installed on Windows XP Pro with IIS as the
webserver. All is working well, except I get a -

Fatal error: Call to undefined function mssql_connect() in
C:\Inetpub\wwwroot\CertificateOccupancy\main.php on line 33

line 33: $conn = mssql_connect(toshibo,sa,ladeda) or die ("Could Not
Connect to Database");

when trying to use mssql_connect. Info.php shows that the mssql module
is loading which tells me that where I uncommented

extension=php_mssql.dll

in the php.ini file is working. I have set up paths for both the
c:\php\ext and c:\php directories.

I had PHP 4.3.10 installed on the same box a day earlier, and the
function worked. Also, I am using the ISAPI method for PHP instead of
the CGI if it matters.

Any ideas?

re: Help: Fatal error: Call to undefined function mssql_connect()

Biffo wrote:
[color=blue]
> I have PHP Version 5.0.3 installed on Windows XP Pro with IIS as the
> webserver. All is working well, except I get a -
>
> Fatal error: Call to undefined function mssql_connect() in
> C:\Inetpub\wwwroot\CertificateOccupancy\main.php on line 33[/color]

good way to at least get an idea of what's going on:

if (function_exists('mssql_connect'))
echo "Okay, fn is there"
else
echo "Hmmm .. fn is not even there");


from there you can start to diagnose the problem better.
[color=blue]
> extension=php_mssql.dll
>
> in the php.ini file is working. I have set up paths for both the
> c:\php\ext and c:\php directories.[/color]

does php_info() show the extension as successfully loaded?

[color=blue]
> I had PHP 4.3.10 installed on the same box a day earlier, and the
> function worked. Also, I am using the ISAPI method for PHP instead of
> the CGI if it matters.[/color]

only things i can think of:

1. you've changed something about your SQL Server Installation since then
(does the mssql extension require extra libraries or DLLs or something) ??
2. PHP5 put php.ini in a different location and you're editing the wrong
one. (i.e. you're editing c:\php.ini and PHP5 is looking in C:\windows or
vice versa ...)
3. some paths aren't quite set up to find DB libraries or something.


good ruck.
mark.





--
I am not an ANGRY man. Remove the rage from my email to reply.

re: Help: Fatal error: Call to undefined function mssql_connect()

Biffo wrote:[color=blue]
> I have PHP Version 5.0.3 installed on Windows XP Pro with IIS as the
> webserver. All is working well, except I get a -
>
> Fatal error: Call to undefined function mssql_connect() in
> C:\Inetpub\wwwroot\CertificateOccupancy\main.php on line 33[/color]

IN PHP 5 mysql is be default not loaded... go to you php.ini and remove
to ';' before the mysql.dll extension and put the mysql.dll in your
system32 folder.
It is possible that there are more dll files ( such as libmysql.dll and
a few more) you have to put in the system32 folder.. but you probably
got them all in the php 5 folder...

MI

re: Help: Fatal error: Call to undefined function mssql_connect()

On Wed, 19 Jan 2005 13:28:24 +1100, Muffinman
<blah6#*REMOVE#*THIS#*@custodis.cistron.nl> wrote:
[color=blue]
>Biffo wrote:[color=green]
>> I have PHP Version 5.0.3 installed on Windows XP Pro with IIS as the
>> webserver. All is working well, except I get a -
>>
>> Fatal error: Call to undefined function mssql_connect() in
>> C:\Inetpub\wwwroot\CertificateOccupancy\main.php on line 33[/color]
>
>IN PHP 5 mysql is be default not loaded... go to you php.ini and remove
>to ';' before the mysql.dll extension and put the mysql.dll in your
>system32 folder.[/color]

mysql != mssql.

--
Andy Hassall / <andy@andyh.co.uk> / <http://www.andyh.co.uk>
<http://www.andyhsoftware.co.uk/space> Space: disk usage analysis tool

re: Help: Fatal error: Call to undefined function mssql_connect()

Andy Hassall wrote:[color=blue]
> On Wed, 19 Jan 2005 13:28:24 +1100, Muffinman
> <blah6#*REMOVE#*THIS#*@custodis.cistron.nl> wrote:
>
>[color=green]
>>Biffo wrote:
>>[color=darkred]
>>>I have PHP Version 5.0.3 installed on Windows XP Pro with IIS as the
>>>webserver. All is working well, except I get a -
>>>
>>>Fatal error: Call to undefined function mssql_connect() in
>>>C:\Inetpub\wwwroot\CertificateOccupancy\main.ph p on line 33[/color]
>>
>>IN PHP 5 mysql is be default not loaded... go to you php.ini and remove
>>to ';' before the mysql.dll extension and put the mysql.dll in your
>>system32 folder.[/color]
>
>
> mysql != mssql.
>[/color]


Sorry... but in the end it's probably the same problem anyway.. y=s

MI