从Java连接到OLEDB数据源? [英] Connect to OLEDB data source from Java?

问题描述

我们正在尝试连接到ACT CRM系统使用的SQL Server实例.他们设法锁定了一切，因此无法使用ODBC连接到SQL后端(有一些特殊的实用程序会添加ODBC支持，如果您购买该软件的原始版本，则可以安装该支持，但这是疯了).

We are trying to connect to a SQL Server instance used by the ACT CRM system. They have managed to lock things down so it isn't possible to connect to the SQL back-end using ODBC (there is some special utility that will add ODBC support that you can install if you purchase the primo version of the software, but that's just crazy).

推荐的连接这些数据库的方法是使用OLEDB连接.

The recommended method of connecting to theses databases is using an OLEDB connection.

有人对从Java建立和使用OLEDB连接有任何窍门/想法/等...吗?

Does anyone have any tricks/ideas/etc... for how to make and use an OLEDB connection from Java?

如果不可能的话，则不必是JDBC.我们真正需要做的就是执行一个SELECT查询，该查询返回两个字段并为每一行解析出这些字段值.我对OLEDB的经验很少，因此使用JACOB"可能是一个很好的答案，但是我希望了解有关COM调用实际上必须是什么的一些详细信息.

This doesn't have to be JDBC if that's not possible. All we really need to do is execute a SELECT query that returns two fields and parse those field values out for each row. I have very little experience with OLEDB, so 'use JACOB' might be a good answer, but I'd appreciate some details on what the COM calls would actually have to be.

推荐答案

我知道这很旧，但是可以帮助某人知道我是怎么做的

I know this is old, but could help someone to know how I did it

我更详细地描述了操作方法在这里.

I described in more detail how to do it Here.

这篇关于从Java连接到OLEDB数据源?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！