I have finished development of a web application using VS.net 2002, ASP/VB.net and MySQL.

Everything is working great on my local machine (XP Pro) so I tried transferring everything over to the live server (2000 server).

I did the following :

1) Installed mysql and imported database.
2) Downloaded and installed the ODBC driver from MySQL.
3)Copied my files onto the server and set up IIS.

When I run my page I get the following error message :

"mysql ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified "

I have been trying at this all day with no luck.

Can anyone please help ?