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.

Answer 1

Hi Siri,

Try this...



Edit your app config file



<add key="DBCon" value="Data Source=SU86;Initial Catalog=siri;Integrated Security=True"/>


Thanks