========================================================= FDO KingOracle Provider Installation Notes ========================================================= ---------------------------------------------------------- 1. Installing the provider For Windows : 1.1 Install King.Oracle provider Copy the provider files (KingOracleProvider.dll KingOracleMessage.dll KingOracleOverrides.dll) to the location of FDO libraries. On Windows, it would be in the \FDO subdirectory of where your MapGuide Server component is installed, e.g. C:\Program Files\MapGuideOpenSource\Server\Bin\FDO * Add an entry for the provider to the providers.xml file. King.Oracle.0.1.1 King Provider for Oracle Read/write access to spatial and attribute data in an Oracle Spatial. False 0.1.1.0 3.1.0.0 KingOracleProvider.dll Make sure you match the FDO version to whatever the other entries in the provider.xml are using (in this example it is 3.1.0.0). 1.2 Install King.Oracle provider with Instant client Copy the provider files from Win32_InstantClient directory (KingOracleProvider.dll KingOracleMessage.dll KingOracleOverrides.dll,oraociei10.dll,oraocci10.dll,orannzsbb10.dll,oci.dll ) to the location of FDO libraries. On Windows, it would be in the \FDO subdirectory of where your MapGuide Server component is installed, e.g. C:\Program Files\MapGuideOpenSource\Server\Bin\FDO * Add an entry for the provider to the providers.xml file. King.Oracle.0.1.1 King Provider for Oracle Read/write access to spatial and attribute data in an Oracle Spatial. False 0.1.1.0 3.1.0.0 KingOracleProvider.dll Make sure you match the FDO version to whatever the other entries in the provider.xml are using (in this example it is 3.1.0.0). If you use King.Oracle Instant client you need to check connection string ( use TNS name or sql connection) Here is Oracle documentation about that: ----------------------------------- From Oracle Documentation ----------------------------- Database Connection Names for Instant Client All Oracle net naming methods that do not require use of ORACLE_HOME or TNS_ADMIN to locate configuration files such as tnsnames.ora or sqlnet.ora work in the Instant Client mode. The connectString parameter in the createConnection() call can be specified in the following formats: As an SQL Connect URL string, of the form: //host:[port][/service name] such as: //myserver111:5521/bjava21 As an Oracle Net keyword-value pair. For example: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp) (HOST=myserver111) (PORT=5521)) (CONNECT_DATA=(SERVICE_NAME=bjava21))) As a connection name that is resolved through Directory Naming when the site is configured for LDAP server discovery. As an entry in the tnsnames.ora file. If the TNS_ADMIN environment variable is not set, and TNSNAMES entries such as inst1 are used, then the ORACLE_HOME variable must be set and the configuration files are expected to be in the $ORACLE_HOME/network/admin directory. Naming methods that require TNS_ADMIN to locate configuration files continue to work if the TNS_ADMIN environment variable is set. The ORACLE_HOME variable in this case is only used for locating Oracle Net configuration files, and no other component of OCCI Client Code Library uses the value of ORACLE_HOME. ----------------------------------- End of Oracle Documentation ----------------------------- ---------------------------------------------------------- 2. Using the provider in MapGuide Connecting to an Oracle data source in MapGuide Studio is done by creating a new Data Connection to the KingOracle Provider and setting connection properties. 1. UserName (Oracle UserName ) 2. Password (Password for Oracle user ) 3. ServiceName ( Oracle servicename - you need to setup oracle servicename in oracle client ) 4. OracleSchema ( Eneter name of oracleSchema If you want to use tables just from one OracleSchema - leave blank for all OracleSchemas ) 5. KingFdoClass ( Eneter name of Oracle Table which will be used to describe FDO Class; look for documentation for more description - you can leave it blank ) ---------------------------------------------------------- 3. Release Notes KingOracle provider has been tested with: * Oracle 10G R2 , 10G R1 , 9.2 * MG OS 1.1 , 1.0.1 * MG Ent 2007 * Autodesk MAP 2007 * FDO 3.2 , FDO 3.1 ========================================================== Haris Kurtagic September 1, 2006