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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ADO, SQL SVR, windows 2003 R1 and R2

Status
Not open for further replies.
wadey

wadey

Programmer
Jun 6, 2006
54
GB
Has anyone come across the following bug before:-

we have 2 servers, one running Windows 2003 release 1, and the other running Windows 2003 release 2. Using VB6 and ADO to connect to SQL Server 2000.

This VB code only works on Release 1:-

frm.AdodcTemp.Refresh
frm.AdodcTemp.RecordSet.Update

Where as the above code only works on Release 2 when put like this:-

frm.AdodcTemp.RecordSet.Update
frm.AdodcTemp.Refresh

Just doesnt make sense. Anyone come across ADO errors (Probably more like lower level problems) of this type before ? We're using MDAC 2.8 on all.
 
Sort by date Sort by votes

When it does not work, what does it do?
Any errors? If so, which line does it error on?


Have fun.

---- Andy
 
Upvote 0 Downvote
running this code against release 1 produces the following error:-

frm.AdodcTemp.RecordSet.Update
frm.AdodcTemp.Refresh


error:-

Row cannot be located for updating. Some values may have been changed since it was last read.

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

2009luca
  • Locked
  • Question
GET splitted value from node and sub node in treeview
Replies
1
Views
184
Andrzejek
Andrzejek
sal21
  • Locked
  • Question
delete first line in txt and rewrite
Replies
2
Views
120
sal21
sal21
sal21
  • Locked
  • Question
still on api rest and get 1
Replies
2
Views
159
sal21
sal21
Trob70
  • Locked
  • Question
Create a Form Via Code and Save
Replies
4
Views
393
Andrzejek
Andrzejek
sal21
  • Locked
  • Question
send txt message and attachment with whatsapp Web
Replies
2
Views
376
sal21
sal21

Part and Inventory Search

Sponsor

Back
Top