-
ODBC and MySQL
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 ?
-
how you set up your datasource in
control panel->Administrative Tools->Data Sources (ODBC)
?
-
Thats exactly how i do it.