Installation

This kit includes Version 3.1.0.3 of the Oracle ODBC Driver for Rdb. This version is considerably different internally from the version 2 Oracle ODBC Driver for Rdb software.

The ODBCTST program is no longer shipped with the ODBC driver. This program was provided only as a way to verify that the driver has been installed properly and that DSN connections work. The addition of a TEST CONNECTION button on the Setup dialog box eliminates the need for ODBCTST for that purpose. Additional verification of correct operation can be performed with any of the available Microsoft data access tools.

Installation

This product is installed by the Oracle Universal Installer, a completely different technology from that used by v2 releases of the Oracle ODBC Driver for RDB.

To assist those customers who do not already have the Universal Installer, this kit is being made available in two forms, one without the installer included (about 1 MB in size) and one with the installer (about 12 MB in size). Both kits are distributed on the web in the form of self-extracting ZIP archives.

SPECIAL NOTE: The v3.1.0.0 and subsequent releases of the ODBC driver for RDB use a newer version of the Installer than previous versions If you do not already have v2.2.0.12 of the Oracle Universal Installer, you will need to use the larger kit.

To install the larger kit, run the SETUP.EXE in the top level ("Disk1") of the expanded directory tree. This will start the Installer. To install the smaller kit, run the Oracle Universal Installer you already have on your system. When the installer starts, click the NEXT button on the first screen. On the second screen, use the BROWSE button to set the "source" to the "products.jar" file inside the "STAGE" directory. (With the larger kit, this will already be set correctly.)

Software Errors Fixed in Oracle ODBC Driver for Rdb, Release 3.1.0.3

• TEST CONNECTION button does not fully test the connection to the database
• DBKEY is not shown correctly after upgrading ODBC Driver for Rdb 3.1.0.2 from 2.1

New Features in Oracle ODBC Driver for Rdb, Release 3.1.0.2

• Added a TEST CONNECTION button on the ODBC Administrator setup dialog box. This allows new connection parameters to be tested directly without using the ODBCTST utility. Accordingly, as was done with our ODBC Driver for Oracle9, we have stopped shipping the ODBCTST utility with the ODBC driver and no longer support it.

Software Errors Fixed in Oracle ODBC Driver for Rdb, Release 3.1.0.2

• SQLColumns returns incorrect results
• SQLDescribeCol incorrectly returns SQL_VARCHAR for List of Byte Varying

Software Errors Fixed in Oracle ODBC Driver for Rdb, Release 3.1.0.1

• Zero length VARCHAR always treated as null terminated
• SQLColumns returns invalid string length on column 7 for char and varchar
• A fetch following SQLTables may return Driver Not Capable
• SQLBrowseConnect returned an incomplete connect string
• SQLDriverConnect did not return connect string when ProxyAccess=2
• SQLDriverConnect returned invalid hold cursor value on return connect string
• SQLFetchScroll now supported
• Added functionality to fetch ahead processing
• SQLStatistics may fail on fetch if column 11 is bound to SQL_C_SBIGINT
• SQLTables did not return system tables if TableType was not specified
• Calling a stored procedure with output parameters resulted in a General protection fault

Software Errors Fixed in Oracle ODBC Driver for Rdb, Release 3.1.0.0

• Duplicate cursor name using Powerbuilder
• Can not override service name in driver login dialog
• HELP button fixed
• Optimization in Connecting to pre-attached service
• General Error after SQLFreeStmt
• SQL data type out of range with VARBYTE LIST
• Incorrect parsing of literal values
• SQL_NO_DATA from SQLExecute for ODBC v2 applications

Software Errors Fixed in Oracle ODBC Driver for Rdb, Release 3.0.2.6

• SQLExecute returns error when calling stored procedure
• Unhandled Exception when using long hostnames
• Invalid precision error returned when fetching SQL_BIGINT
• SQLGetTypeInfo failed to return valid data in certain columns
• SQLColAttributes returns invalid value for SQL_DESC_SEARCHABLE
• Unable to insert into List of Byte Varying

Software Errors Fixed in Oracle ODBC Driver for Rdb, Release 3.0.2.5

• Incorrect values returned when bound size does not match DB data size
• ANSI DATE and TIME data truncated
• Fetch stops prematurely on array fetch
• Fetch-ahead not working efficiently
• Invalid Precision error when binding parameters

Software Errors Fixed in Oracle ODBC Driver for Rdb, Release 3.0.2.4

• Binding as SQL_C_DEFAULT erroneously bound as CHAR instead

Software Errors Fixed in Oracle ODBC Driver for Rdb, Release 3.0.2.3

• Numeric columns bound as binary integer types give wrong results

Software Errors Fixed in Oracle ODBC Driver for Rdb, Release 3.0.2.2

• SQLColAttributes returning zero for SQL_COLUMN_LENGTH
• SQLColAttribute and SQLColAttributes returning null column name
• SQLColumns returning no rows if table name contains underscore

Software Errors Fixed in Oracle ODBC Driver for Rdb, Release 3.0.2.1

• SQLTable returned rows in wrong order
• SQLSetConnectAttr failure message when connecting
• SQLGetTypeInfo fetch fails if columns bound first
• Attempts to set the CURRENT_CATALOG attribute failed
• "Movefirst" operation in VB resulted in wrong rows fetched
• SQLColAttributes returning wrong values
• Could not retreive output parameters from stored procedures
• Binding a BIGINT(2) INPUT parameter as SQL_NUMERIC failed
• Wrong version number in driver log file
• SQLTables returned no rows when wildcards used
• Performance problem with array fetching with FETCH_MANY

Software Errors Fixed in Oracle ODBC Driver for Rdb, Release 3.0.2

• SQLTables had wrong column labels
• HELP file difficult to find
• Procedures without output parameters do not work
• Parameters in Connect String ignored
• SQLSetStmtAttr returned "Driver not capable"
• Performance problem when fetching large amounts of data
• SQLColumns returning wrong date/time info
• Character sets translated incorrectly
• SQLTables not returning all types requested
• SQLProcedureColumns not returning all columns
• SQLColAttribute returns null column name
• Integers returned as NUMERIC did not work
• DBKEYs returned as binary
• SQLTables returned no tables
• HELP files installed under wrong name
• Various installation and deinstallation problems
• BIGINT data types not properly converted