Difference:
DatabaseInterfaceUpgrades
(17 vs. 18)
Revision 18
2009-03-02 -
JoeOrtagus
Line: 1 to 1
META TOPICPARENT
name="APPX500InstallationInstructions"
Database Interface Upgrades
Changed:
<
<
Compatibility with newer versions of popular databases is among the many features of APPX 4.3.
>
>
Compatibility with newer versions of popular databases is among the many features of APPX 5.0.
Configuring APPX and RDBMS
Oracle
APPX to Oracle quick installation steps, with the assumption that you have a working install of Oracle 10g R2:
APPX to Oracle detailed installation example:
Create directory for Oracle Instant Client bundle to download to.
Download the Oracle Instant Client files for Linux.
For 10gR2
For 11g
Place the basic and sqlplus zipped files into /usr/local/src/oracle/instantclient/, and unzip them:
Place unzipped Oracle Instant Client files into permanent installation target directory.
Configure the operating system's dynamic linker run time bindings
Build cache used by the operating system's run-time linker
Identify version of libclntsh.so that is included with downloaded Oracle Instant Client bundle
To let APPX know the version of the Instant client you have installed, perform just one of the following two options:
Create libclntsh.so symbolic link and set the APPX_OCI_DIR environment variable
Set APPX_OCI_LIB
Use the Oracle Instant Client's version of SQL*Plus to verify connectify to Oracle.
Configure APPX FMS settings
ODBC
MySQL 5.0.22
Quick installation steps of the APPX to MySQL connection:
Detailed installation example of the APPX to MySQL connection:
Download mysql-connector-odbc from MySQL.com website.
Install MySQL, MySQL -Server, and UnixODBC
Install mysql-connector-odbc version 3.51.22 or newer.
Create MySQL database and database user.
Determine where UnixODBC expects odbc.ini and odbcinst.ini configuration files to be located.
Configure /etc/odbc.ini
Configure /etc/odbcinst.ini
Verify DSNs are working.
Troubleshoot isql problems.
Set the APPX_ODBC_LIB environment variable
Configure APPX FMS parameters.
Microsoft SQL Server (2000, 2005, 2008, SQL Server Express)
Database connectivity debug tools
APPX Environment Variables
Some OS tools to aid in debugging
Comments:
Oracle
Oracle 10g R2 (10.2.0.1)
View topic
|
H
istory
:
r25
<
r24
<
r23
<
r22
|
More topic actions...
Copyright © 2008-2024 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki?
Send feedback