Code works in apache but not in IIS

[yahoo182]

This works in apache but for some reason not in IIS6 (windows2003). I am using PHP4.* on both systems.
I have tried the IP address instead of localhost but I still get the same reasult .....

any input will be much appriciated.
Thanks!

// establish db connection
$dbcnx = @mysql_connect('localhost', 'user', 'passwed');
if (!$dbcnx) {
die( '<p>Unable to connect to the database server at this time.</p>' );
}
if (! @mysql_select_db('hotelInfo') ) {
die( '<p>Unable to locate the hotelInfo database at this time.</p>' );
}

 

[vbkris]

what error does it say???

Known is handfull, Unknown is worldfull

 

[sleipnir214]

Yeah. "It doesn't work" is a pretty vague description.


Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[yahoo182]

When I access the php file with a browser, I get the reply
"Unable to connect to the database server at this time"

Is there anyway I can find out what went wrong more precisely?

Thanks, and sorry bout the vague description ... !

 

[yahoo182]

Hi there,
This is what I get for the following message.

db connect error:Client does not support authentication protocol requested by server; consider upgrading MySQL client


In this case, what is Client referring to? Is it my browser or my php version?
or is it the MySQl that is installed on my IIS server?

Actually, I have downloaded the most recent items for all of them.

 

[sleipnir214]

Your MySQL server version is 4.1 or newer, right?

http://dev.mysql.com/doc/mysql/en/old-client.html

Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[yahoo182]

Thanks!!!
that did the tick.
I used the old_password() method to revert the pw format in my newer mysql.

Thanks!