Problems with Remote Data Object (RDO) & MySQL

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • shuvo2k6
    New Member
    • Jan 2008
    • 68
    #1

    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
    Tags: None
    • lotus18
      Contributor
      • Nov 2007
      • 865
      #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

        Comment

        • shuvo2k6
          New Member
          • Jan 2008
          • 68
          #3
          Originally posted by lotus18
          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.Resultse t.AddNew
          MSRDC1.Resultse t.rdoColumns("I D") = Text1.Text
          MSRDC1.Resultse t.rdoColumns("N ame") = Text2.Text
          MSRDC1.Resultse t.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

            Comment

            • lotus18
              Contributor
              • Nov 2007
              • 865
              #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

                Comment

                • shuvo2k6
                  New Member
                  • Jan 2008
                  • 68
                  #5
                  Originally posted by lotus18
                  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

                    Comment

                    • lotus18
                      Contributor
                      • Nov 2007
                      • 865
                      #6
                      Originally posted by shuvo2k6
                      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

                        Comment

                        Previous template Next
                        Working...