No support for OLE DB in Java

Hi Tom,

What are you really trying to accomplish? I'm not sure what you mean when you say a database is "behind" an OLE DB interface. Are you talking about Java accessing data directly through the OLE DB drivers provided by Microsoft and other 3rd party vendors or are you talking about something else?

Just for fun, what would your answer be if I posed the question; why don�t Microsoft technologies allow you to connect through JDBC?

To my knowledge there is no JDBC-OLEDB bridge but I think the need for that would be very small, but if there was a need and it was technically feasible, I�m sure some enterprising company would fill it.

Java's JNI interface may allow you to achieve whatever you are attempting, but again I�m not clear on what exactly your goals are.

There may very well be a solution that allows Java and something �behind� an OLE DB interface to successfully interact, and maybe I�m not the right guy to answer the question, but I think it would help if you could be a little more specific on the problem you are trying to solve.

Oh yeah, not a OLE DB connection but a OLE DB Provider

Again, without knowing what you want to do, or do it with, most of what can be written in this thread can only be presumptive, and it would be hit or miss that the responses address your actual problem. You haven't described any problem that can be addressed, and until you do, I don't believe you will receive any posts that will be of much help to you.

J2EE and .NET are competing technologies from different vendors. So is Linux and Windows, but Microsoft supports Linux within Microsoft�s virtual server. So some interoperability does exist between Microsoft products and competing technologies. If you were forthcoming with some details of your issue it is possible that interoperability options are available to you.

Are you looking for a solution, or just someone to agree with your premise that it can be difficult to blend JDBC and OLE DB into a single integrated application code base? If so, then I agree it is difficult to integrate JDBC and OLE DB into single application code base and that combination should probably be avoided.

Having said that, from what little you have said, I see no problem in anything that you are trying to do. Whatever database you are using can be accessed using either J2EE/JDBC Java/JDBC or .NET technologies including SQL Server, MS Access, Oracle, Sybase, DB2/UDB, and many more. Your premise that you want to access these databases using OLE DB through Java is flawed and makes no sense, so that is not a concern and does not affect the ability of competing technologies (JDBC, OLE DB) to successfully access a single database instance. A networked database is application vendor neutral and doesn�t know or care what technologies are being used to access it.

Here is a suggestion. Describe the problem you are having, what the functionality is you are attempting to develop, the technologies you are using and what you have tried so far that has not worked.

Hi,

As I mentioned I'm struggling with a design management system that uses a closed database. The vendor of the program sells an OLE DB provider that can be used to access the database.

My problem is that it seems like there is no way to access an OLE DB data source using Java, am I right? If there is any way I can connect to an OLE DB provider using Java, I would like to know

Sorry if my question was incoherent.

Br,
Tom