Connect to Oracle Server (AnyDAC)

From RemObjects Software

Jump to: navigation, search

This is a AnyDAC Database Connectivity entry
Feel free to add your notes to this topic below.



Supported versions

The AnyDAC native driver supports Oracle Enterprise, Standard (ex Workgroup) and Express (ex Personal) server editions version 8.0.3 and higher. You can also work with other Oracle database products by using AnyDAC/ODBC or DBX Bridge drivers.


Client software

AnyDAC requires one of the following Oracle client software types to be installed on the workstation:

  • "Fat" Oracle Client (details). It requires the standard install procedure.
  • "Thin" Oracle Instant Client (details). It must be copied either into a folder in the PATH or into the EXE folder.


Connection definition parameters

DriverID=Ora

Parameter

Description

Example value

Database

The value may be one of the following:

  • TNS alias name, specifying the database to connect to.
  • The full connection descriptor, as it is in TNSNames.ora
  • The full Oracle connection string, as it is in SQL*Plus.
  • OraSrv
  • (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = OraSrv)(PORT = 1521)))(CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = orcl)))
  • scott/tiger@OraSrv
  • system/manager@OraSrv as sysdba

OSAuthent

Specify Yes to use OS authentification, and No to use DBMS authentification.

No

UserName 

The Oracle user name, if OSAuthent=No

Scott

Password

The Oracle user password, if OSAuthent=No

tiger

AuthMode

The Oracle authentification mode:

  • Normal - standard user. Default value.
  • SysDBA - user with database administrator priviligies.
  • SysOper - user with database operator priviligies.

Normal

CharacterSet

The character set for the connection. If not specified, then NLS_LANG variable value will be used.

  • UTF8
  • cl8mswin1251

BooleanValues

The ';' separated list of values, which AnyDAC will use to translate ftBoolean values. First value substitues False, second - True. 0;1 is default value.

  • F;T
  • N;Y
  • ' ;X'

SQLTrace

Specify True to turn off SQL Trace in current session. False is default value. It is shortcut for ALTER SESSION SET SQL_TRACE=xxx.

True

OptimizerGoal

Sets default optimizer mode in current session. Possible values - ALL_ROWS, FIRST_ROWS, RULE, CHOOSE. By default, optimizer mode is unchanged. It is shortcut for ALTER SESSION SET OPTIMIZER_GOAL=xxx

ALL_ROWS

HashJoinEnabled

Enables hash join in current session. Possible values - True, False. By default, hash join mode is unchanged. It is shortcut for ALTER SESSION SET HASH_JOIN_ENABLED=xxx

False

NewPassword

Specifies Oracle user new password. AnyDAC will connect to DB using old password and immediately change it to new one.

tiger2

MetaDefSchema

Specifies default schema for application. The design time code will omit schema name in object names, if it is equal to MetaDefSchema.

SCOTT


Usage cases

  • Connect to database using predefined TNS name (stored in tnsnames.ora): 

DriverID=Ora
Database=ORA_920_APP
User_Name=ADDemo
Password=a
  • Connect to database using using host, port and instance name info: 

DriverID=Ora
Database=(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = OraSrv)(PORT = 1521)))
(CONNECT_DATA = (SERVER =    DEDICATED)(SERVICE_NAME = orcl)))
User_Name=ADDemo
Password=a
  • Connect to local database as sysdba: 

DriverID=Ora
User_Name=sys
AuthMode=sysdba
  • Connect to database using TNS name and change the password: 

DriverID=Ora
Database=ORA_920_APP
User_Name=ADDemo
Password=a
NewPassword=b


See Also

Product: RemObjects AnyDAC
Current version: AnyDAC 2.0

Glossary — Features — How To — Components — Tools — Samples — Articles — Architecture — Issues

Retrieved from "http://wiki.remobjects.com/wiki/Connect_to_Oracle_Server_%28AnyDAC%29"
Personal tools