odbc aaarrrggghhh

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 ?

the only things that is coming in my mind:
- you got different ODBC Drivers or mdac. you can install the latest version from microsoft.com/download
- you got mis spelling driver name in your dsn file
- there's something really wrong with your .net framework, I never work with .net because I don't feel safety to get into that and maybe its one of that

hope It could help.
S. Mohammad Najafi