By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,983 Members | 1,717 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,983 IT Pros & Developers. It's quick & easy.

Problems with Remote Data Object (RDO) & MySQL

P: 68
Hi,
I am working on Remote Data Object (RDO) & MySQL in VB6. I cann't add record in my table.

If anybody have Solution, Plz send me.

Regards,
shuvo2k6
Feb 1 '08 #1
Share this Question
Share on Google+
5 Replies


lotus18
100+
P: 866
Did you check your sql statement in inserting a record? Does your mysql server is running? Provide much more details for the reference of our experts (e.g some of the codes).

Rey Sean
Feb 2 '08 #2

P: 68
Did you check your sql statement in inserting a record? Does your mysql server is running? Provide much more details for the reference of our experts (e.g some of the codes).

Rey Sean
Hi,
This is code for adding record, here MSRDC1 is a RDO Control,

Private Sub Command1_Click()
MSRDC1.Resultset.AddNew
MSRDC1.Resultset.rdoColumns("ID") = Text1.Text
MSRDC1.Resultset.rdoColumns("Name") = Text2.Text
MSRDC1.Resultset.Update
End Sub

Here MySQL Server is running. Here the shown error is "Resultset is Read-Only". I can also add record by using ADO control, but using RDO, I cann't. Using RDO I can show all records in MSFlexGrid, but cann't insert record. Plz help me by sending code or information.

Regards,
shuvo2k6
Feb 2 '08 #3

lotus18
100+
P: 866
Hi

Did you check its cursor type and the locktype of the connection? Honestly, I really have no idea about using RDO, hopes this helps a little.

In your mysql server, at the user account configuration (I guess), are those all privileges are set to true? If not, check all the checkboxes (privileges).

Rey Sean
Feb 2 '08 #4

P: 68
Hi

Did you check its cursor type and the locktype of the connection? Honestly, I really have no idea about using RDO, hopes this helps a little.

In your mysql server, at the user account configuration (I guess), are those all privileges are set to true? If not, check all the checkboxes (privileges).

Rey Sean
At last, I get success in that job. Thanks Lotus18 to remember the word Cursor. I change the CursorDiver value to useODBC of RDO Control, then I get success.

Thanks, Lotus18. Get Better.

Regards,
shuvo2k6
Feb 2 '08 #5

lotus18
100+
P: 866
At last, I get success in that job. Thanks Lotus18 to remember the word Cursor. I change the CursorDiver value to useODBC of RDO Control, then I get success.

Thanks, Lotus18. Get Better.

Regards,
shuvo2k6
Glad you figure it out : )

Rey Sean
Feb 2 '08 #6

Post your reply

Sign in to post your reply or Sign up for a free account.