Solved

Connect MS Access to Cloud JD Edwards Database

Posted on 2014-02-10
4
443 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

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

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

Never store passwords in plain text or just their hash: it seems a no-brainier, but there are still plenty of people doing that. I present the why and how on this subject, offering my own real life solution that you can implement right away, bringin…
Get to know the ins and outs of building a web-based ERP system for your enterprise. Development timeline, technology, and costs outlined.
Familiarize people with the process of utilizing SQL Server stored procedures 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 Micr…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…

912 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

19 Experts available now in Live!

Get 1:1 Help Now