Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 664
  • Last Modified:

Connect MS Access to Cloud JD Edwards Database

We would like to connect MS Access 2012 to a cloud based JD Edwards Enterprise One database to make some reports.  We were sent the following which supposedly has everything we need to connect.  We were also sent a username and password.  How do we connect to the JDE tables?  Thanks!


tnsnames.ora
------------------------
NICPRD =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 64.254.123.247)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = nicprd)
    )
  )
------------------------
0
TEKDEVSC
Asked:
TEKDEVSC
1 Solution
 
slightwv (䄆 Netminder) Commented:
Changed Oracle Database to Databases Miscellaneous

slightwv
Zone Advisor
0
 
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPCommented:
@slightwv, JDE does you an Oracle Database . Probably need to switch it back. See: White paper: Oracle JD Edwards Cloud Computing - Choosing a Deployment Strategy That Fits (PDF)


TEKDEVSC,

You should be able to open an ADO recordset to the remote Oracle JDE table.

MS Access: Connect to Oracle using VBA code in Access 2003/XP/2000/97
***Note: The above example use a DSN. You can do this DSN-less with the connection string they provided you.

This may also be helpful:

Accessing the Oracle Database from Excel Using Oracle Objects for OLE

For information on the connection string  to on Oracle database see:

Oracle Provider for OLE DB connection strings

Oracle connection strings


Also see this docs.oracle.com article: Connecting to Oracle Database

You may also need to install the ODBC drivers for the database. I have not used Oracle databases before but with mySQL, MS SQL, etc I have had to install an ODBC driver before I could connect.

This may be what you need: Oracle10g Provider for OLE DB
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now