ABout Using ADODB in VS.Net 2013

Kedar Pawgi

I have developed my applications using ADODB and MySql as database. I have used MySql ODBC driver for that.

I wish to know the status of ADODB. I am confused about using this ADODB. Now i have installed VS2013. Shall i still continue using ADODB and MySql ODBC driver and use of DSN.

Also i want to know what should i use if i wish to shift to MsSql which is installed while installing VS2013.

I request you to please reply me asap, as i need to take decision for upgrading my old Software to New version of VS2013.

Thanks in advance.

8 Replies

Know the answer? Post it — somebody with the same question will find it here.

Ranjit Powar10y ago
Accepted answer
Yes there is no need of DSN. You can use MysqlClient directly. Just download MySql Connector for .net. And these steps in below article.

http://www.codeproject.com/Articles/43438/Connect-C-to-MySQL

If you get any problem just reply here.

If this helps you, select it as correct answer.
0
Ranjit Powar10y ago
Hi kedar check that link carefully they give full example of query on mysql. They also give description of mysql connection string. Connection string similar like SQL server only change is you have to give mysql login credentials and data source. To work with mysql you have to use namespace using MySql.Data.MySqlClient and then you are able to use mysql classes like MySqlConnectio etc.
0
Kedar Pawgi10y ago
Hi Ranjit Other things i means to say is Insert, Update , Delete and connection string with MSSQL.
0
Ranjit Powar10y ago
What do you mean connecting other things for mssql. Please explain your requirements.
0
Kedar Pawgi10y ago
Thanks Ranjit for the gr8 link. i have gone thru the details. I already downloaded Mysql Connector. I think i already installed that but i was not using that. I have installed Mysql Connector ODBC 5.3. Is tat correct Please let me know. Another request for you is can u give link for connecting and other things for MSSQL. I will be very thankful. Thanks in Advance
0
Kedar Pawgi10y ago
Thanks Ranjit for ur quick reply. I will keep that thing in mind about DSN. But is it possible for you to give me connection string so that to connect to Mysql DB with out DSN. Do i have to use for reading and inserting records. That will be a gr8 help for me. Then there will no question of using DNS. But for this Do i have to use ADODB or just "using Mysql.Data.MysqlClient will work. Also if u can help me out for the same realted to MsSql. Thanks in Advance
0
Ranjit Powar10y ago
Why you create dsn? If mysql connector installed then you can use mysql like SQL server database. You only have to add references of my SQL and use namespace related to mysql.
0
Ranjit Powar10y ago
Why you create dsn? If mysql connector installed then you can use mysql like SQL server database. You only have to add references of my SQL and use namespace related to mysql.
0