Hello.
I'm new to PHP/MySQL and try to create dynamic website using DMX and
already got stuck at beginning!
I've seen topics in similar problems but I could not figure it out.
Please help.

I'm using PHP(5.0.4)/MySQL(4.0.25)/IIS(5) on WinXP pro (SP1). DMX(ver6)

Installed PHP - working fine. can view infor on localhost.
Installed MySQL - working fine. can create databases. can view info on comand prompt.
Installed PHPMyAdmin - working fine. can create databases, can view table info, can create new user.

I've been through tutorial how to set up database connection in this website and error occurs when try to set up connection in DMX.

Choose 'MySQL connection' by pressing + on database tab in Application.
In a dialog, typed as below.
Connection Name: connDMX
MySQL Server: localhost
User Name: username I created on tutorial (dmxzone)
PW: pw Icreated on tutorial (dmxzone)

When I click on 'select' to choose database,
error message appears as "http error code 500 internal server error".
This is the same after typing database name and click 'test'.

The result is the same when I change user name & pw to 'root'.

I disabled firewall of internet connection.
the port I'm using for mySQL is 3306 as a default.
ODBC set up in Adimin tool on Control panel,
created User DSN as localhost with root user name,
created System DSN as the same.
They both (DSN setting) let me choose databases, so connection is made.

I do not figure out why I can not make connection between DMX and MySQL.

Please help me or let me know if you need more information.
Thank you very much!

Problem solved!!!!!

Oh, it was only small mistake as ususal.
I don't know whether it is usuful for anybody but let me state it here.

URL prefix on Testing server was not correct.
That was it!

I specified it same as testing server folder in localhost, dmx let me choose database I like.

Thank you!