To connect to an Oracle XE database, use the database tab (bottom of the screen) and select NEW | Database connection. Pick Oracle Database from the Type list. Now follow the next steps.
Specify the TNS name of the database.
![Image](http://support.dynamicai.com/forum/images/sup/OracleXEConnNoSch.jpg)
The Owner/Catalog field is optional.
![Image](http://support.dynamicai.com/forum/images/sup/OracleORADBConn.jpg)
The system account is called SYSTEM - if you cannot connect with the chosen account, it sometimes helps to try using SYSTEM. If SYSTEM works, then the fault lies with the permissions of the other account.
Test the connection by pressing the ‘Test Connection’ button.
Dynamic AI supports connecting to Oracle using OLEDB providers from either Microsoft or Oracle. Although similar in performance, there are a few differences between the two.
The Microsoft Oracle OLEDB provider does not support fields of the TIMESTAMP and CLOB data types.
Oracle’s own OLEDB provider supports TIMESTAMP fields, but exposes them as regular DATETIME fields. CLOB fields are also supported.
Use the type Oracle OraOLEDB on the connection definition to use the Oracle driver.
![Image](http://support.dynamicai.com/forum/images/sup/OracleXEHR.jpg)
Click SAVE to save the connection. Now you should see the database in the database Explore and be able to browse and use Tables and Views of the database.
If no Owner/Catalog is specified all underlying schema's that the user has access to will be available from Explore database connection:
![Image](http://support.dynamicai.com/forum/images/sup/OracleXENoSchBrows.jpg)
If Owner/Catalog is specified - only that particular schema will be accessible:
![Image](http://support.dynamicai.com/forum/images/sup/OracleXEBrowseHR.jpg)
ODBC/OLEDB driver
To get the connection to work, the ODBC/OLEDB driver for Oracle XE should be installed. This can be checked in the Control Panel -> Administrative Tools -> ODBC Driver.
Under the tab Drivers. Check whether the Oracle XE driver is installed.
Interested in a free Dynamic AI Personal edition? Download the latest version from: http://www.dynamicai.com/download.htm
Would you like a Dynamic AI Server edition trial version please contact: info@dataaccess.nl
If you have any questions, you are always welcome to contact one of our partners (more information available at: www.dynamicai.eu , www.dynamicai.com) in your country, or e-mail your questions directly to: info@dataaccess.nl
Copyright © 1998-2009 CINTAC A/S and/or its suppliers. All rights reserved. Dynamic AI ™, Dynamic Financials ® and CINTAC Dynamic are registered trademarks or trademarks of CINTAC A/S.
Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.