Connect to Oracle

Click “New” on the Connectionmenu.

Select “Oracle”.

Connection name: assign a name.

Service name: assign the service name of your Oracle database Server.

Note! You need to have configured the “tnsnames.ora” on your clients PC.

Omiting tnsnames.ora

This is another type of Oracle connection string that doesn’t rely on you to have a DSN for the connection. You create a connection string based on the format used in the tnsnames.ora file without the need to actually have one of these files on the client PC.

(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=MyHost)(PORT=MyPort))(CONNECT_DATA=(SERVICE_NAME=MyOracleSID)))

Authentication: define if the Server is setup for Windows or Oracle authentication.

User: enter the user id.

Password: enter the database password.

SQL dialect: define which Oracle SQL dialect  to use. That should be consistent with the Oracle version of your database.

Enable Offline mode: Learn more here.

Select User Groups who can view the Connection: assign user groups with privileges to open objects from this connection.

Click “Ok” to establish the connection.

Important! It is strongly recommended that you use the latest Oracle © data provider for .Net .

Please check the correct drivers for your Oracle version here.