
Run time error '429': ActiveX component can't create object
I have a VB6 project that uses RDO to connect to an SQL Server Datasource
and a CODA-RMS Datasource. On my development machine (and all the machines
bar one I can test on here at work), the application works fine. Out at the
customer site I'm getting a:
Run time error '429': ActiveX component can't create object
when we run the app.
We have had the error using Access and fixed the problem by installing the
Office service packs (1 & 2). But in this case it has not solved the
problem. I sent the customer an access MDB with the following code to test:
--Begin Code--
Dim env as rdoEnvironment
Set env = rdoEngine.Crea{*filter*}vironment("Test","","")
--End Code--
and it fails with the error on the Set... Line.
We have even re-installed the MDAC type libraries again with no luck.
Anyone else experienced this problem, and better yet, offer a solution?