Re: ???JDeveloper JDBC-ODBC bridge

From: Adrian Sherwood <nospam_at_nowhere.com>
Date: Tue, 16 Mar 1999 10:56:29 +0800
Message-ID: <7ckhvp$jck$1_at_news.iinet.net.au>


PROMTEX wrote in message <36E8C229.E3AD38E1_at_te.net.ua>...
>I tried to connect to Access-97 database through JDBC-ODBC bridge, but
>got a message "ODBC driver not capable".
>This driver was in Microsoft Office 97 Suite along with Access.
>Anybody could help me?
>E-mail me please gb_at_promtovary.com
>
I think the problem is that the driver does not provide metadata that is used by the database orientated wizards in JDeveloper. You can still create apps that use Access through JDBC in JDeveloper but you can't use the wizards.

One strategy could be to develop your app against an Oracle database with the same structure and then all you have to do is change the connect URL to access the Access version. I know its not ideal.

A.Sherwood Received on Tue Mar 16 1999 - 03:56:29 CET

Original text of this message