Sorry if this has been asked before, but I can't seem to find a way to search the forums. Anyhow, I don't know why my code isn't working. I'm writing some test apps in C#, using MySQL for a back-end database. I've been able to connet via ASP 3.0 & C/C++. I have system DSN set up and would like to be able to connect either trough the driver itself or through the DSN. Here is my DSN code:<BR><BR> private void Page_Load(object sender, System.EventArgs e)<BR> {<BR> string ConnString = "Provider=MySqlProv;DSN=lacklusterDSN;";<BR> OleDbConnection DataConn = new OleDbConnection(ConnString);<BR> OleDbCommand SQL_Statement = new OleDbCommand("Select * from ****balls", DataConn);<BR> Response.Write(DataConn.State + "<BR>");<BR> DataConn.Open();<BR> Response.Write(DataConn.State + "<BR>");<BR> DataConn.Close();<BR> Response.Write(DataConn.State);<BR> }<BR><BR>Any help is appreciated. THanks.those blanks should be <br> .. If forgot html was allowed.
ADO & MySQL
- Thread starter Stiltman
- Start date