64bit DBeaver + 32 ODBC drivers

[igitur]

Hi,

As mentioned in a previous post, I'm connecting to a Visual Foxpro 9 database through JDBC / ODBC. Currently, only a 32 bit ODBC driver exists (refer to http://stackoverflow.com/questions/6543 ... -windows-7 ).

We have some Windows 7 64 bit machines. How do I get DBeaver 64 bit to use the 32 bit ODBC drivers? I've managed to install Java 32bit + DBeaver 32bit, but this means there are now 2 versions of Java on the PCs and I'm concerned it's going to become a logistical nightmare to maintain multiple JREs on these machines.

Is there any way for DBeaver 64bit to be forced to use the 32bit ODBC driver?

thanks,
Francois

[Serge]

Hi,

Generally you can start DBeaver using any custom JRE you have on your local computer. Just set -vm command line argument to JRE_HOME\bin directory.

In fact there are 2 possible solutions:
1. You may use 32-bit and 64-bit JREs on a single machine. You may download 32-bit JRE from Oracle site and install it in some custom location. Your current default JRE should remain as is. dbeaver.exe will find appropriate JRE itself if you have both 32-bit and 64-bit JREs installed.
2. You may simply copy 32-bit JRE directory from another computer. It doesn't need any system libraries or registry settings or anything else.
Then just start 32-bit DBeaver with -vm parameter pointing to your new JRE location \bin.

In future we plan to make DBeaver versions with JRE included but it won't happen soon. Probably in the next year (at least when we will have better hosting).

And I don't think that it is possible to use 32-bit native driver in 64-bit environment. At least using 32-bit JRE is an simplest solution.

Hope it'll help.