DisconnectedContext was Detected in Converted VB Code Failing Sporatically in VB Studio 2005

I have a project that was imported from VB 6.0 Pro.  I am still using ADO.  The code is designed to report data from Oracle.  If the code is supposed to bring back a small amount of data it runs flawlessly.  If it is to bring back a large amount of data it fails with the following error:

DisconnectedContext was detected
Message: Context 0x4140c0' is disconnected.  Releasing the interfaces from the current context (context 0x413f50).This may cause corruption or data loss. To avoid this problem, please ensure that all contexts/apartments stay alive until the applicationis completely done with the RuntimeCallableWrappers that represent COM components that liveinside them.

This comes up in a small dialog rather than tripping into my error handler or simply stopping on a particular line.  I don't know how to find exactly which line is failing other than examining which data it stops on in the output.  This project is extremely important and I am stuck.  Any help would be greatly appreciated.
LVL 1
tlchavetAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

ericwong27Commented:
You can use the native .NET Oracle class libraries instead of COM Component. The problem solved be able to resolve.

Reference
http://www.oracle.com/technology/pub/articles/cook_dotnet.html
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
tlchavetAuthor Commented:
Sorry for the delay in responding.  The first step of that article indicates to download a utility and it is taking some time.  I will respond back later tonight as soon as I can test the solution.  Thanks for the direction.
0
tlchavetAuthor Commented:
The article says to declare the connection as follows:
Dim conn As New OracleConnection() ' VB.NET
However, I get an error on the OracleConnection that it is not defined.  Oracle.DataAccess.dll is added as a reference to my project.
0
tlchavetAuthor Commented:
Thanks for pointing me in the right direction.  After some more research I found I was missing a step (Imports . . .).  
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic Classic

From novice to tech pro — start learning today.