L
LeAnn
Hi,
I posted a question that noone responded to and I received the error again
so I will post my question again - hopefully with more clarity (if that was
the issue). Sorry it is so long but I would like to figure out how to avoid
this error. The original message is below but here is today's error:
Run-time error '-2147217887 (80040e21):'
Multiple-step OLE DB operation generated errors. Check each OLE DB status
value, if available. No work was done.
A secondary error displays after the one above the specifies a particular
line in the VB Script (described below):
Error: Multiple-step OLE DB operation genereated errors. (same as above)
Code: 80020009
Source: Microsoft OLE DB Provider for ODBC Drivers.
It seems to create part of the text file (106 out of 139) as it did last
time. It seems that a specific record in the data set is causing the error.
There doesn't seem to be anything unusual about either record on either day.
The 80020009 code above seems to be related more to ASP or web related
situations (mine is not). I am using SQL 2000, Access 97 and connecting to a
Fox Pro database for the source data.
Any ideas about why this is happening? The line of code in the VB Script
which creates the text file and that is getting the error is as follows
(normally this runs fine):
app1.Run "ImportDB", "SD_Prog", odbc, "sp_sd_net_log", "SELECT access_no,
source_id, client_no, supply_no, accessdate, " _
& " accesstime, coll_date, coll_time, prod_loc, prod_type, lis FROM SPU
WHERE MONTH(accessdate) = " & mon & " AND " _
& "DAY(accessdate) = " & dy & " AND YEAR(accessdate) = " & yr", tdir, tdir &
"ARCHIVE\", "SPU.txt", "SPU", "SPU"
I posted a question that noone responded to and I received the error again
so I will post my question again - hopefully with more clarity (if that was
the issue). Sorry it is so long but I would like to figure out how to avoid
this error. The original message is below but here is today's error:
Run-time error '-2147217887 (80040e21):'
Multiple-step OLE DB operation generated errors. Check each OLE DB status
value, if available. No work was done.
A secondary error displays after the one above the specifies a particular
line in the VB Script (described below):
Error: Multiple-step OLE DB operation genereated errors. (same as above)
Code: 80020009
Source: Microsoft OLE DB Provider for ODBC Drivers.
It seems to create part of the text file (106 out of 139) as it did last
time. It seems that a specific record in the data set is causing the error.
There doesn't seem to be anything unusual about either record on either day.
The 80020009 code above seems to be related more to ASP or web related
situations (mine is not). I am using SQL 2000, Access 97 and connecting to a
Fox Pro database for the source data.
Any ideas about why this is happening? The line of code in the VB Script
which creates the text file and that is getting the error is as follows
(normally this runs fine):
app1.Run "ImportDB", "SD_Prog", odbc, "sp_sd_net_log", "SELECT access_no,
source_id, client_no, supply_no, accessdate, " _
& " accesstime, coll_date, coll_time, prod_loc, prod_type, lis FROM SPU
WHERE MONTH(accessdate) = " & mon & " AND " _
& "DAY(accessdate) = " & dy & " AND YEAR(accessdate) = " & yr", tdir, tdir &
"ARCHIVE\", "SPU.txt", "SPU", "SPU"