Convert SQL Server 2000 to MySQL Database

Question

User-763776826 posted

I want to covert my SQL server database to MySQL.

Please help me how to add dll of MYSQL in asp.net application and how we can use it.

Answer 1

User500621135 posted

for conversion there is software

below this link you can download This S/w for the conversion........... after conversion .......you can normally use Mysql as

you use ms-sql server

If you face any problem then inform me [e-mail] 

Answer 2

User-763776826 posted

thanks for your response ....actually i want to know how i can add dll in my asp.net application....i add it in bin folder and make the reference of it through add reference but the probelm is that when i write using using MySql.Data; its not working .......

Answer 3

User500621135 posted

y???? u write using using mysql;

Answer 4

User-763776826 posted

its working ...........but now another problem arise when i connect mysql database with the asp.net application then error occur..MySQL ODBC 3.51 Driver not found update mysqlclient.......

Answer 5

User500621135 posted

hello "manisha walia",

in my office i also used Mysql server"

there is problem in your Mysql server..........

your's mysql server is not properly install........... please reinstall your's Mysql server..... odbc connector and 1 more software that i forget this time

you have to reinstall these software

Then, wrote the coonection string in following way

odbcConnectionString con=odbcConnectionString("DRIVER={MySQL ODBC 3.51 Driver};server=servername;database=dataasename;uid=username;pwd=password;");

I hope it work's and again if you found any problem then, please email me [e-mail]