some problems with oledb provider

[jayson_13]

Dim conn As ADODB.Connection
Dim rs As ADODB.Recordset
conn = New ADODB.Connection()
rs = New ADODB.Recordset()
Try
conn.Open("Provider=MySQLProv;Data Source=design;
SERVER = 192.168.100.5; DB=designdept;UID=root")

Catch
MsgBox(Err.Source)
MsgBox(Err.Description)
End Try
Try
rs.Open("jobrecordm", conn, ADODB.CursorTypeEnum.adOpenKeyset, ADODB.LockTypeEnum.adLockBatchOptimistic)
Catch
MsgBox(Err.Source)
MsgBox(Err.Description)
End Try
MsgBox(rs.Fields("DATERECD").Value)
rs.Close()
rs = Nothing
conn.Close()
conn = Nothing

this code run perfect on my development comp...
but when i deploy it on my target machine ... it went wrong..
saying "provider error" and the description is "catastrophic failure"
i have installed the same MyOLEDB provider in my target comp and have configured the ODBC perfectly.... and also the .netframework on my target machine.....
I'm using MySQL.
can someone tell me what is wrong?? pls help..
thanx..