How to resolve run-time error caused by CreateObject OLE?

HCL Domino Domino Forum
1

Hi, I am using CreateObject in my LotusScript scheduled agent something like below.Dim objUDB As Variant

Set objUDB = CreateObject(“A-VB-Object”)

…

Basically, my LotusScript agent called a VB object which returns a dataset from DB2 database tables. It runs fine, but if the DB2 database is down, then this scheduled agent crushes the Domino server.

How can I add code after CreateObject to detect the run-time error? Thanks

2

Subject: Suggestions

If nobody has a direct answer for your question, you may want to find a DB2 forum and see if they have error trapping code that might be useful.

3

Subject: RE: Suggestions

Thanks, and good point.if there is no easy way to resolve it in Lotus Notes side, then I have to persuit it in VB.net side, basically, the VB object my LotusScript agent called can do something when the DB2 database (tables) is crushed, I can ask my colleage Visual Basic .net developer to add some codes to return when the DB2 table is crushed.

But before I try that approach, I just want to know if this is a correct approach. Any idea? We really do not have any solution in our Lotus Notes script side?