I have a stored procedure which locks user recrods to see who is logged onto the system. It then unlcoks them again.. I can run this procedutre once OK. If I run it a second time without exiting OInsight it causes an Oengine failure. Running it in debug the failure occurrs when actually executing a lock statement. (The particular record being locked does not seem to make any difference.)

The resulting error details are -

1. White windows Message "OENGINE an error has occrred in your program……"

Choose Close or ignore.

2. On closing this message I get a standard illegal op message for Oengine.The details given are for a GPF in APILH2 at offset 0001:0000246A

Any ideas???

Correction to my initial msg - The problem code is event code not a stored proc

Geoff,

I have a stored procedure which locks user recrods to see who is logged onto the system. It then unlcoks them again.. I can run this procedutre once OK. If I run it a second time without exiting OInsight it causes an Oengine failure. Running it in debug the failure occurrs when actually executing a lock statement. (The particular record being locked does not seem to make any difference.) The resulting error details are - 1. White windows Message "OENGINE an error has occrred in your program……" Choose Close or ignore. On closing this message I get a standard illegal op message for Oengine.The details given are for a GPF in APILH2 at offset 0001:0000246A

So you are running Win 95 (?) with the NPP. Do you have an NT Service that you are using? What version of OpenInsight? If you look at the version tab of the file properties of APILH2.DLL (from Win95 explorer) what does it say the file version is? (Example: 1.1.1.0) What is the file date and size?

Thanks,

Cameron Purdy

info@revelation.com

Hi Cameron

Yes ,I am running win95 with the NPP, No NT service

OI version is 3.2

The APILH2.DLL details are as follows

Size 139,904 bytes

Date Tue December 10 1996

Version 1.1.0.1

Hope this helps

Geoff

View this thread on the forum...