Deployment Problem

I have created a program that reads information from existing Excel Spreadsheets and stores it into a Jet Database. My problem is that when I have tried to install and run it on a different computer (the one that by necessity must host this functionality) I receive Run time error 429, "ActiveX component cannot create object." This error is occurring the first time that the code tries to open the 'Connection' object. I have looked at the MS Knowledge base and the only closely related topic is for RDO. I am using ADO and was wondering if anyone else had seen this problem and had a solution. Thanks

[Rippin]

I had the same problem awhile back. Unfortunately, since I barely remember my own name from day to day, I don't remember exactly how I solved the problem. But I believe that it was that the Microsoft Data Access Components (MDAC) that I was using was version 2.0 and I had to update it to version 2.1. Check which version of MDAC you have (on my machine it's C:\Program Files\Microsoft Visual Studio\Vb98\Wizards\PDWizard\Redist\Mdac_typ.exe, but it may be in a different location on your machine). If it is 2.0 then you need to replace that file with version 2.1 which is included with Service Pack 3. This file gets distributed with your setup program and gets run during the installation. If you don't have 2.1, I think it won't work.

Hope this helps,
Rippin

[JimmyT]

Thanks for the response...

I have verified that my system has the correct (2.1) version of MDAC. I have installed DCOM 95 (the target operating system is Windows 95) and reran the Setup.exe from my installation. I still haven't gotten past this error but your tip is helpful. If you, or anyone else, has any additional advice, I'd appreciate it...

[JimmyT]

The root cause of this particular error is that you must install and run DCOM95.exe (for Windows 95 Machines) or DCOM98.exe (for Windows 98) then re-run the installation program for your distributed software.

Another issue came up after this was successfully completed. I received Error 3706: ADO could not find the specified provider.

I was using Jet 3.51 as my provider and my installation distributed MDAC.exe (Version 2.1). After researching the Microsoft Knowledge Base, I found an article that informs you that Jet 3.51 OLE DB Provider is not installed with MDAC 2.1.

The resolution is either to redistribute MDAC 2.0 prior to or instead of MDAC 2.1 (2.0 installs Jet 3.51 OLE DB Provider and is not overwritten by 2.1)

or

Change references in the connection strings for the provider to be Jet OLEDB 4.0.