[RESOLVED] Visual FoxPro ODBC Driver

[jcis]

I'm deploying with Inno Setup.

My app has a reference to Microsoft Remote Data Objects 2.0 (msrdo20.dll).

Im deploying this Dll, but its not enough, this Odbc Foxpro driver needs vfpodbc.dll.

About this vfpodbc.dll, Microsoft offers this installer..
Visual FoxPro ODBC Driver

I can manage to add that installer to my Inno setup package, but sometimes it is the spanish version that needs to be installed, and sometimes the english version, it's weird and im not sure why but some computers want the english version and some others the spanish version, and it doesn't seem to be related to the Operating System language.

So, can i avoid all this mess and just deploy vfpodbc.dll myself? or i must use this external installer and make my Inno pachage smartly decide which version to install? If so, any sample code to do that?

[RhinoBull]

I might be wrong but I think if you include MDAC in your project FoxPro driver will installed as well.

[jcis]

Yes i heard that, but which version? According to this, 2.8 does not include FoxPro ODBC Driver..
http://msdn.microsoft.com/data/ref/mdac/
It says:
"This release does not include Microsoft Jet, the Microsoft Jet OLE DB Provider or ODBC driver, the Desktop Database ODBC Drivers, or the Visual FoxPro ODBC Driver."

[RhinoBull]

Include the one that has - I think 2.5(6,7) has it included.

[randem]

MDAC 2.5 was the last one that had JET engines deployed. If you are installing something that needs ODBC you will have to install the whole client if it is not included in the MDAC you are deploying.

You need to do research to find out why the Spanish version wans to be deployed. It definitly has something to do with a setting on their PC in reference to the geograpy of where it thinks it is or something of the sort.

You could also deploy the JET engines seperately (if they have the FoxPro installation included).

[jcis]

I found a solution:
I'm deploying both, English and Spanish versions of the Foxpro driver. Then from my installer i execute the english version and then, the driver installer itself decide which version to install (english or spanish) using the correct file. I didn't know about this behavior of the installer because i never added both files in the same folder, its really useful.

Thanks to all.