Dynamic AI - Oracle XE

Information related to Oracle Databases

Dynamic AI - Oracle XE

Postby Carsten Sørensen » Mon Jan 19, 2009 3:12 am

Connecting Dynamic AI to Oracle XE

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

The Owner/Catalog field is optional.

Image

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

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

If Owner/Catalog is specified - only that particular schema will be accessible:

Image

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.
User avatar
Carsten Sørensen
Certified Dynamic AI Professional
 
Posts: 304
Joined: Thu Aug 16, 2007 1:25 pm
Location: Copenhagen

Oracle 11g

Postby Carsten Sørensen » Thu Jan 22, 2009 11:47 am

The same connectivity methods are used and works for Oracle 8, 9, 10 and 11g
User avatar
Carsten Sørensen
Certified Dynamic AI Professional
 
Posts: 304
Joined: Thu Aug 16, 2007 1:25 pm
Location: Copenhagen


Return to Oracle / XE

cron