Database Support for Win85/98/2000/Xp

I have some problems making a install-package for my application. I use the following references;

Visual Basic For Applications
Visual Basic runtime objects and procedures
OLE Automation
Microsoft Data Environment Instance 1.0 (SP4)
Microsoft ActiveX Data Object 2.7 Library
Microsoft SQLDMO Object Library

The database connections i use is MS SQL-Server (online data) and MS-Access (for offline data).

The packagers i used is Wise InstallMaster 8.1 and the included PDW from Visual Studio.

The problem i am having is that i want the application to run on several OS (Windows 95/98/NT4/2000/Xp).
How shall i package this so that it detects what OS its on and include all the database-drivers for each OS?

Any suggestions?

Best regards

Peter Carlsson

When using the P&DW you should have no problem.
All the right controls will be added and MDAC_TYP.EXE 2.7 will be added to your project.
MDAC_TYP itself will install the correct files on the all different Windows versions.

Well the problem is.. i got a user to install the application yesterday and it.. euhm.. made his Win98 . :D

I was afraid that Win98 had some problem with MDAC.
Does the PDW detect if DCOM98 is install? I belive that MDAC needs DCOM98 to run correctly.

// Peter

Originally posted by ArnoutV
When using the P&DW you should have no problem.
All the right controls will be added and MDAC_TYP.EXE 2.7 will be added to your project.
MDAC_TYP itself will install the correct files on the all different Windows versions.

It could be DCOM98 but something to try first would be the jet re-distribution pack. As of MDAC 2.6, the Jet (Access DB) drivers were not included. You need to get them separately.

You only have to install DCOM95/DCOM98 when MDAC says there is something missing.
It will not launch DCOMx automatically.
DCOM98 should already be installed on Win98 machines by default.

OK. Thanks for your help guys!
By the way.. what tool except PDW do you use to make installers? I tried Wise Install Master 8.1 and it works pretty good, but i dunno if it includes stuff like MDAC etc. into installers.

// Peter

I use INNO (http://www.jrsoftware.org/isinfo.php), it's a free installer, but you have to include all needed files by hand.
You can find some threads about INNO on this forum and also a small tutorial in the tutorial section.