ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Runtime 440:Automation Error (https://www.excelbanter.com/excel-discussion-misc-queries/244476-runtime-440-automation-error.html)

Amit Patel[_2_]

Runtime 440:Automation Error
 
I create one macro which access oracle database and fill up recordset using
OO4O server request.

when i print recordset into worksheet it gives AUTOMATION error or OVERFLOW
error.if recordset contain 15000 record it print only 14080 record and not
print all record .

Now i get same error when i create Dynaset object.

Set OraDynaSet = objdatabase.DBCreateDynaset(strSQL, 0&)

This statement gives Automation error from last days.

Please help


All times are GMT +1. The time now is 03:03 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com