Error registering dlls during installation

[shippyatdrexel]

I wrote a program that uses an Access database and a Word document. I created an installation package using Inno Setup and installed it on a machine that has Windows 98, Access 2000, and Word 2000. It worked fine. But when I installed it on a system with Windows 95, Access 97, and Word 97, I get an "Error registering dll" error during the installation when it tried to register "msado15.dll". Here are the files included in the installation package:

'Vb system files
StdOle2.tlb"
MSVBVM60.dll" OleAut32.dll"
OlePro32.dll"
AsycFilt.dll";
Ctl3d32.dll"
ComCat.dll"

'Other files
msado15.dll"
Msword9.olb"
comdlg32.ocx"
msador15.dll"
Msado20.tlb"

And here is a section of code that uses the database:

    Dim rs As ADODB.Recordset
    Set rs = New ADODB.Recordset
    rs.CursorType = adOpenKeyset
    rs.LockType = adLockOptimistic
    
    Dim strExtract As String
    strExtract = App.Path & "\Extract.mdb"
    
    Dim cn As ADODB.Connection
    Set cn = New ADODB.Connection
    cn.Open ("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & strExtract & ";Persist Security Info=False")

    Dim cmd As ADODB.Command
    Set cmd = New ADODB.Command
    cmd.ActiveConnection = cn
    cmd.CommandType = adCmdText
    cmd.CommandText = "DELETE * FROM ExtractTable;"
    
    Set rs = cmd.Execute

Why can't it register the dll? Does it not work with Windows 95? What do I have to do to get it to work?

Please help!

[bondhedger]

similar problems here too. have had some success with upgrading Internet Explorer on win95 systems (many have not been updated since OS installation). second leg, if you are not already doing so, is to use the "Package & Deployment" wizard and "ram home" your dlls through the setup process. I have not succeeded in all cases using these 2 assists but most will work. I will say this, the recurrence of dll problems has never been higher since I installed Office2000. something's not right.

[shippyatdrexel]

Thanks. I'll switch over to the Package and Deployment Wizard and see if it helps.

[Chris]

If you install your application in Window95 platform, be sure that you've install the MDAC2.5SP1 in your development PC or the target PC.

Because I did face the problem of "ActiveX can not create Object" when I run my application in Window95 platform. And it was resolved after I installed the MDAC2.5 SP1 and recreate the setup cabinet file.

If you're use the MDAC 2.6 then juz ingore my post.

[shippyatdrexel]

I'm using SP4 with MDAC 2.5 (I think). The control is Microsoft ActiveX Data Object Library 2.5 (msado15.dll). But the program will only be distributed on Win98 and NT systems. None of the pcs that this will be installed on have Access or VB. Is it possible that I have to run MDAC_typ.exe that comes packaged with the .cab files in the Package and Deployment Wizard? I'm using Inno Setup so that file is not included.

[Chris]

shippyatdrexel, you need to included the mdac_typ.exe in your setup program. This fiile is abt 7++MB and normally is found in your PC at the following path C:\Program Files\Microsoft Visual Studio\Common\IDE\IDE98\Redist after you install the Visula Studio Service pack 3 or 4.

Cheers

[shippyatdrexel]

Do I run this before installing my program?

[Chris]

Noop, all you need to do is juz included it into your setup program. Normally, the Package & Deployment wizards will automativcally included it for you. (Provided your project workspace file have set the references to Microsoft ActiveX Data Object 2.6 or 2.5 Library).

If it is not included then you may need to run the MDAC setup program yourself.

cheers

[Edited by Chris on 12-18-2000 at 12:45 AM]

[shippyatdrexel]

Great! I'll try it. Thanks a lot for your help.