Re: get Exported/Imported Keys() doesn't work with JDBC-ODBC
From: Daniel Hagen (dhagen_at_h1-software.de)
Date: 07/15/04
- Next message: Leon Bullock: "Re: getConnection to MS ACCESS problem"
- Previous message: Raquel: "SQL stored procedure on UDB 8.1.3 ...."
- In reply to: Leny: "get Exported/Imported Keys() doesn't work with JDBC-ODBC"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Thu, 15 Jul 2004 16:16:34 +0200
Leny wrote:
> Hi,
>
> I'm using the JDBC-ODBC bridge to access an Access database. Now I face the
> problem of building a graph of the database relationships.
>
> The problem: getExportedKeys() and getImportedKeys() don't work. I don't
> know if is there any workaround for this, but so far I was unable to solve
> it.
>
> Do you know any other (free) driver for the Access database or any way to
> get a graph of the relationships ? Right now only two things came to my
> mind: migrate to MySQL and create the relationships there (something
> impossible in this stage of the development) or write something in VBA in
> Access (that I would like to avoid).
>
> So, if anyone could bring some light here, it'd be *really* welcome.
>
> Thanks in advance,
>
> - Leny
You could create a view on the MSYSRELATIONSHIPS-Table, something like:
SELECT MSYSRELATIONSHIPS.szObject, MSYSRELATIONSHIPS.szColumn,
MSYSRELATIONSHIPS.szReferencedObject, MSYSRELATIONSHIPS.szReferencedColumn
FROM MSYSRELATIONSHIPS
But you really should consider moving away from MS Access with your
application even if it might be expensive for you right now.
The combination Java/JDBC-ODBC/MS-Access is very problematic in many
ways, I learned that the hard way.
Flee while you still can.
Regards
Daniel
- Next message: Leon Bullock: "Re: getConnection to MS ACCESS problem"
- Previous message: Raquel: "SQL stored procedure on UDB 8.1.3 ...."
- In reply to: Leny: "get Exported/Imported Keys() doesn't work with JDBC-ODBC"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
