How do I apply the OBDC / DSN to the testing server?

Can someone advise the solution to this or if it is already posted on another query, tell me where the solution is posted

I get this error message

Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

I am using

Windows XP Pro
Dreamweaver MX2004
IIS is running
MySQL is running
Installed MyOBDC
I have created an OBDC / System DSN connection to the database I have MDAC installed

HTM pages work in the localhost Testing Server on my computer My ASP pages which use MS Access database work on the localhost testing server

With MySQL database on the localhost testing server I get the above message. Load this page onto your server and test it through my domain and the page works. So the problem is somewhere in the setting up of MySQL / Localhost / DSN

With Dreamweaver you can test a connection on the local machine which works with the MySQL and the DSN connection, or you can test on the localhost testing server which does not work.

When creating a connection using Dreamweaver and the testing server option you can see the DSN connection, but can not access the database

How do I apply the OBDC / DSN to the testing server?