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 Chriss Miller 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
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
Status
Not open for further replies.

Similar threads

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

Part and Inventory Search

Sponsor

Back
Top