I converted a VB6 component to VB.NET. I added the component locally on my XP machine to the COM+. I ran a VB6 test program locally and it worked fine. In the test program I called a method in the component which retrieved some data from Oracle. However, after I added the component to the COM+ on a windows 2003 server, and ran the same test program. The object was created without the problem, but when the code tried to call the method, it raised “Automation error”. The error code is “-2146233079”.
So what made the difference? It ran fine locally on my XP with SP2 but not fine on the win 2003 server.