Database Discussion - Multiple-step OLE DB operation generated

Print Page | Close Window

Multiple-step OLE DB operation generated

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=20805
Printed Date: 28 March 2026 at 2:20pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Multiple-step OLE DB operation generated

Posted By: Charlie Goodwin
Subject: Multiple-step OLE DB operation generated
Date Posted: 25 July 2006 at 7:54am

I'm moving my Forum from Access to SQL Server

I have a page with the following code:

strSql = "SELECT * FROM tblVacancy"

'Set up database call to add new Vacancy
with rscommon

'Set lock type to only lock table on update
.LockType = 3

'Make dummy querry to get table mappings
.open strSQL, adoCon

.addnew

   .fields("AuthorID") = lngAuthorId
   .fields("TermType") = intVacancyTerm
   .fields("ExpiryDate") = datExpiryDate
   .fields("Description") = strVacancyDescription
   .fields("CreationDate") = datCreationDate

. . . . . .

The trouble is I get the following error when it tries to execute the line:

.fields("AuthorID") = lngAuthorId

Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.

It works fine using my access database.

Is there an easy way to 'Check each OLE DB status'?

Replies:

Posted By: ctscott
Date Posted: 25 July 2006 at 1:59pm

see if this link helps

http://www.aspfaq.com/show.asp?id=2288 - http://www.aspfaq.com/show.asp?id=2288

-------------
______________________
http://www.cfbtrivia.com" rel="nofollow - College Football Trivia