Hi,

I have setuped a iis webser under win2k3 svr with PHP installed.
up to now php is working very well.
today i installed mysql 4.1 and i tryed to connect to the server named localhost.

the follwoing error appear.

Call to undefined function mysql_connect() in E:\MySQL Projects\connect.php on line 2

Why this mysql statement is not working in the server?
any configuration requir?

Pls...

Yes, it seems there is a sloution to this problem here http://drupal.org/node/27119

I did not checked it with my php server yet....

upload a file called phpinfo.php to the root folder. it's only contents will be:

PHP Code:

<?php
phpinfo();
?>

Load this file in your browser (and refer to it whenever you have a php related problem).

Reply with the version of PHP you're running and whether you see any 'MySql' entries in phpinfo's loaded extensions.

Originally Posted by metho

upload a file called phpinfo.php to the root folder. it's only contents will be:

PHP Code:

<?php
phpinfo();
?>

Load this file in your browser (and refer to it whenever you have a php related problem).

Reply with the version of PHP you're running and whether you see any 'MySql' entries in phpinfo's loaded extensions.

Thanks Metho,

I double checked. there is no MYSQL in the phpinfo()

I also have removed the semicolon of ' ;extension=php_mysql.dll '

also the php.ini shows the extension folder as extension_dir = "./" Is this correct path?

i dont have a extensions folder ("C:\php\ext\") under my php installation. only php contain 3 folders call 'session data', 'uploadtemp' & 'backup'. there is no ext foler.

My problem is still there

Originally Posted by afridy

also the php.ini shows the extension folder as extension_dir = "./" Is this correct path?

I'm not a windows expert, but I believe it's supposed to be

extension_dir = "C:\PHP\ext"

With windows I've been working off Apache Distributions like XAMPP, so it's been a while since I've installed a server by individual files but I recall PHP also supplying the extensions as a separate download to reduce the file size.

You will most likely have to download this and extract it into your PHP folder. You will then need to change php.ini so that the extension_dir points to the correct location.

You'll also need to check that you've uncommented the extension php_mysql.dll and also near the bottom of php.ini look over the [mysql] section to see if any changes need to be made, but most likely it all can be left blank to resort to default settings.

Cheers,

MC

Thanks article and master computer.

Finally i have come to this error.

>> unable to load dynamic library './php_mysql.dll' - The specified module could not be found. <<

I think now i sould try 'MASTERCOMPUTERS' suggestion.

i ll come back....

Originally Posted by mastercomputers

With windows I've been working off Apache Distributions like XAMPP, so it's been a while since I've installed a server by individual files but I recall PHP also supplying the extensions as a separate download to reduce the file size.

Yes - I think the extended php extention library is called PECL LIB and is a seperate download.

Thanks every body fist of all,

I have downloaded the extension dlls and put every thing in correct place.
so i have overcome the error ;

unable to load dynamic library './php_mysql.dll' - The specified module could not be found.

But another error after this;

Unable to load dynamic library 'e:\php\extensions\php_mysql.dll' - The specified procedure could not be found.

"The specified procedure could not be found."
Whats wrong? Now what i should do friends?

Again i am running PHP 5 + mysql 5 + 2k3server + IIS6

Pls.....

I think the error means that the PHP engine has called an internal procedure to load the mysql module and could not find it, Simply...
But this tells you where to put the extension.

In the unix world ./ means "in the current directory", like "." does.
So, it means that you must place your php_mysql.dll file in e:\php\extensions for the PHP engine to find it.

Or update the php.ini file to match another place where to look for the modules.

I can't give you more specific details, as I only run PHP on linux/bsd servers, and never tried to do that on a windows machine for the last 4 years...

Thanks tripy for the comment. but i tried all your solutions. no result.

After searching the net for hours and hours i found that, if you try to find answer to this qustion you will end up banging the head against the wall.

Here is what i found :

PHP 5.0 + MySQL 5.0 + IIS6 + 2003 Will never work to gether.
that mean if you manage to get ride of the error "Unable to load dynamic library 'e:\php\extensions\php_mysql.dll' - The specified procedure could not be found. " then your must be some one special.

There is a nice 3 page discussion specially regarding the above error. pls have a look if you have time.
http://codewalkers.com/forum/index.p...=370&startat=0

I gonna go back to php 4 + mysql 4 = IIS 6 + 2K3SVR.

bye.

Why don't you try apache?

Originally Posted by jito

Why don't you try apache?

Hai, Jito.

Apache may be the best. but i was trying iis for students .

Hai there.

I just removed PHP5 and MySQL5, downloded the binary version 4.4 from http://snaps.php.net/ and no trouble at all with IIS6 Under 3ksvr.

Bye Bye