适用于Unix的MsAccess的JDBC驱动程序 [英] JDBC Driver for MsAccess which will work on Unix

问题描述

我需要在Unix环境中使用MsAccess的JDBC驱动程序

I need a JDBC driver for MsAccess to be used in a Unix environment

我强烈希望它是开源的

它还应该支持SQL语句

Also it should support SQL statements

(Jackcess几乎是我的选择-但它不支持SQL查询) http://jackcess.sourceforge.net/faq.html#query

(Jackcess came close to being my choice- but it doesn't support SQL queries) http://jackcess.sourceforge.net/faq.html#query

推荐答案

我建议使用Type 4 JDBC驱动程序(即完整的Java)，更确切地说是来自此答案(某些替代方法).可悲的是，它不是开源驱动程序，也不是免费的.但是，如果您使用的是Oracle，我认为您可以花大约300美元购买驱动程序.

I'd recommend to use a Type 4 JDBC driver (i.e. full Java), more precisely the driver from HXTT (see this answer for some alternatives). Sadly, it's not an open source driver and it's not free. But if you are using Oracle, I think you can spend around 300 bucks for a driver.

这篇关于适用于Unix的MsAccess的JDBC驱动程序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！