by Arie Solni » Sun, 31 Dec 1899 09:00:00
Hi, im working with ODBC to Access Microsoft Access Database and i'm
getting some strange errors like: "invalid table name', 'index not
found' etc...
those errors are random !
does sombody know about such erros or better ways to work with ODBC in
Delphi?
by Michael Bowma » Sun, 31 Dec 1899 09:00:00
For starters...
What version of ODBC are you using? Make sure your ODBC "driver manager" is
up to date. You can download the latest and greatest from Microsoft.
Next, what ODBC driver are you using to access MS ACCESS?
Not sure why you are getting all those random errors. But rest assured that
its doable.
The only thing you should keep in mind is that the actual MS JET engine that
drives ACCESS is the same driver that ODBC uses to manipulate an access
database via ODBC.
In other words, when you access an ACCESS database via ODBC, the ODBC driver
must load JET because the ODBC driver must play the part of the database
engine... In this case, its JET.
You might try the BDE native driver for ACCESS... Although, we had some
problems with it and finally dropped back to ODBC.
Also, make sure you have the latest BDE from Borland.
Hope this helps,
Michael Bowman
1. Problem accessing System table in Microsoft Access via ODBC
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
3. Concurrent access to Oracle8.1.5 and Microsoft-access via ODBC within a PL/SQL-procedure
4. Oracle Apps DBA's Designer/Developer...(NC/ Sourheast/ East)
5. Microsoft Access ODBC access and multithreading
7. #-2147217900: [Microsoft][ODBC Microsoft Access Driver]
8. --2147467259[Microsoft][ODBC Microsoft Access Driver]Error in row
9. [ODBC Microsoft Access Driver] ODBC--call failed.
10. request working in access but don't work through ODBC
11. COGNOS Access Manager does it work with Microsoft Active Directory