How to connect PL/SQL Developer 8 and MS Access

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • NarenKeer
    New Member
    • May 2012
    • 14

    How to connect PL/SQL Developer 8 and MS Access

    Hi,

    I am just a newbie trying to learn PL/SQL Developer when I am free in my office. Unfortunately I do not have access to Oracle DB in my office, so thought of starting with MS Access which is familiar to me.

    I have two questions:

    First, is it possible to connect PL/SQL Developer to MS Access?
    Second, if yes, then how can i do it?

    Could some one please help me on this?
  • MMcCarthy
    Recognized Expert MVP
    • Aug 2006
    • 14387

    #2
    You will need to install at least Oracle 9i Client then set up a TNS file with the appropriate Database connection data.

    After that you can set up a simple odbc connection.

    Comment

    Working...