MDAC_TYP.exe , ADO, and two files that are evil!

[snhuskey]

Hello. I am having problems installing a program that uses ADO.

I Get an error that says "Provider Not found. It may not be installed correctly"

MDAC_TYP.exe is being bundled into my cab file becuase it always is when you are using and ADO control. Now.... I went to Tech Net and searched for a resolution to my problem, and the problem is this:

The OLEDB provider for Microsoft jet 3.5 consists of the following two files:

C:\windows\system\Msjt4jlt.dll
C:\program files\common files\system\ole db\Msjtor35.dll

Now... When I run the packaged install, the above data access files do not get extracted. ALSO, when i run the MDAC_TYP.exe file seperatly the files still do not get extracted! Also, I downloaded the latest service pack for MDAC and STILL the files do not get extracted.

Now... I am able to do a manual extraction of all the files contained in MDAC_TYP.exe as microsoft explains. When I do this, The files are clearly there!

Noww... If I take those two files, put them in the appropriate directory and then register them using regsvr32.exe my program works fine!

But... I do not want to do that! This can't be they way the setup with MDAC_TYPE.exe was intended. I've BUILT test programs using different machines running VB6 proffesional edition sp4 AND installed the machine on several test clients. and I get the same error unless I do what I eplained above.


FOR THE LOVE OF GOD! SOMEONE HEEEEELP!!!!

[Lafor]

Isn't there a way in the package to add additional files that u wish to be part of the application

if so, while building the package... add these 2 files separately in addition to the MDACTYPe stuff...

Does that make any sense?

[snhuskey]

the MDAC_TYPE.exe file is already bundled with the package. it is 6 megs and it already contains the two files. Also, adding the two files seperately will add an additional 2 megs to the setup file size.

This cant be right.


I could add the two files and then have them self register by editing the bootstrap but I don't know how I can place those two files in the appropriate directories.

[Lafor]

I think the default directory is windows\sys...
Is that the directory wou were thinking about?

PS.. I am not sure how urgentthis is for u but..
sometimes (like u say) it can't be right.. but
with microsoft one has to fin work arounds and sometimes fast and later on ponder... that's the mode I have operated in for a while now

Is the addition of the 2 megs a big deal for now?
If not, just do it for now.. until u find the good solution

take care..

snhuskey,

I'm having the exact same problems, except that after installing the two "evil" file,s the damn thing still doesn't work.

Could you possibly email me the setup.lst file so I can see if I'm missing anything in particular. Emal to" gaffa@redgumtech.com.au

cheers

- gaffa

Found the problem.

mdac_typ versions 2.1 and 2.5 do NOT include the Jet 3.51 drivers. The only way to get those is to install mdac verions 2.0.

The other verions install Jet 4.0.

Bummer. Means you need to distribute the earlier mdac, or distribute both.

Se kb article http://support.microsoft.com/support/kb/articles/Q197/9/02.ASP

- gaffa

[monte96]

Why not just use 4.0???

a quick search and replace of the provider is about all you should need to do to change it out.