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
Topic Options
Post Options
Thanks(0)
