对具有外部ODBC访问权限的嵌入式DB的建议？ [英] Recommendation for Embedded DB with External ODBC Access?

问题描述

是否存在一个可以嵌入Java程序中但还允许通过ODBC访问的数据库；

Is there a database that can be embedded in a Java program but also allow access through ODBC; more specifically, ODBC through ADOdb?

环境是MS Windows（XP上）。

The environment is MS Windows (XP on).

情况是Java程序（我的程序）运行一个外部程序（不是我的程序），该程序使用ADOdb.Connection对象连接到嵌入式数据库并提取数据。哦，旧版支持。

The situation is that a Java program (mine) runs an external program (not mine) that uses an ADOdb.Connection object to connect to the embedded database and extract data. Oh, legacy support.

我一直在尝试使用Derby（即JavaDB / Cloudscape）和NetworkServerControl对象进行设置，但无法弄清楚如何配置System DSN，以便ADODB.Connection对象可以连接。可能是我做错了，但是我不知道如何指定Derby文件的路径。

I've been trying to set this up using Derby (i.e. JavaDB/Cloudscape) and the NetworkServerControl object, but cannot figure out how to configure the System DSN such that an ADODB.Connection object can connect. Chances are I'm doing it wrong, but I can't figure out how to specify the path to the Derby files.

是否可以通过这种方式访问​​嵌入式数据库？最好是一个（与Derby不同）不需要不需要的第三方驱动程序来进行ODBC访问？

Is there an embedded db that can be accessed in this manner? Preferably one (unlike Derby) that doesn't require unsupported third-party drivers for ODBC access?

或者，我会完全错误吗？我不太熟悉数据库，也不太熟悉ADOdb或.NET。

Alternatively, am I going about this completely wrong? I'm not very conversant with databases, nor ADOdb or .NET in general.

推荐答案

H2 在功能列表中声明了ODBC驱动程序（但仍处于试验阶段）。

H2 stated a ODBC driver on the features list (but still experimental).

这篇关于对具有外部ODBC访问权限的嵌入式DB的建议？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！