info
Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
E_FAIL Error
4 views
Skip to first unread message
Bill Kirkman
Jul 2, 2003, 4:47:54 PM7/2/03
to
I decided to create an application that copies data from my Interbase 6.0.1
DB to a MS SQL 2000 Instance with almost - very minor differences - the
exact same schema. I am using IBExpress and ADOExpress in D5 Enterprise with
all SP's to accomplish my goal. Basically, I open the IBTable and then
insert each record into the MS DB using an ADODataset that I set to the
corresponding table.I then set its field values to the field values of the
selected IBTable field which has the data I want to copy.
Everything seems to be working except for one large table. I have about 28k
records in the large table and after a thousand or so records get inserted
the
application fails with a 'Data Provider or other service returned an E_FAIL
status' message. I have no idea what this is telling me and searches in the
newsgroups don't seem to give me any further information.
Can someone help me with this problem?
Thanks,
Bill K
DB to a MS SQL 2000 Instance with almost - very minor differences - the
exact same schema. I am using IBExpress and ADOExpress in D5 Enterprise with
all SP's to accomplish my goal. Basically, I open the IBTable and then
insert each record into the MS DB using an ADODataset that I set to the
corresponding table.I then set its field values to the field values of the
selected IBTable field which has the data I want to copy.
Everything seems to be working except for one large table. I have about 28k
records in the large table and after a thousand or so records get inserted
the
application fails with a 'Data Provider or other service returned an E_FAIL
status' message. I have no idea what this is telling me and searches in the
newsgroups don't seem to give me any further information.
Can someone help me with this problem?
Thanks,
Bill K
0 new messages