Jet 4.0 Connection

[figler]

I am trying to connect to a DB that I made in Access 2000. My connection string is:

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\MYDBFile.mdb;Persist Security Info=False

It works fine on my development machine (W2k/Office Pro 2k) but I can't make a connection to the DB on a Win95 machine that doesn't have Office installed. My guess is that there is no driver for Jet 4.0 on that machine and that I could include that driver (if I knew what it was) with my installation.

Any ideas? Thanks. -Brad

ps There error I get is #429: ActiveX component can't create object.

Thanks for your help!

 

[calidrake]

If you include the installation of Microsoft Data Access Components (MDAC) in your install program, it should take care of the problem. I believe they are up to 2.7 now but I am not sure.

 

[figler]

Thanks, calidrake.

obdcconf.dll [Microsoft Data Access Components] didn't do the trick. Any other ideas???

 

[calidrake]

No, you have to run the executable to install MDAC.

http://www.microsoft.com/data/download.htm

The install has to be run, just moving a DLL will not do it.

 

[calidrake]

It looks like you need MDAC 2.5 to get the Jet drivers

 

[figler]

The file (MDAC_TYP.exe) was included in my install, but I can't find it on the client (Win95) machine to run it. Couple questions:

1. Why isn't the file there? According to setup.lst, it should be in AppPath.
2. What is the best way to run this automatically from the setup program?

Thanks for your help, calidrake. -b

 

[calidrake]

I do not know why it wouldn't be there if it is in your install. Who made the install file, and is there any way you can get into the source for the install to double check that it is there?
I didn't write our install file, but I know that it called the MDAC install in the middle of it. Plus I don't think it would have to save the MDAC_TYP.exe to the client, it would just have to execute it. Have you tried uninstalling and reinstalling on the client?
One last thing...when I was looking at the download page, I noticed that 2.6 and 2.7 do not include the Microsoft Jet drivers. What version of MDAC are you installing??