64bit DBeaver + 32 ODBC drivers

Note: please leave bug reports and feature requests on

64bit DBeaver + 32 ODBC drivers

Postby igitur » Tue Nov 20, 2012 12:39 pm

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
igitur
 
Posts: 14
Joined: Fri Oct 07, 2011 12:34 pm

Re: 64bit DBeaver + 32 ODBC drivers

Postby Serge » Tue Nov 20, 2012 2:10 pm

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.
Serge
 
Posts: 1526
Joined: Sat Feb 26, 2011 8:24 pm
Location: SPb


Return to Support



Who is online

Users browsing this forum: Google [Bot] and 19 guests