How do I access ODBC databases such as Oracle, Microsoft SQL Server, and Microsoft Access from Actuate Reporting Applications?

Use the Easysoft ODBC-ODBC Bridge to access remote ODBC databases from Actuate running on UNIX.

Download the ODBC-ODBC Bridge for your Actuate platform and install the ODBC-ODBC Bridge client. Then download the ODBC-ODBC Bridge for your ODBC driver platform and install the ODBC-ODBC Bridge server. Set up and test an ODBC-ODBC Bridge client data source under unixODBC (refer to the ODBC-ODBC Bridge manual for information about how to do this).

Tell Actuate about the ODBC Driver Manager. The following steps assume that you installed Actuate in $AC_SERVER_HOME and the ODBC-ODBC Bridge in /usr/local:

1. cd $AC_SERVER_HOME/lib
   ln -s /usr/local/easysoft/unixODBC/lib/libodbc.so ODBC.so

2. You should not need to set ODBC_INI_PATH or ODBC_MGR_PATH in pmd7.sh.
3. Make sure pmd7.sh sets LD_LIBRARY_PATH to include:

   /usr/local/easysoft/lib:/usr/local/easysoft/unixODBC/lib

• About Easysoft

• Contact us
• About us
• Clients
• Blog
• Careers

• Products

• ODBC drivers
• JDBC drivers
• Bridges and gateways
• In development

• Services

• Consultancy
• Training
• Custom development

• Licensing

• Product licenses
• Prices

• Support

• Support home
• Solution wizard
• Getting Started Guides
• User Guides
• Knowledge Base

• Search

• Easysoft.com
• Documentation
• Knowledge Base

• Popular Resources

• Developer area
• Client applications

• Legal

• Privacy statement

© 1993 - 2024 Easysoft Limited. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other trademarks and registered trademarks appearing on easysoft.com are the property of their respective owners.

• 
• 
•