Connection to Oracle

DatAdmin supports connecting to Oracle using ODBC, OLE DB or native client. In all cases, you can use Oracle specific features.

Connection using Oracle instant client

At first, download client library from Oracle WEB:

http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html

You need "Client Package - Basic". Lite version will not work correctly in all cases.
Download and unzip this client to single folder on your disk, eg. c:\instant_client_11_2.

In Options/Oracle/Client Settings, set Client Path to folder of package (in this folder should be library OCI.DLL)

After these steps, your are ready to connect to Oracle:

Tips

• When connecting to Oracle 10g Express, SID should be orcl
• Dialect - (Default) can stay here, in Oracle connection than Oracle dialect is choosen
• Default Oracle port is 1521