473,320 Members | 1,713 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Problems with Remote Data Object (RDO) & MySQL

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
5 2244
lotus18
866 512MB
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
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
866 512MB
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
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
866 512MB
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

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

Similar topics

2
by: Johann Blake | last post by:
If you are, I'd be interested in knowing what kinds of applications you are working on and the problems, if any, you are confronting. Best Regards, Johann Blake CloserWorlds Mobile Solutions...
2
by: Bryan Tubbs | last post by:
I'm having trouble connecting to a remote COM object using Reflection. I've got a Web Form using C# that needs to connect to a COM object on a remote server. The snippet of code that follows is...
1
by: samseed | last post by:
Hi, I have a delimited string that I would like to load into a data object. Here is what I have so far: //single string of data; each record is delimited by "%" //and each value within each...
0
by: ramyanet | last post by:
Dear all, Is there any way to directly transfer the data from excel to mysql database without using any tools,but thro coding. pls help me .hope i'll get a soln soon. Thanks Regds,
1
by: chirag thakor | last post by:
how i can import data from Excel to MySql using php.
1
ANTY90
by: ANTY90 | last post by:
Can I use Remote Data control to connect VB to Oracle which is existing on my own system? If yes, how?
7
by: FeelLikeANut | last post by:
I'm using the example on the following page for selecting and fetching a large data object. <http://publib.boulder.ibm.com/infocenter/db2luw/...
0
by: SnehaAgrawal | last post by:
Hi see if u could help me with the following I am accessing a table which is on another DB. But when I write Select LinkNo from ServerName.DBName.dbo.LinkMaster with(XLOck) where Linkid=25 It...
0
by: adititiwari | last post by:
Hi, I issued a command: create server p400 type db2/400 version 5.3.0 wrapper DRDA authorization "qseibm" password "ibm***" options (node 'S657686B', dbname 'S657686B') for an already...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.