Archive: DAO setup


DAO setup
Hi

Does anyone have a nsi file that installs DAO?

Plese let me know before I start reinventing the wheel ;)

Regards

James


It would help to know what DAO is. Then I would be able to help you. I have a whole bunch of NSI sources that I just keep to see how people do certain things with certain ways. And if it was a program that used NSIS, then I would know how they did it.

-Duane


Hi Duane

DAO stands for "Data Access Object" and is used by the MS Jet Database architecture.

Installing DAO (a couple of DLLs) is not soo simple, cause it requires a lot of checking if there is already a version installed, what version, if you can update it, if DCOM is installed, etc. etc.

Therefore I asked if someone already included this in his own installation procedure...

Regards

James


I'm sure they didn't include it, so you are on your own, but someone could come out later sayin' they did, so keep it open.

-Duane


I need DAO too
Hi,
I need DAO installation too, but I don't have the time to do it so I include the kit in NSIS and install it silently.


Hi Duane.... about installing DAO

Installing DAO (a couple of DLLs) is not soo simple, cause it requires a lot of checking if there is already a version installed, what version, if you can update it, if DCOM is installed, etc. etc.
Yes, I think, as you wrote, installing DAO can be a hard work but not impossible....

so we need to check if there is a pre-installed version, you can use:

ReadRegStr for reading from the registry is there is a version.
IfFileExists $SYSDIR\adaofile.dll , for example, if there are some files in the SYSTEM Directory

Read the Chapter 3 of Nsis Users Manual for more properties of these and more instructions that you might need....
http://nsis.sourceforge.net/Docs/

Hope this help :D

I'm also interested in this. I'm trying to make an install whose only requirements are win95 (or better) or WinNT 4.0 (or better).

Here are the things I've picked up so far:

- 50comupd.exe will update the common controls dll. (A clean Win95 install doesn't have IE at all)

- DCOM95 is needed at least on Win95. Supposedly, you can check which version is previously install by the following registry key:
HKEY_CLASSES_ROOT\CLSID\{bdc67890-4fc0-11d0-a805-00aa006d2ea4}\InstalledVersion
which is in the format of a.b.c.d

- MDAC_TYP can be used to install DAO (or is it ADO, I forget), but requires DCOM95.

Ideally, I'm going to try to make my setup only require one reboot, but I'm not sure thats feasable. Has anyone had any luck with any of these items? I didn't see any other postings.

If I have luck, I'll post my findings.

Adam


At the present I use the following method for installing DAO components. I install IE55 for Win95 or IE60 for other OS. Then I install last version of MDAC, then JET4SP3, then JET4SP5.
After this long (only if they are not already installed) processes we have an updated OS ready to run.

The DAO installation kit provided by Microsoft is obsolete and it doen't work well on any platform. We already tested it and it is a bulls**t.

We've made an smart kit that doen't include these components and it looks for them in the directory where the intaller is located and if it doesn't find them it will try to download them from the net.


I've attached the DAO 3.5 (Access 97 databases) install that I got working. I made it into a .nsh file.

I've included some of the sites I've found with (incomplete) information on them:

http://www.peter3.com/Artiklar/DAO_manualinstall.htm

http://support.microsoft.com/default...NoWebContent=1

http://support.microsoft.com/default...NoWebContent=1

http://support.microsoft.com/default...NoWebContent=1

Its possible I introduced a bug or too when cleaning up the code for this website. Prior to that, I've tested it on a clean Win95 box, as well as a clean Win95OSR2, and a clean Win98 box. Win98SE as well as WinXP and WinNT 4.0 testing should happen within the week. (I don't have a copy of Win2K, sorry folks).

Please post if you have any issues with the install. I found that the easiest way to make an install (since MS docs seem to be lacking), is to:

1) dir c:\ /s > preinstall

2) do an install of the DAO SDK (found on the first MSDEV disk, I think).

3) dir c:\ /s > postinstall

4) do a diff on preinstall and postinstall


Here is the Shared DLL header that will be needed


And an example file. Unfortunately, a zip file with the actual dao files (2MB) exceeds my posting limit of 1MB. Sorry about that.


From my experience with DAO installation (over 5 years) I've come to this conclusion: The BEST way to install DAO is to install LAST version of:
- DCOM (included in IE)
- MDAC 2.7
- JET 4.0 SP3
- JET 4.0 SP5 (requires SP3)

No other way can guarantee to a good working installation, especially if you want Jet 4.0 (Access 2000 and XP support).

I recommend you to check the presense in the main kit and put the installation files outside the kit. You can also add the download options from your web site if they do not have one ore more components.


I used standard MFC classes in MSVC 6.0 (SP5) to do database access in the particular application I'm installing. To the best of my knowledge, I need JET 3.5 for this and jet 4.0+ will not work.

Any ideas why MSVC 6.0 (and its corresponding MFC libs) work this way?

Adam


It's Microsoft way ! But you can make it work with jet 4.0 if you do a trick in VC6 (In VC7 you don't need it).
It's something with Afx... set version of MFC to 0x0601 i thik. You should do this at runtime. You'll find the line on the web or at microsoft's knowledge base.


Does anyone have a nsh file (with related instruction) to installa JET 4.0 and Dao 3.6?

The ategen's sample is very useful, but I need it for DAO 3.6 instead of 3.5

Any help would be appreciated.
Bye all