Results 1 to 3 of 3

Thread: ADO question

  1. #1
    Join Date
    Apr 2004
    Posts
    110

    Unanswered: ADO question

    Hello everybody

    I`m trying to use ADO to connect to a MySQL database. The frontend is being written in Visual Basic 6. I`m having some trouble with the cursor types, though! Can anyone elaborate on the differences between a server-side cursor and a client-side cursor?
    Currently I`m using a client-side cursor and am getting intermittent cursor type errors when updating my data.

    I quote the connection handling code of my program.

    Set connbio_tech = New ADODB.Connection
    connbio_tech.ConnectionString = "DRIVER={MySQL ODBC 3.51 Driver};" & "SERVER=" & strServerIP & ";" & " DATABASE=bio_tech;" & "UID=" & strOnomaXrhsth & ";PWD=" & strKwdikosXrhsth
    connbio_tech.CursorLocation = adUseClient
    connbio_tech.Open ' Άνοιγμα σύνδεσης

    Set rsTexnikos = New ADODB.Recordset
    strSQL = "Select * From Texnikos"
    rsTexnikos.CursorLocation = adUseClient
    rsTexnikos.Open strSQL, connbio_tech, adOpenDynamic, adLockOptimistic

    Anything that would obstruct updates of the Recordset object in this code?

    thx, in advance

    George Papadopoulos

  2. #2
    Join Date
    Jul 2004
    Posts
    69
    refer to this site: http://delphi.about.com/library/weekly/aa061201b.htm

    this is not a visual basic specific but the concept is the same.

  3. #3
    Join Date
    Apr 2004
    Posts
    110
    thx. Very insightful. I do have a question though! Can I use a dynamic cursor type with a server side cursor location?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •