ODBC drivers

mabus92920 · 01-18-2005, 08:06 PM

I need some help on ODBC drivers. The thing is I am running on redhat 9, and I also run crossover office and wine in it to run windows applications such as Microsoft Access or Excel.

I made an applicaion, using JAVA, that connects to a MsAccess database, and a MSExcel worksheet using ODBC. I used windows XP to run that, but I want it to run on linux. There's no problem running the app since its made in JAVA.

So how do I connect to excel and access using linux????

can anyone help? thanks in advance..

jerm1701 · 01-18-2005, 08:33 PM

I have no idea about ODBC, but you may want to try JDBC, the Java version.

Good luck!
Jeremy

cswor · 01-22-2005, 03:15 PM

i dnn't have first hand experience with this, but:

fedora core 3 ships with unixODBC. you can check your install with "rpm -q unixODBC". you will need this. beyond that, you can go to http://www.unixODBC.org to get more info. google will also turn up info.

for java apps, why not switch over to JDBC. i assume (don't know for sure) that there is a JDBC driver for msaccess.

mabus92920 · 01-23-2005, 03:58 AM

yes, there is. but if I'll use JDBC for access, then I will have to change my connection strings, which means modifying m y program again. is there any other way ? would it be possible to run it under wine ?