I've created a blank PHP page and selected Application > Databases >
MySQL Connection to create a new connection. However, once I've
filled out all the relevant info for the connection and hit the
select button to find my database I get the follwing error message:

"HTTP Error Code 500 Internal Server Error"

Anybody know why this is happening?

This is going to sound daft, but here goes due to lack of info.

Have you installed mysql client and server to your pc ?
Have you installed the mysql odbc ?
Have you configured the mysql server with username and password.

Have you confiqured the database with the same username password etc.

More info would help to find you a solution.


Iain

head hurts, 'mental note to self, stop banging head !'

I'm actually having the same problem. I've done the following to try to find a solution to the problem...

1) Tried manually connecting to SQL
2) Reinstalling my server and DW
3) Installed MySQL ODBC (never needed to before).


The problem began occuring after my computer crashed. I had to reformat and reinstall everything. Now I keep getting the pesky 500 Internal Server Eroor. I'm able to connect via PHP pages and do everything to the database. I'm also able to use PHPMyAdmin without a hitch. My Username and Password are fine. So what's up?!!?!

I'm using Apache / MySQL / PHPMyAdmin (all the latest stable versions).

Anyone know what I should do!? E-mail me @
Thanks.

Am
-----------------
In artformation

Edited by - Amtek on 07 Jul 2004 01:41:16

It took me a week... but I finally figured out the problem I've been having...

I have NO idea why this works... but it does.

1) I installed MySQL ODBC - from the MySQL site
2) I configured DMX with the following info -
Server type - PHP/MySQ:
Host - localhost
User -
Pass -
Database - your_db
as you can see the user and pass are NULL. Yes... that's why I've been getting the 500 internal server error. Stupid, huh? I figured this out by a fluke.

3) Go into phpMyAdmin and make sure that the user ANY for localhost has no password. That's that.


Hope I saved you a weeklong headache. Time for me to do some backflips!!!

--------------
artform.ca/

Edited by - Amtek on 08 Jul 2004 04:36:36