by Hi All,
I cannot select from table MSysRelationships in MS Access through
JDBC/ODBC Bridge
I have set up an ODBC Connection to my data source as a System DSN with
User Name 'admin' and Password
Funnily enough I can obtain this information in Access as user 'admin'
Exception thrown in Java application as follows when I try to execute
the query
System Output: java.sql.SQLException: [42000][Microsoft][ODBC Microsoft
Access 97 Driver] Record(s) can't be read; no read permission on
'MSysRelationships'.
System Output: at ids.sql.IDSSocket.verify(IDSSocket.java:163)
System Output: at ids.sql.IDSStatement.submit(IDSStatement.java:112)
System Output: at ids.sql.IDSStatement.execute(IDSStatement.java:396)
System Output: at
ids.sql.IDSStatement.executeQuery(IDSStatement.java:177)
System Output: at imtflib.db.DBEngine.Select(DBEngine.java:85)
System Output: at
imtflib.db.DBIndexTest.describeTable(DBIndexTest.java:69)
System Output: at imtflib.db.DBIndexTest.<init>(DBIndexTest.java:31)
System Output: at imtflib.db.DBIndexTest.main(DBIndexTest.java:40)
Can I get around this, I cant call method DatabaseMetaData
dmd.getCrossReference(...) as my driver for ODBC does not support this,
I am trying to use Pure JDBC but cannot connect with the URL I am using
without going through ODBC
Thank in advance
Mark O'Connell