Connecting to MySQL with VB .net - Standard Edition

[CharlieMike73]

Hello,

I just bought Visual Studio (Visual Basic) .net - Standard Edition with a VB .net book, and need to connect to a remote MySQL database that has the data that I need to develop an inferface for.

For some reason I get told that I can ONLY connect to MS Access or a MS SQL server when I try to configure the ODBC connection string in VS .net.

The MySQL ODBC is installed and configured correctly - I have used this to import (link) the tables into a local MS Access DB, but I want to connect directly.

How do I do this?

Or if this is a limitation on the version I have, which I sure to god hope is not the case; because I have to be able to connect to Oracle 8i too, how do I link to the MS Access tables and include the date from them?

I have done some ASP before, but I have never used the VS .net interface to create a web form so any help is greatly appreciated.

Also any sites that people could recommend would be of a great help too, especially ones talking about Oracle and MySQL DBMS’s with ASP .net and/or VS .net.

Thank you,
Charlie

 

[buddyel]

See if this site helps any....

http://www.able-consulting.com/ADO_Conn.htm

 

[CharlieMike73]

Thank you, I just read your article and visited that, found the following...

oConn.Open "Driver={mySQL};" & _
"Server=db1.database.com;" & _
"Port=3306;" & _
"Option=131072;" & _
"Stmt=;" & _
"Database=mydb;" & _
"Uid=myUsername;" & _
"Pwd=myPassword"

Not exactly sure what to do now - LOL - any additional help is appreciated.