Home > Documentation > MS Access to Oracle > Tutorial
Step 1 of 5. Connect to Oracle Server
On this wizard screen you should enter the necessary settings to establish connection with Oracle server.
- Server - IP address or network name of Oracle server machine. If the converter has been installed on Oracle server machine, you can specify "127.0.0.1" or "localhost" in this box.
- Database name - name of Oracle database. Enter the same title that you use with SQLPlus or any other standard Oracle applications.
- Port - port for connecting to Oracle. It is necessary to specify it only if it differs from default value 1521.
- Username - your Oracle username for the database to which you are connecting
- Password - your Oracle password for the database to which you are connecting
Access-to-Oracle provides two methods of connecting to Oracle server: directly and via TNSNAME.ORA entry. To use the first method you have to enter information in all fields except the port if it is configured by default (1521). To use the second method you have to leave both "Server" and "Port" fields empty and enter Oracle service name as it appears in TNSNAME.ORA file in "Database" field.
Sometime user enters all Oracle connection settings properly but still may get the following error: "Oracle data source doesn not exist. Check to verify correct name was given.". It means that the program failed to conect to the destination server using the selected method. To bypass this error you can try the following trick. Leave both "Server" and "Port" fields empty and enter in "Database" field the entire connection string as follows:
(DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(ADDRESS=(PROTOCOL=TCP)(HOST=IP address of Oracle server)(PORT=1521)))
Of course, you need to replace "IP address of Oracle server" in the sample above with the actual value of IP address.
Have questions? Contact us