|
| ||||||||||||||||||
 |  |  |  |
This section contains extra information relating to the deployment of the Easysoft ODBC-Oracle Driver.
The Easysoft ODBC-Oracle Driver is an ODBC 3.5 driver and uses the driver manager to provide the deprecated and old ODBC 2 functions:
SQLDescribeParam (not supported by default but see Describe Parameters)
Cursor support in the Easysoft ODBC-Oracle Driver is restricted to FORWARD_ONLY and STATIC.
The Easysoft ODBC-Oracle Driver supports the following scalar functions:
Functions need to be called by using the ODBC escape sequence {fnscalar-function}. For example:
SELECT {fn UCASE(Name)} FROM Customers
The Easysoft ODBC-Oracle Driver will work with Oracle 8.1.7+, 9i.x 10g Release 1+ and Oracle Database XE.
No changes to the driver setup are required if upgrading the Oracle Client software.
The Easysoft ODBC-Oracle Driver will allow access to Oracle databases on version 8.1.7 and upwards.
The following Oracle data types are supported by the Easysoft ODBC-Oracle Driver:
| To control how NUMBER data types are mapped onto ODBC data types, use the DATA_TYPE_MAP parameter. For more information, see Datatype Map. |
| BINARY_FLOAT and BINARY_DOUBLE data types are only available if you are using the Oracle 10g client to connect to Oracle 10g or Oracle Database XE. |
BINARY_DOUBLE
| The TIMESTAMP data types are not supported by Oracle 8 and the retrieval of TIMESTAMP data requires the installation of both Client and Server of version 9+. |
The Oracle Advanced Security option is an Oracle client or server add-on that combines network encryption, database encryption and strong authentication to protect sensitive data stored in Oracle databases. The Advanced Security option:
Oracle Advanced Security requires Net8 or Oracle Net to transmit data securely. The Easysoft ODBC-Oracle Driver uses the Oracle client, which uses these protocols to communicate with the Oracle database server over the network. Applications that access Oracle by using the Easysoft ODBC-Oracle Driver can therefore take advantage of the Oracle Advanced Security option.
For information about configuring the Oracle client and server for use with the Oracle Advanced Security option, see the Oracle Advanced Security Administrator's Guide. No additional Easysoft ODBC-Oracle Driver configuration is necessary.
Real Application Clusters (RAC) is an Oracle High Availability feature that enables an Oracle Database Server Grid by providing a single database that spans multiple low-cost servers yet appears to the application as a single, unified database system. RAC combines the processing power of these multiple interconnected computers to provide system redundancy, scalability, and high availability. Application scale in a RAC environment to meet increasing data processing demands without changing the application code.
To increase the performance of a RAC database, you can add cluster nodes. Each additional node can help speed up application processing.
If a clustered server fails, the Oracle database will continue running on the surviving servers. If more processing power is needed, another server can be added without interrupting user's access to data.
The Easysoft ODBC-Oracle Driver will allow access to Oracle RAC environments. The Oracle client must be configured correctly to take full advantage of the RAC features. Please consult you Oracle documentation for more details.
The Easysoft ODBC-Oracle Driver supports both IPC and TCP/IP network protocols.
The Easysoft ODBC-Oracle Driver supports materialized views. A materialized view is a database object that contains the results of a query. Materialized views stored in the same database as their base tables can improve query performance through query rewrites.
The query rewrite mechanism reduces response time for returning results from the query. It does this by automatically rewriting the SQL query to use the materialized view instead of accessing the original tables. Query rewrites are particularly useful in a data warehouse environment.
For more information about materialized views, see your Oracle documentation.
The Easysoft ODBC-Oracle Driver can be configured to take part in a distributed XA transaction. To do this, add a data source that contains entries that correspond with the xa_open string used by the XA Transaction Manager to connect to the Oracle database server.
For example, the following sample xa_open string opens an XA connection to an Oracle database named "payroll." It also specifies the Net8 link and the username and password used to log onto the Oracle server.
Oracle_XA+sqlnet=ninetwo.oracle+SesTm=35+Acc=P/system/manager+Threads=true+DB=payroll
To make this XA connection available for use by the Easysoft ODBC-Oracle Driver, the data source used to access Oracle needs to contain the following corresponding entries.
Driver = ORACLE
In addition, the XA_Enlist attribute must be set to 1. When this setting is present, the Easysoft ODBC-Oracle Driver accesses Oracle by using the Oracle XA library. Note that the data source can then only be used to access an Oracle database as an XA resource under the control of a Transaction Manager. If you need to access the same database with a non-XA connection, configure a separate data source without the XA_Enlist attribute.
The XA_Connection_String attribute is only required if the DB field is present in the xa_open string. The XA_Connection_String attribute value must be the same as that of the DB field.
A tutorial that provides more information about using the Easysoft ODBC-Oracle Driver in the context of an XA transaction is available from the Easysoft ODBC-Oracle Driver section of the Easysoft web site. The tutorial includes a code sample that shows the point at which an ODBC connection needs to be created and closed to participate in a distributed transaction.
If problems occur with metadata, the METADATA_ID parameter needs to be set to 1 in the odbc.ini file.
For OpenOffice.org 1.0, you need to check the No Metadata Schema check box in the dialogue or set METADATA_DONT_DO_SCHEMA to 1 in your odbc.ini file. This is not necessary for OpenOffice.org 2.0.
PHP4 calls the SQLDescribeParams ODBC function when processing SQL statements that have parameters.
The Easysoft ODBC-Oracle Driver correctly reports that it does not support the SQLDescribeParams function, but PHP4 ignores this and continues with undefined results. See Describe Parameters.
If attempting to fetch LONG data, set the DBI_LONG_SIZE to an appropriate value. See DBI Long Size.
The Easysoft ODBC-Oracle Driver is thread safe in accordance with the ODBC 3.5 specification and can be used behind threaded applications with confidence. Usually applications use one connection handle and multiple threads executing SQL statements on that connection.
The ODBC calls an application makes can be traced:
An application can turn tracing on in the driver manager via the ODBC API SQLSetConnectAttr (...,SQL_ATTR_TRACE,...).
The trace filename may also be specified with the SQLSetConnectAttr attribute SQL_ATTR_TRACEFILE.
Tracing in the driver manager is platform-specific:
Start the ODBC driver manager administration interface via Start Menu > Control Panel > ODBC Data Sources.
Click on Tracing, ensure the specified filename is valid and click Start Tracing Now.
For the unixODBC driver manager, add two attributes to the [ODBC] section (create one if none exists) in odbcinst.ini.
Ensure that the user who is running the application to be traced has write permission to TraceFile (and to the directory containing it), or no tracing information will be produced.
Tracing in the Easysoft ODBC-Oracle Driver is platform-specific:
Update the Registry by running regedit and edit the key:
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\DSN-NAME
where DSN-NAME is the name of the Easysoft ODBC-Oracle Driver data source.
Add a LOG string value and set it to the path and file name of the log file (e.g. \temp\oracle.log).
Add a LOG attribute to the DSN section of the odbc.ini file.
The LOG value is the path and file name of the log file (e.g. /tmp/oracle.log).
| Copyright Notice |
| | | |
