Examples of Devart UniDac connecting to Oracle database

Examples of Devart Unidac connecting to an Oracle database using Oracle Client and direct connection (no Oracle Client)

Unidac can connect to an Oracle database in a few different ways.  Ill show the property settings to connect to some of these, using direct and client connection, and with / without Oracle client entries.

This presumes that you know the basics of the configuring the Oracle Client, so I wont explain how to configure the tnsnames.ora file.

For these examples
– the database server name is HRPROD
– the database name is HR
– the client port is 1521.  This is the default and it can be different
– user name is FRED
– password is BEDROCK

The name of the entry in the tnsnames.ora or LDAP is HRPRODXXX

You can use the server ip instead of the server name

Add these components to your form or data module

• OracleUniProvider
• UniConnection

Change the UniConnection properties as noted below

Oracle Client with a tnsnames.ora or LDAP entry

UniConnection1.ProviderName := ‘Oracle’;
UniConnection1.UserName := ‘FRED’;
UniConnection1.Password := ‘BEDROCK’;

UniConnection1.SpecificOptions.Values[‘Direct’] := ‘False’;

UniConnection1.server := ‘HRPRODXXX’;   // tnsname or ldap entry name
UniConnection1.database = ”;
UniConnection1.port = 0;

Oracle Client without a tnsnames.ora or LDAP entry

UniConnection1.ProviderName := ‘Oracle’;
UniConnection1.UserName := ‘FRED’;
UniConnection1.Password := ‘BEDROCK’;

UniConnection1.SpecificOptions.Values[‘Direct’] := ‘False’;

UniConnection1.server := ‘HRPROD’;  // server name or IP address
UniConnection1.database = ‘HR’;     //  if using a service instead of sid use ‘sn=HR’
UniConnection1.port = 1521;

Direct connect to Oracle database (no Oracle Client)

UniConnection1.ProviderName := ‘Oracle’;
UniConnection1.UserName := ‘FRED’;
UniConnection1.Password := ‘BEDROCK’;

UniConnection1.SpecificOptions.Values[‘Direct’] := ‘True’;
UniConnection1.server := ‘HRPROD:1521:HR’;   // for service use ‘HRPROD:1521:sn=HR’
UniConnection1.database = ”;
UniConnection1.port = 1521;

About Me

• Oracle & Delphi software developer based in Perth, Western Australia
• Australian Delphi User Group – President and WA meeting organizer
• Australian Oracle User Group – WA State Committee Member
• Available to do remote presentations to user groups on Delphi and Oracle topics

Author: Scott Hollows

Enterprise software developer based in Perth, Western Australia. Oracle, Delphi, Data Warehouse design and ETL, Data Architect, Business Intelligence, Oracle performance tuning. Oracle ApEx, Discoverer, BI Publisher, OBIEE, Forms, Reports, SQL, PLSQL Australian Delphi User Group (ADUG) - WA branch manager and past national president LinkedIn www.linkedin.com/in/scotthollows View all posts by Scott Hollows