I'm trying to connect to my MySQL server using VB.net.
below is my code:

dim conn As ADODB.Connection
dim rs As ADODB.Recordset
dim sql As String
conn = New ADODB.Connection()
s = New ADODB.Recordset()
sql = "SELECT * FROM USRPWDRECM WHERE REC_USRID = '" & Trim(txtUsrID.Text) & "';"
conn.Open("Provider=MySQL; Initial_Catalog=designdept; Data Source=tang;")

rs = conn.Execute(sql)

my it give me error
"Provider not found "
i have install MyODBC3.51 and 2.50 and had test the Data Source.
it's perfect.. pls tell me wat is wrong!