A test connection made to the database was NOT successful.

[proane]

System Config: Windows 2000 /w IIS, MySQL and PHP 4

I am on step 5 and 7 where the install is trying to make a test connection to my database and I keep getting this error:

osCommerce Configuration

A test connection made to the database was NOT successful.

The error message returned is:

Table 'catalog.configuration' doesn't exist

Please click on the Back button below to review your database server settings.

If you require help with your database server settings, please consult your hosting company.

What I dont understand is, during step 3 I was still able to create and import a database called 'catalog'. Now for some reason its not letting me connect to it anymore, originally i had created the database on:

Localhost, username, no password and database 'catalog'

Now when I am doing step 5 I have tried a plethora of different host names, localhost, the actual ip, the actual domain name, etc. and I still keep getting this error. When looking with Mysqlwinadmin at the "catalog" database, everything seems to be inside there, so why can't I seem to connect?

I have searched the forums far and wide for any help, yet cant seem to find anything. I've set up osCommerce on windows and linux boxes before with apache but never IIS. I am at this point completely frustrated with Windows and if it werent for the clients demands i would be on *nix /w Apache in a second. Please help me have a good weekend.

[jpf]

Take a look at BOTH your configure.php files and modify them by hand.

  define('DB_SERVER', 'localhost'); // eg, localhost - should not be empty for productive servers
  define('DB_SERVER_USERNAME', 'your_user_name');
  define('DB_SERVER_PASSWORD', 'your_password');
  define('DB_DATABASE', 'your_database_name');
  define('USE_PCONNECT', 'false'); // use persistent connections?
  define('STORE_SESSIONS', 'mysql'); // leave empty '' for default handler or set to 'mysql'

I use phpMyAdmin. I did not like MySQLWinAdmin.