vb6-mysql-[Not able to update data]

[raj kp]

I am very new to mysql..migrating from access..
Im not able to update data in mysql from vb6. My connection string and procedure for saving the data is mentioned below.im getting an error ["INSUFFICIENT BASE TABLE INFORMATION FOR UPDATING & REFRESHING "]. Could any one plz hepl me for this..
(same method is used with Microsoft.Jet.OLEDB.4.0). thnks in advance

RAj

Public db As Connection
Public Sub ConnectDB()
Dim str As String

Set db = New Connection
str = "Provider=MySqlProv;Data Source=test;Integrated Security=SSPI;Password="";User ID="";Location="";Extended Properties="""

db.Open str

-----------------------------------------------------------------------------------



Public Sub SaveGL()
Dim rstGl As Recordset
Set rstGl = New Recordset
Dim str As String
Dim job
str = "SELECT * FROM emp;"
rstGl.Open str, db, adOpenKeyset, adLockOptimistic

rstGl.AddNew
With frmGL
rstGl!id = LTrim(Val(.Text1(0).Text))
rstGl!Name = LTrim(.Text1(1).Text) -->textboxes to enter id & name

End With
rstGl.Update