Solved

Connect MS Access to Cloud JD Edwards Database

Posted on 2014-02-10
4
419 Views
Last Modified: 2016-02-10
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
Comment
Question by:TEKDEVSC
4 Comments
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
Comment Utility
Changed Oracle Database to Databases Miscellaneous

slightwv
Zone Advisor
0
 
LVL 21

Accepted Solution

by:
Boyd (HiTechCoach) Trimmell, Microsoft Access MVP earned 500 total points
Comment Utility
@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

Featured Post

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

Exception Handling is in the core of any application that is able to dignify its name. In this article, I'll guide you through the process of writing a DRY (Don't Repeat Yourself) Exception Handling mechanism, using Aspect Oriented Programming.
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now