 |
|
Web Wiz Web Hosting 30 Day Free TrialWindows Hosting 30 Day Free Trial, with no obligation, on all our Windows Web and Reseller Hosting Packages.For more information see our Windows Hosting 30 Day Free Trial page. |
Multiple-step OLE DB operation generated |
Post Reply 
|
| Author | |
Charlie Goodwin 
Newbie 
Joined: 06 June 2006 Status: Offline Points: 10 |
 Post Options
 Thanks(0)
 Quote Reply
 Topic: Multiple-step OLE DB operation generatedPosted: 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'?
Edited by Charlie Goodwin - 25 July 2006 at 7:59am |
|
 |
|
|
ctscott
Senior Member 
Joined: 27 May 2003 Location: United States Status: Offline Points: 246 |
Post Options
Thanks(0)
Quote Reply
Posted: 25 July 2006 at 1:59pm |
|
see if this link helps |
|
|
______________________
College Football Trivia |
|
|
|
Topic Options|
Post Reply
|
|
Tweet
|
| Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |
