[aniri]

Has anyone encountered mysql server errors on vista and not on xp for the same script?

I've a script that connects to the database and works ok on xp with firefox and ie, but not on vista.

On vista I'm getting the following error:

Custom Message : Connection attempt failed

Error Number : 2005

Error Message : Unknown MySQL server host 'SERVER_NAME' (1)

The SERVER_NAME is set to 'localhost'

[RudiVisser]

The constant obviously just isn't set.

You can check what's set by using print_r(get_defined_constants(true));.

[aniri]

But it works on xp..so it has to be set :|

[JackOfAllTrades]

Obvious questions: Is the server running? Is Windows firewall set to allow connections? Is localhost == 127.0.0.1 in your HOSTS file?

[Arenlor]

How exactly are you trying to connect to the database? Are you using strings?

mysql_connect('localhost','mysql_user','mysql_password'); //Strings
mysql_connect(localhost,mysql_user,mysql_password); //No strings

Make sure to use strings, other things to check are the port MySQL is listening on, and see if the following works:

mysql_connect('127.0.0.1','mysql_user','mysql_password');

That will see if it's just localhost that is bad, or if the connection is.

[RudiVisser]

aniri, on 27 April 2010 - 11:37 AM, said:

But it works on xp..so it has to be set :|

"My new car doesn't have air conditioning"
That's because you didn't ask for it.
"BUT MY OLD ONE DID"

Try checking that the constant is defined as per my code. It's clearly not being expanded either way.

Arenlor, on 27 April 2010 - 05:51 PM, said:

How exactly are you trying to connect to the database? Are you using strings?

mysql_connect('localhost','mysql_user','mysql_password'); //Strings
mysql_connect(localhost,mysql_user,mysql_password); //No strings

Make sure to use strings, other things to check are the port MySQL is listening on, and see if the following works:

mysql_connect('127.0.0.1','mysql_user','mysql_password');

That will see if it's just localhost that is bad, or if the connection is.

He's using constants, not meant to be strings.