DBxtra .NET Version 3 - Last Updated: November 11, 2008
Click New on the Connection menu.
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:
Related
Connect to FoxPro - Database Container
QUICK MENU