Home > Documentation > MS Access to Oracle > Tutorial
On this wizard screen you should enter the necessary settings to establish connection with Oracle server.
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