Configure SQL Developer

This guide will show you how to configure the SQL Developer application which you have setup by running R:\Install\SQLdeveloper\goSQLDev.cmd from your OXY PC.

Once SQL Developer has been setup you just need to follow these steps to connect it to the OXY Oracle database.

There should be a folder called “SQL Developer” in L:\MDB-IRAP. If you can not access this folder you will want to contact ISG to grant you access. Copy this to your C: drive. Run the sqldeveloper.exe, it may ask you to download Java plugins, go ahead and do that.

Then set up a connection to the database by following these steps:

How to Convert an ADP File to MDB

ADP and MDB files are two types of database files created by Microsoft Access 97, 2000, 2002 and 2003. ADP files are the SQL data files, while MDB files contain Access project information about the set of ADP files that are contained within the Access project. If you have an ADP file and Microsoft Access on hand, you can convert the ADP file to an MDB file through a simple Access operation.

Open Microsoft Access.
Click “File,” then click “Open,” then click on the ADP file that you want to convert.
Click “File,” then click “Share” then click the “Save Database As” button.
Select the “Access Database” file type, then type in the name you want the MDB file to have.
Click the “Save” button and the MDB file is created and saved to the computer.

An example of parameters that need to be set.