connecting to a MySQL server

Question

2 questions. 1. can I connect to a MySQL server using the System.Data.SqlClient namespace? if so what kind of connection string do I use? if not I assume i need to use ODBC is this correct? 2. the MySQL server is on a different computer (that is posing as a server <_<) how do I specify this in the connection string? thanks for all your help in advance. I'm only used to work on a local MSSQL server so I may have some other quesitons in the future.

Binu Subi · Answer

Visit http://www.connectionstrings.com/ to get info on connection strings for virtually every data sources.

Dennis S · Answer

Hi forte You can use OdbcConnection class to connect to mySQL database. But using mySQL you have to be careful what version you are using each versions has limitations. Answer to your first question. Yes you can connect to a mysql database. Answer to second question Please see online manual at this site: dev.mysql.com. Hope this helps you. Dennis