从 Mac OSX 连接到进度数据库
有谁知道如何从 Mac(甚至 Linux)连接到 Progress 9.1E 数据库?
我可以从 Windows 成功连接,但 JDBC 驱动程序要求 Progress 安装目录及其 bin 目录位于路径中。
它似乎是谷歌密切关注的一款产品。 OpenLink 有一个 OSX 驱动程序,但它是付费产品,这很好,但因为这是用于开发的仅使用我宁愿找到免费的替代品。
谢谢。
Does anyone know how to connect to a Progress 9.1E database from a Mac (or even from Linux)?
I can connect successfully from Windows but the JDBC driver requires that the Progress install directory and it's bin directory are in the path.
It seems to be one product that is firmly under Google's radar. OpenLink has an OSX driver but it is a paid for product, which is fine, but as this is for development use only I'd rather find a free alternative.
Thanks.
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(3)
如果您将进度升级到 Openedge (Progress v10),其 jdbc 驱动程序不需要安装任何进度相关的安装,因为它是 100% 纯 java(类型 4 驱动程序),因此您可以从任何支持 java 的操作系统访问 Openedge DB。
If you upgrade your progress to Openedge (Progress v10) its jdbc driver doesn't require any progress related installation, because it's 100% pure java (type 4 driver), so you can access Openedge DB from any OS that supports java.
您需要 Progress SQL92 客户端访问,Mac 不受支持,RedHat、SuSe 和几种风格的 Unix 受支持。
请参阅 Progress 版本 9 产品可用性矩阵,查找 ODBC 和JDBC。
据我所知,世界上只有两家公司为 Progress DB 生产 ODBC/JDBB 连接驱动程序:OpenLink 和 DataDirect(现已被 Progress 收购)。
另一种方法是使用 Progress AppServer 进行连接,然后您就可以在 AppServer 上运行 Progress 4GL(或 ABL - 高级商业语言)查询/逻辑并将结果数据集输出到 Java。
第三种方法是迁移数据(如果可以选择)。
其他选项包括通过 WebSpeed(Web 应用程序服务器)公开数据库或使用套接字、文件、获取 OpenEdge 以及通过 4GL Web 服务公开数据等。这实际上取决于您的数据访问需求。然而,所有这些方法都非常重要,需要 Progress 平台和 4GL 专业知识。
You need Progress SQL92 Client Access, Mac is unsupported, RedHat, SuSe and several flavours of Unix are.
See Progress Version 9 product availability matrix, look for ODBC and JDBC.
As far as I know there are only two companies in the world that produce ODBC/JDBB connectivity drivers for Progress DB: OpenLink and DataDirect (now acquired by Progress).
Another way is to connect using Progress AppServer, then you'd be able to run Progress 4GL (or ABL - Advanced Business Language) queries/logic on AppServer and output resulting datasets to Java.
The third way is to migrate the data (if this is an option).
Other options include exposing DB via WebSpeed (web application server) or using sockets, files, getting OpenEdge and exposing the data through 4GL web services etc. This will really depend on your data access needs. However all of these methods are non-trivial and require Progress platform and 4GL expertise.
大约 4 年前,我使用 OpenLink ODBC 驱动程序通过 ProgreSQL 在 MAC 上进行了开发。不记得太多问题,但它引入了商业问题(成本!)....部署。
http://developer.apple.com/internet/opensource/postgres.html
等一下!!那是 PostgreSQL,这不是同一件事。我无法删除这个答案,因为下面的评论中有有用的信息。
I did a development on MAC with ProgreSQL using OpenLink ODBC drivers about 4 years ago. Don't remember too many problems but it introduces commercial problems (costs!).... for deployment.
http://developer.apple.com/internet/opensource/postgres.html
Wait a minute!! that was PostgreSQL which isn't the same thing is it. I can't delete this answer because there is useful info in the comments below.