带有嵌入式数据库的 PowerBuilder 应用程序？
是否可以将 SQLite 等与 PowerBuilder 一起使用？ 我需要一个嵌入式开源数据库（无需额外费用）。
Is it possible to use e.g. SQLite with PowerBuilder? I need an embedded open source database (no additional costs).
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（5）
就像 Bernard 说的，你需要一个 ODBC 驱动程序，所以只要你愿意使用第三方（如果我正确理解 SQLite 的情况），那应该没问题。
也就是说，如果您有 PowerBuilder，您就拥有分发单用户 SQL Anywhere 运行时引擎的许可证。 如果免费是您的唯一标准，并且您仅进行本地连接，那么 SQL Anywhere 可能是一个值得评估的选项。 它不仅是一个极其可靠的数据库，而且还有更丰富的文档基础和将 PowerBuilder 连接到 SQL Anywhere 的经验，因此，如果您遇到问题，您更有可能获得帮助。
祝你好运。
Like Bernard said, you'll need an ODBC driver, so as long as you're willing to go third party (if I understand the SQLite situation correctly), that should be no problem.
That said, if you have PowerBuilder, you have license to distribute the single-user SQL Anywhere run time engine. If no-cost is your only criteria, and you're only connecting locally, SQL Anywhere may be an option to evaluate. Not only is it an incredibly solid database, but there's a much larger base of documentation and experience connecting PowerBuilder to SQL Anywhere, so if you run into problems, you're more likely to get some help.
Good luck.
我不相信 PowerBuilder 包含对 SQLite 的本机支持的驱动程序。 但它肯定有 ODBC 驱动程序，因此即使它不是最有效的，它始终是一种选择。
I don't believe that PowerBuilder contains a driver for native support to SQLite. But it definitely has a driver for ODBC, so that is always an option even if it isn't the most efficient one.
我曾经使用 SQL Anywhere，但最终放弃了它，原因是 Joe Landau 给出的原因 - 无法使用可分发运行时引擎更改架构。
我改用了 Firebird，它有一个嵌入式版本，看起来很可靠。 唯一的问题是我正在使用的 ODBC 驱动程序 (Gemini)，它似乎是最好的可用驱动程序，但似乎已经停业了。 （我刚刚检查过 - 它似乎可以在其他网站上使用。）并且您必须将以下内容添加到您的 PBODB*.INI 文件中：
我对此非常满意。 使用近2年，用户超过1000人，没有任何问题。 如果某些用户需要，您还可以轻松切换到 Firebird 服务器版本。
I used to use SQL Anywhere, but eventually ditched it for the reasons Joe Landau gave - can't change the schema using the distributable runtime engine.
I switched to Firebird, which has an embedded version, and that seems solid. The only issue is that the ODBC driver I'm using (Gemini), which seems to be the best one available, seems to have gone out of business. (I just checked - it seems to be available on other sites.) And you have to add the following to your PBODB*.INI file:
I've been very happy with it. Using it for almost 2 years, with over 1,000 users, and no problems whatsoever. You can also easily switch to the Firebird server version if some users need that.
如前所述，SQL Anywhere 可用且稳定。 但它有一个缺点——您无法使用运行时引擎更改架构。 这使得向已分发的数据库添加列变得困难。
As noted, SQL Anywhere is available and solid. But it has a disadvantage--you can't change the schema using the run time engine. This makes it hard to, say, add a column to a db that you have distributed.
++ DC 对 Firebird 的评论。 最好的免费数据库之一。 我多年来一直使用它来销售给律师事务所的 PB 应用程序。
尽管我使用服务器版本，即使目标是单个工作站。 简化部署以及以后根据需要添加工作站的问题。
我使用标准 Firebird ODBC 驱动程序 http://www.firebirdsql.org /index.php?op=files&id=odbc
我使用过两个很好的 GUI 前端数据库管理工具 - IBOConsole 和 Flamerobin。
++ to the comments by DC on Firebird. One of the best free databases out there. I have used it for years for a PB application I sell to Law Firms.
Although I use the server version even if the target is a single workstation. Simplifies the deployment and the issue of adding workstations later if desired.
I use the standard Firebird ODBC driver at http://www.firebirdsql.org/index.php?op=files&id=odbc
There are two good GUI front database management tools that I hve used - IBOConsole and Flamerobin.