Simon Grantham wrote:
>I just installed 2.1 and it looks to be a great tool. However, after
>connecting to an Oracle 9i database using the OCI driver, I can look at
>things with the exception of Primary/Imported/Exported keys. I don't
>get privilege violations and in fact, if I link the various tables to an
>MS Access database through ODBC, MS Access shows the primary keys.
>
>
Simon,
I would hazard to guess that not many use an Oracle OCI driver with
SQuirreL.(I've never tried the
OCI driver - does it use SQL*Net and tnsnames.ora?) Perhaps you can
give the Type-4 JDBC
driver a try? If memory serves me correctly, I believe Oracle
recommends the pure-Java driver
anyway. I use it, and can access the information you are looking for.
Rob Manning
|
