Using Microsoft Jet OLE DB 4.0 Provider

[Custom24]

Hello

I am developing a simple data interface program and I made the mistake of choosing the ADODC data control. But the question does not really relate to this.

When I run the .exe file on the development machine, everything is fine, but when I manually install on the users computer, the error "Provider cannot be found - it may not be installed properly" or "ADO could not find the specified provider" comes up. I think this is because my app uses OLE DB 4.0, and the user has 3.51?

I am reluctant just to use package & deploy is because the software is being used in a controlled environemnt, where every change has to be accounted for. But I think their version of MDAC is the same.

Is it possible just to install the provider I need on the user machine? How do I go about doing this?

Thanks for help in advance
Mark

 

[jasek78]

MS has a jet 4.0 engine available for download on its download website. Just go to

http://www.microsoft.com/downloads/searchdl.asp?LangIDCODE=20;en-us

and search for Jet 4.0 and the appropriate OS.

jason

 

[Custom24]

Thanks very much for this - it was just the ticket.

I'm just getting a bit frustrated by all the add-ins and components necessary to make a simple little app like mine work!!

But it's forums like this that stop me going completely mad

Mark