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

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.

thx. Very insightful. I do have a question though! Can I use a dynamic cursor type with a server side cursor location?