Take the 2-minute tour ×  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.  share|improve this question Why not just
use the type 4 (native) Microsoft JDBC driver? –  Jeremy Smyth
Sep 17 '09 at 19:55 I'll try it (I pr