IBM OPL - MS Access Connection - "user lacks privileges, object not found"

[Frank Mildner]

Dear SourceForge - Team,

I am trying to read data from an MS Access database into IBM Optimization Studio using OPL Script. I have been following an example provided by IBM on how to use UCanAccess, when setting up this connection. For the exemplary case by IBM the connection works, e.g. the data gets read into OPL and the results get written into the database . This proves that the software set-up works on my laptop.

When I try to set-up the connection for my database and optimization problem I continuosly get the feedback that I lack user privileges or that an object could not be found. As the issue does not concern only one SQL statements but most of the statements, I assume that either I have made a syntax error across all statements or that I need to modify the connection in way that the data becomes readable for UCanAccess. All SQL statments run smoothly on the MS Access Database.

I have attached a zip-file, containing:

• Java-Script provided by IBM to read the data from MS Access via UCanAccess
• jdbc-custom-data-souce.jar provided by IBM to read data via any JDBC connection. The jar is getting called in the Java-Script
• a documentation of the connection error containing
  • Java-Script
  • OPL-Script Statements
  • cmd-Output when running the OPL Script and tryint to read the data from MS Access

I am looking foward to your feedback and want to thank you in advance for your support.

BR,

Frank

[Gord Thompson]

Try running the console.bat or console.sh command-line utility, specify the .accdb file when prompted, and see if ERZEUGNISSE_KOMPONENTEN appears in the list of tables (or views) that are loaded.