Connect to OLEDB data source from Java?

Question

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).

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

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

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.

Answer 1

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.