Application Deployment 1

[willrae]

Hello

My program uses an Access 2000 database, and my program references the DAO 3.6 Object Library. It works. When I install onto my test machine, with neither VB or access, I get a runtime error (3633). It works fine on this machine.

I'm sure this has something to do with the database, from where it stops.

Regards

William Rae

 

[CCLINT]

Jet is likely not be present (or defect, or not registered) on the client machine.
Did you package the Exe with the P&D wizard? If not, then you will probably need to do this so that all the run time components that the program uses get installed onto the client PC.
If you already have done this, then something got missed or got out of wack. You may need to reinstall the setup for your Exe (first uninstall it), or it may be only needed to install Jet 4 sp3 (

http://www.microsoft/data/).

[/b][/i][/u]*******************************************************
_{General remarks:
If this post contains any suggestions for the use or distribution of code, components or files of any sort, it is still your responsibility to assure that you have the proper license and distribution rights to do so!}

 

[willrae]

The problem was the P&D program not detecting all dependancies. I did indeed need Jet 4 sp3, and it's dependancy, MDAC, and in turn, it's dependancy IE 5.5 which is bizare, as effictively it turned my desktop app into one requiring internet access.

 

[CCLINT]

>MDAC
You shouldn't need MDAC...just Jet4 Sp3
Do you have a reference to ADODB?
(Microsoft ActiveX Data Objects 2.x Library)


>"... dependancy IE 5.5..."
Do you have a reference to the ADOR library?
(Microsoft ActiveX Data Objects Recordset 2.5 Library)

ADOR is basically installed with IE, but also with MDAC;
ADODB is installed with ADO (in MDAC)
[/b][/i][/u]*******************************************************
_{General remarks:
If this post contains any suggestions for the use or distribution of code, components or files of any sort, it is still your responsibility to assure that you have the proper license and distribution rights to do so!}

 

[willrae]

Jetsp3, needs mdac,

http://www.microsoft/data

says so. And I got an error when installing Jetsp3 that disappeared when I installed mdac, which proves it.

In turn when installing mdac, it says IE 4.something+ must be installed. Now unless you have the full version lying round on a magazine dik, this requires 5.5 (as 4.0 is out of stock) to be downloaded. You can't download 5.5 full from MS, only 5.5 small setup which insists you have an internet connection so it can get the rest of it.

It turns out then, to implement dao 3.6, you need an internet conection. Crazy really, they should break down these huge packages, so individual files can be installed from them. I'm sure ALL of MDAC isn't needed, likewise, I'm sure ALL of IE 4.0 isn't needed.


You can work around this by downloading the full version of 5.5 from a source other than microsoft. Search Google for "full IE download".

Do you have a reference to ADODB? Nope

Do you have a reference to the ADOR library? Ditto

 

[CCLINT]

>>"Jetsp3, needs mdac,

http://www.microsoft/data

says so"

This is if you are using ADO instead of DAO, or Jet ODBC. In order for this version of the Jet provider (Sp3) to work with ADO, you need the newer ADO dlls.

You will get an error when installing Jet 4.0 SP3, but it has to do with 2 Dlls that you probably do not use: odbcconf.exe and jetodbc.rsp

I just created an small EXE using DAO 3.6 and Jet 4.0 SP3 that will access and return the record count of about 10,000 records in an JET MDB (all local).

I installed this (P&D) on an newly installed Win98 (first ed.) machine with nothing else on it. The only files that got installed were the ones from Jet 4.0 (no MDAC, no DCOM98, only IE 4.0, etc.).

Then I installed Jet 4.0 SP3. The two errors came up, but that as mentioned was no problem.

The program runs correctly. The only jet dlls found on the maschine for DAO are from Jet 4.0 Sp3.......

Anyways, it can only do good to install MDAC.

I believe the reason that MDAC wants IE is because of the ADOR that it installs. DAO Jet 4.0 surely doesn't need it.

Probably I gave the wrong answer anyways....You probably only needed to install MDAC 2.5.

Just add the to the list of additional files in P&D Wizard, so P&D runs it automatically at setup, and you should be good to go... [/b][/i][/u]*******************************************************
_{General remarks:
If this post contains any suggestions for the use or distribution of code, components or files of any sort, it is still your responsibility to assure that you have the proper license and distribution rights to do so!}

 

[willrae]

Thanks for the experiment.

"You will get an error when installing Jet 4.0 SP3, but it has to do with 2 Dlls that you probably do not use: odbcconf.exe and jetodbc.rsp"

I find this disconcerting, amd is sure to raise concerns in users. Can I avoid this message being displayed by running in quiet mode?

"Just add the to the list of additional files in P&D Wizard, so P&D runs it automatically at setup, and you should be good to go..."

Add what? Do you mean Jetsp3? Do I just add Jetsp3.exe?

 

[CCLINT]

If you are using DAO 3.6 Jet 4, and on the developing PC (where the package is made) are all the needed Dll's, then the P&D should automatically pick those up.

Shipping the Jet 4 Sp3 Exe is not needed, if the packaging PC has Jet 4 SP3 already on it.

Then you can just include the MDAC 2.6 in the package. MDAC will be automatically installed at the begining, and then the Jet DLLs and DAO.
************************************************************

Better would be, when using DAO 3.6 and Jet 4, to just stick with installing MDAC 2.5, which installs the Jet 4 dlls (not Sp3). Your program should work then.



[/b][/i][/u]*******************************************************
_{General remarks:
If this post contains any suggestions for the use or distribution of code, components or files of any sort, it is still your responsibility to assure that you have the proper license and distribution rights to do so!}