hello everyone

i have some question about odbc connection
i use mysql database so i can't use oledb provider
but i can also use "Microsoft.Data.Odbc.OdbcConnection()"
but when i connect the database there is some error when i use open function .
i have no idea about this when i use oledb provider it's ok .


code :
Dim connstrx
connstrx = "Provider=MSDASQL.1;Persist Security Info=False;User ID=root;Data Source=rpmsmysql"
Dim odbcconn As New Microsoft.Data.Odbc.OdbcConnection()
Dim odbcconn As OleDb.OleDbConnection
odbcconn.ConnectionString = connstrx
odbcconn.Open()

for ODBC,
did you download the following link ?
http://www.microsoft.com/downloads/d...2-D165078E32B1

then you should right click on the references under your solution and add it there.
the path that should browse from is :
C:\Program Files\Microsoft.NET\Odbc.Net

hope it helps.