Skip to Main Content

Oracle Database Discussions

Access front end Error

737578Jan 15 2010 — edited Jan 15 2010
I''m using MS Access as a simple application to access engineering back-end Oracle information to run reports on, etc. This is deployed to the users via a network share.

The application probably uses about, say, 15 SQL Pass Through queries (Using the Microsoft ODBC for Oracle Driver) to access the relevant data on an Oracle 9i Database.

Strangely, all the SQL Pass Through queries work (With exactly the same connection string), apart from one! When I try to access this from their client machines I get;

""
ODBC--Call failed.

(Microsoft)(ODBC driver for Oracle)(Oracle)ORA-00511: Message 511 not found; product=RDBMS; facility=ORA(#511)

""

All the other Pass Through's work fine, and on the Admin Client where I build the Access Application it works fine too. I'm stumped as to what the problem could be.

Any help would be greatly appreciated.

Luke

Edited by: user12282018 on Jan 15, 2010 12:51 AM
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 12 2010
Added on Jan 15 2010
11 comments
953 views