Solved

Connect MS Access to Cloud JD Edwards Database

Posted on 2014-02-10
4
464 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)
ID: 39848528
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
ID: 39848585
@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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …

803 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