How to use odbc.net and MySQL database

[Ook]

I'm missing something here. I've installed odbc.net. I've installed the
latest dotnet SDK. I'm following the walkthrough in the msdn to create an
asp.net c# app. I get to the point where I put the sqlDataAdapter on the
component1.cs, but I'm not sure how to configure it. Selecting the MS OLE DB
Provider for ODBC Drivers, and selecting my MySQL DSN passes the "Test
Connection" test, but if I try to save it I get "The connection you have
created does not work with the current adapter". The same DSN works fine,
it's not the DSN, it's what I'm trying to do in C# that isn't working.

What am I missing? I'm not quite sure how to use odbc.net to connect to the
MySQL DSN.

 

[MP]

I'm not sure but beter try with:

-> odbcDataAdapter

NOT sqlDataAdapter

MP

 

[Ook]

There are no odbcDataAdapters - either that, or I don't know where to find
it. My choices seem to be limited to OleDb... or sqlDat.... How do I use an
odbcDataAdapter?

 

[Peter Wu]

Ook> I'm missing something here. I've installed odbc.net. I've installed the
Ook> latest dotnet SDK. I'm following the walkthrough in the msdn to create an
Ook> asp.net c# app. I get to the point where I put the sqlDataAdapter on the
^^^^^^^^^^^^^^
This is for
MSSQL Only.

Ook> component1.cs, but I'm not sure how to configure it. Selecting the MS OLE DB
Ook> Provider for ODBC Drivers, and selecting my MySQL DSN passes the "Test
Ook> Connection" test, but if I try to save it I get "The connection you have
Ook> created does not work with the current adapter". The same DSN works fine,
Ook> it's not the DSN, it's what I'm trying to do in C# that isn't working.

Ook> What am I missing? I'm not quite sure how to use odbc.net to connect to the
Ook> MySQL DSN.

Use OleDbConnection and OleDbDataAdapter.

 

[Ook]

Time to take a setp backwards - are there any beginner guides for the dotnet
absolutely clueless? Not only am I not able to make this work, I'm not even
sure what to try.