Can't connect with known good connection info

[abbandono]

I've got as far as having the front page of CodeGenie working, but I can't get a database connection from the lamp.

It gives me a "Could not connect to the database with the information provided." error.  I;ve tried dropping and recreating the user account to make sure there are no password typos, etc.  The credentials are definitely good.

Here's the connection string quoted to me by my hosting provider.  Maybe this is an issue with compatibility between their version of Myspace and PCG?

$dbh=mysql_connect ("localhost", "xxxxxxxx_sa", "<PASSWORD HERE>") or die ('I cannot connect to the database because: ' . mysql_error());

[repcode128]

Need more info. what operating system, what server,
what type of database, what version of PHP?

[abbandono]

Here are the details from PHPinfo:

PHP Version 4.3.10

OS: Linux baseone.tlm.com 2.4.21-32.0.1.ELsmp #1 SMP Tue May 17 17:52:23 EDT 2005 i686

Server API: Apache

PHP API: 20020918

And here's the DB info:

MySQL - 4.0.27-standard
Protocol version: 10

[repcode128]

are you able to connect to the database with any other programs? Is it set up on a web host or your local computer?