ibmi-brunch-learn

Announcement

Collapse
No announcement yet.

How to access an Oracle database from an RPG program ?

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • How to access an Oracle database from an RPG program ?

    I need to access an Oracle database from an RPG program.
    I am already using JDBCR4 to access a SQL Server database and it works great.
    Unfortunately, I can't seem to do this for an Oracle database.
    Our as400 is in V7R4, I may not have the correct java driver.
    Could you send me all the necessary information so that I can carry out this project.
    Thank you in advance for your help.

  • #2
    You may check the following tool: AppServer4RPG
    Download AppServer4RPG for free. Application Server to make Java Components available for AS/400 RPG programs, runs on as400, i5, iSeries, System i or any other java platform. Packaged with ArdGate to access any JDBC database using all native SQL interfaces from AS/400.

    Comment


    • #3
      Ensure you have the correct JDBC JAR for your DB and that it's in the classpath of the job before the JVM is started in that job.

      Comment


      • #4
        Thanks for your suggestions.
        Both products are now working perfectly.
        AppServer4RPG worked the first time after installation.
        We have found the solution for JDBCR4, the connection properties differ a bit compared to accessing a sql db.

        Comment

        Working...
        X