December 21, 2004 at 2:03 pm
I've written a script to extract the content of a database and convert it to flat text files as part of a migration.
Out of the blue, I get a
"0x80042730
The passed object is invalid."
error as the first line of text is written to the 254th file via sp_oamethod.
I'm using a scroll cursor (say what I will, but this was working just fine) and there are around 4500 records being parsed and converted.
The script was written on sql7 and has just been ported to sql2000 - whereupon the error.
As the only reference to this error via Google talks about Linux (!), it has to be some sql2k issue. But what?
I'd first assumed it was some bad data, but filtering out the record being affected comes back the same, just appearing on the next one instead.
I'll happily post the script - its not that complex - and I figure the answer has to be something obvious?
December 24, 2004 at 8:00 am
This was removed by the editor as SPAM
November 1, 2005 at 12:00 pm
I've just found this error as well, but in my case it was expected. I have some code which can theoretically execute the equivalent of;
exec @oa_return_code = sp_OADestroy 0
This produces the error in question. Given the lack of references to this error code I can only assume that it means invalid object token. The object token is what is returned as the output parameter by sp_OACreate.
Hope this helps someone.
Rhys
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply