Click here to Skip to main content
16,016,022 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Mike Hillyer mentions that "The fourth cursor type, adOpenKeySet, is not currently supported by MySQL / MyODBC."

I have a VB application that is specifying the adOpenKeySet cursor property, and it still returns a recordset. As no error is being returned, I guess that the ODBC connector is setting the cursor type to something else.

Anyone know what it would be changing it to behind the scenes?

What I have tried:

Used adOpenKeySet cursor property, and it still returns a recordset. As no error is being returned
Posted
Updated 3-May-16 19:08pm
v2
Comments
Richard Deeming 4-May-16 15:19pm    
Your question is tagged "VB.NET".

If you're using .NET, why are you using ADO, which hasn't been supported for 15 years? You'd have better luck using ADO.NET instead.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900