Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ADO SQLOLEDB

Status
Not open for further replies.
cfriedberg

cfriedberg

MIS
Jan 3, 2001
66
0
0
US
I am accessing data from SQL server using VB 6.0. I have reconciled myself to the fact that I will not be able to use the recordsets to update data to the server. However, I would like to be able to update the recordset that was returned because I use it to populate a grid.

The recordsets all have
CursorLocation = adUseClientBatch
CursorType = adOpenStatic
EditMode = adEditNone
LockType = adLockReadOnly.

Trying to change any of these properties is futile. Am I to assume that the SQLOLEDB provider will not let me? If that is the case, then is there another provider or another method that will work with SQL 2000?

Carolyn
 
Sort by date Sort by votes
suggest you try the "Visual Basic(Microsoft) -Version 5 & 6" forum...
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

chkote
  • Locked
  • Question
ADO - Records v. Fields
Replies
3
Views
17
chkote
chkote
mikemcginty
  • Locked
  • Question
Run an Access Stored Procedure using ADO 1
Replies
2
Views
22
Chiaua
Chiaua
Guest_imported
  • Locked
  • Question
ADO recordset
Replies
1
Views
17
varnit
varnit

Part and Inventory Search

Sponsor

Back
Top