home *** CD-ROM | disk | FTP | other *** search
- READ.ME
- INTERSOLV DataDirect Connect ODBC
- Microsoft Windows 95 and Microsoft Windows NT
- Version 3.10
- March 1998
-
- Note: You can only use DataDirect Connect ODBC with the platform(s)
- you have licensed. Licensing options are Windows 95 only, Windows NT
- only, or both. The packing slip indicates your licensed platform(s).
-
- Current reference information is in the electronic book INTERSOLV
- DataDirect Connect ODBC Reference (ODBCREF.PDF) and in the online help
- available with your software (see "Installing and Using the Online
- Documents"). This README file contains database driver information not
- included in the Connect ODBC Reference or the online help.
-
-
- CONTENTS
-
- Version 3.10 Changes
- Available DataDirect Connect ODBC Drivers
- Driver Options
- Notes and Known Problems
- Installing and Using the Online Documents
- Installed Files
-
-
- Version 3.10 Changes
-
- General Changes
- * Now shipping ODBC 3.5 core components
- * JDBC-ODBC bridge removed - now available from JDK vendors
-
- INFORMIX 9
- * New driver
- * Supports INFORMIX-Connect 9.13 to 7.x and 9.x servers
- * Supports new INFORMIX 9 data types (blob, clob, boolean,
- int8, serial8, and lvarchar)
- * INFORMIX distinct data types
-
- OpenINGRES 2.0
- * New driver
- * Supports Ingres-Net 2.0 to 1.2 or 2.0 servers
- * new options for concurrency
- * new options for native date formats
-
- Oracle7
- * Enhanced performance
- * Option for returning result sets from PL/SQL
- * Remote OS authentication
- * SQL_DEFAULT_PARAM support for PL/SQL
-
- Oracle8
- * New driver
- * Supports Net8 8.0.4 to 8.0.3 or 8.0.4 servers
- * Full read/write support for new data types (bfile, blob, and
- clob)
- * Option for returning result sets from PL/SQL
- * Remote OS authentication
- * SQL_DEFAULT_PARAM support for PL/SQL
-
- PROGRESS
- * New option for extended isolation level support
- * New option for international date formats
-
- Sybase
- * Supports Adaptive Server 11.5
- * Long data tuning options
-
- OLE DB-ODBC
- * Components updated to OLE DB 1.5
-
-
- Available DataDirect Connect ODBC Drivers
-
- Driver Supports
- ------ --------
- Btrieve (IVBTR13.DLL) Btrieve 6.x
-
- dBASE (IVDBF13.DLL) dBASE III, IV, and V files, Clipper files,
- FoxPro files versions 2.5 and 3.0
-
- DB2 (IVDB213.DLL) DB2 for OS/2, DB2 for Windows NT, DB2/6000
-
- Excel Workbook (IVXLWB13.DLL) Excel version 5 or 7 workbooks.
-
- FoxPro 3.0 DBC FoxPro 3.0 DBC
- Note that the FoxPro 3.0 driver
- functionality is built into the dBASE
- driver.
-
- INFORMIX (IVINF13.DLL) INFORMIX 5.x, 6.x, or 7.x
- via INFORMIX-Connect 7.2
-
- INFORMIX9 (IVINF913.DLL) INFORMIX 7.x or 9.x
- via INFORMIX-Connect 9.13
-
- OpenIngres (IVOING13.DLL) CA-OpenIngres 1.2 via Ingres Net 1.2
-
- OpenIngres 2.0 (IVOI213.DLL) CA-OpenIngres 2.0 or 1.2 via Ingres
- Net 2.0
-
- Oracle 7 (IVOR713.DLL) Oracle 7.x
-
- Oracle 8 (IVOR813.DLL) Oracle 8.0.3 or 8.0.4 via net8 8.0.4
-
- Paradox (IVIDP13.DLL) Paradox 3.x, 4.x, 5.0, 7.0 and 8.0 tables
-
- PROGRESS (IVPRO13.DLL) PROGRESS 7.3 and 8.x
-
- SQLBase (IVGUP13.DLL) Centura Software SQLBase 6.x
-
- SQL Server (IVSS613.DLL) SQL Server 6.x from Microsoft
-
- Sybase (IVSYB13.DLL) System 10 and System 11 from Sybase,
- Adaptive Server 11.5 from Sybase,
- Sybase 4.92
-
- Text (IVTXT13.DLL) ASCII text files
-
-
- Driver Options
-
- INTERSOLV has included non-standard options for the drivers that enable
- you to take full advantage of packaged ODBC-enabled applications
- requiring nonstandard or extended behavior.
-
- To use these options, we recommend that you create a separate data
- source for each application. Using the registry editor (regedit on
- Windows 95/Windows NT 4.0 and regedt32 on Windows NT 3.5x), open the
- ODBC.INI section in the registry. In the section for the data source
- you created, add the key WorkArounds (or WorkArounds2) with a value of n
- (for example, WorkArounds=n). The value n is the cumulative value of
- all options added together.
-
- Note that each of these options has potential side effects related to
- its use. An option should only be used to address the specific problem
- for which it was designed. For example, WorkArounds=2 causes the driver
- to report that database qualifiers are not supported, even when they
- are. As a result, applications that use qualifiers may not perform
- properly when this option is enabled.
-
- WorkArounds=1. If an ODBC driver reports that its
- SQL_CURSOR_COMMIT_BEHAVIOR or SQL_CURSOR_ROLLBACK_BEHAVIOR is 0, then
- return 1 instead and force statements to be prepared again by the
- driver.
-
- WorkArounds=2. Some applications cannot handle database qualifiers. If
- this option is on, the driver reports that qualifiers are not supported.
-
- WorkArounds=4. Some applications require two connections to
- a database system. Since some database systems support only one
- connection, the second connection attempt fails. Turning this option on
- causes our drivers to detect this condition and have the two ODBC
- connections share a single physical connection to the database system.
-
- WorkArounds=8. If an ODBC driver cannot deduce the number of rows
- affected by an INSERT, UPDATE, or DELETE, it may return -1 in
- SQLRowCount. Some products cannot handle this. Turning this option on
- causes the driver to return 1 instead.
-
- WorkArounds=16. For SQLStatistics, if an ODBC driver reports
- an INDEX_QUALIFIER that contains a period, some applications raise a
- "tablename is not a valid name" error. Turning this option on causes
- the driver to return no INDEX_QUALIFIER.
-
- WorkArounds=32. Turning this option on enables users of flat-file
- drivers to abort a long-running query by pressing the ESC key.
-
- WorkArounds=64. This option results in a column name of C<position>
- where <position> is the ordinal position in the result set. For
- example, "SELECT col1, col2+col3 FROM table1" produces the column names
- "col1" and C2. SQLColAttributes/SQL_COLUMN_NAME returns <empty string>
- for result columns that are expressions. Use this option for
- applications that cannot handle <empty string> column names.
-
- WorkArounds=256. Forces SQLGetInfo/SQL_ACTIVE_CONNECTIONS to be
- returned as 1.
-
- WorkArounds=513. To prevent ROWID results, this option forces the
- SQLSpecialColumns function to return a unique index as returned from
- SQLStatistics.
-
- WorkArounds=2048. Microsoft Access performs more efficiently when
- the output connection string of SQLDriverConnect returns DATABASE=
- instead of DB= for some data sources. This option forces DATABASE= to be
- returned.
-
- WorkArounds=65536. This option strips trailing zeros from decimal
- results, which prevents Microsoft Access from issuing an error when
- decimal columns containing trailing zeros are included in the unique
- index.
-
- WorkArounds=131072. This option turns all occurrences of the double
- quote character ("") into the grave character (`). Some applications
- always quote identifiers with double quotes. Double quoting causes
- problems for data sources that do not return
- SQLGetInfo/SQL_IDENTIFIER_QUOTE_CHAR = <double quote>.
-
- WorkArounds=524288. The Microsoft Foundation Classes (MFC) bind all
- SQL_DECIMAL parameters with a fixed precision and scale, which causes
- truncation errors. Set this option to force the maximum precision/scale
- settings.
-
- WorkArounds=1048576. Some applications incorrectly specify a precision
- of 0 for character types when the value will be SQL_NULL_DATA. This
- option overrides the specified precision and sets the precision to 256.
-
- WorkArounds=2097152. Some applications incorrectly specify a precision
- of -1 for character types. This option overrides the specified
- precision and sets the precision to 2000.
-
- WorkArounds=4194304. For PowerBuilder users, this option converts all
- catalog function arguments to upper case unless they are quoted.
-
- WorkArounds=536870913. This option allows for re-binding parameters
- after calling SQLExecute for prepared statements.
-
- WorkArounds=1073741824. Microsoft Access assumes that ORDER BY columns
- do not have to be in the SELECT list. This workaround addresses that
- mistaken assumption for data sources such as INFORMIX and OpenIngres.
-
- WorkArounds2=2. Some applications incorrectly specify the
- ColumnSize/DecimalDigits when binding timestamp parameters. This
- workaround causes the driver to ignore the ColumnSize/DecimalDigits
- specified by the application and use the database defaults instead.
-
- WorkArounds2=4. Microsoft Access uses the most recent native type
- mapping, as returned by SQLGetTypeInfo, for a given SQL type. This
- workaround reverses the order in which types are returned, so that
- Access will use the most appropriate native type.
-
- Microsoft Access and Visual Basic Users
- ---------------------------------------
- We recommend that users of Microsoft Access and Visual Basic
- add the value pair WorkArounds=25 (1+8+16) for each data source they
- use with Access and Visual Basic. For data sources that support a
- single connection, add the line WorkArounds=29 (1+4+8+16).
-
-
- Notes and Known Problems
-
- The following are notes, known problems, or restrictions with version
- 3.10 of DataDirect Connect ODBC for Windows NT and Windows 95.
-
- ODBC Driver Manager
- -------------------
- ODBC 3.x drivers require the 3.5 or 3.0 version of the ODBC Driver
- Manager
- (ODBC32.DLL and ODBCCP32.DLL). Because the ODBC 3.x Driver Manager is
- compatible with 2.x compliant drivers, all 2.x versions of the Driver
- Manager should be removed from your access path to ensure application
- stability. Failing to remove older versions of the Driver Manager may
- result in application errors and abnormal terminations.
-
- ODBC Driver Manager Bugs
- ------------------------
- Please review the RELNOTES.WRI file included with the ODBC 3.x SDK
- for all known ODBC Driver Manager bugs. In addition to the bug list
- included in the RELNOTES.WRI file, the following problem exists:
- Calling SQLRowCount after receiving a SQL_NO_DATA return from an
- executed statement results in a HY010 Function Sequence Error. This
- error should not occur.
-
- SQLColAttribute(s)
- ------------------
- The column attributes 1001 and 1002, which were assigned as INTERSOLV
- specific attributes, were inadvertently used as system attributes by
- the Microsoft 3.0 ODBC implementation. Applications using those
- attributes should now use 1901 and 1902 respectively.
-
- SQL_C_NUMERIC
- -------------
- Because of inconsistencies in the ODBC specification, users attempting
- to use SQL_C_NUMERIC parameters should set the precision and scale
- values of the corresponding structure, and the descriptor fields in the
- APD.
-
- For OLE DB Users
- ----------------
- To use the ODBC drivers with OLE DB, you must install Microsoft's
- MSDASQL. The Connect ODBC Product Setup creates a directory
- (\IVODBC\OLEODBC) on your hard drive that contains the MSDASQL
- installer. Run the file MSDAINST.BAT from this directory to install
- version 1.5 of MSDASQL. If you have an earlier version of MSDASQL, you
- must upgrade to this version.
-
- For Btrieve Users
- -----------------
- The Btrieve driver may experience problems if the Btrieve Microkernel
- Engine's communication buffer size is smaller than the Btrieve driver's
- Array Size attribute. You can increase the communication buffer size
- with the BTI Database Setup Utility. You can decrease the array size
- option when you configure a data source using the ODBC Btrieve Setup
- dialog, or when passing a connection string.
-
- For INFORMIX Users
- ------------------
- Restriction: Some INFORMIX error messages may contain more than one
- error. It is unclear whether all errors displayed will be valid.
-
- Attempting to use Microsoft Query '95 with the INFORMIX driver will
- result in a protection fault from Query. This is because Query does not
- recognize the INTERVAL data types supplied by the driver. Users will
- need to obtain Microsoft Query '97 to obtain the fix.
-
- For OpenIngres Users
- --------------------
- The OpenSQL option, which is available on the Advanced window, is not
- supported with MVS/DB2.
-
- To execute properly, the ODBC API SQLProcedureColumns relies on the
- presence of the system view iiproc_params. If this view does not exist,
- your DBA should follow the instructions below to create the view.
-
- 1) Create a file iiproc.sql using the text betweeen the lines below.
-
- ---------------------------------------------------------
- drop view iiproc_params
- \p\g
- create view iiproc_params as
- select procedure_name = p1.dbp_name,
- procedure_owner = p1.dbp_owner,
- param_name = p2.pp_name,
- param_sequence = p2.pp_number,
- param_datatype =
- uppercase(iitypename(ii_ext_type(p2.pp_datatype,p2.pp_length))),
- param_datatype_code = p2.pp_datatype,
- param_length =
- iiuserlen(ii_ext_type(p2.pp_datatype,p2.pp_length),(ii_ext_length(p2.pp_
- datatype, p2.pp_length)*65536) +p2.pp_precision),
- param_scale =int4(mod( p2.pp_precision, (256))),
- param_nulls=charextract('YN', (mod(p2.pp_flags,2))+1),
- param_defaults=charextract('YN',
- (mod((p2.pp_flags/2),(2)))+1),
- param_default_val=squeeze(d.defvalue)
- from iiprocedure p1 , iiprocedure_parameter p2, iidefault d where
- (p2.pp_procid1 = p1.dbp_id and p2.pp_procid2 = p1.dbp_idx)
- and (p2.pp_defid1 = d.defid1 and p2.pp_defid2 = d.defid2)
- \p\g
- ---------------------------------------------------------
-
- 2) Type: sql -U -u"$ingres" <vnode>::<database>
-
- 3) Once connected, type: \i iiproc.sql
-
- Executing OpenIngres stored procedures with literals instead of
- parameters results in a syntax error:
-
- SQLExecDirect:
- In:hstmt = 0x00301250,
- szSqlStr = "{call testproc (12345, 5,5, 'Ed')}", cbSqlStr = -3
- Return: SQL_ERROR = -1
- stmt: szSqlState = "37000", *pfNativeError = 0, *pcbErrorMst = 64
- szErrorMst = "(INTERSOLV)(ODBC INGRES driver) Syntax error or access
- violation."
-
- OpenIngres 2.0 client components are not available for Windows 95 yet;
- therefore, the OpenIngres 2.0 driver (IVOI213.DLL) can only be used on
- Windows NT.
-
- For Oracle 8 under Windows NT users
- ------------------
- The Oracle Net8 client is supported only under Windows NT 4.0.
-
- For PROGRESS Users
- ------------------
- 1) SQLRowCount will always return a value of either 0 or 1.
- If multiple rows are affected by an UPDATE statement, SQLRowCount will
- return 1.
-
- 2) The length, precision, and scale attributes returned for derived
- columns are undefined.
-
- 3) Microsoft Access and Visual Basic users should set WorkArounds=1 as
- defined above in the Driver Options section. Furthermore, to avoid a
- Function Sequence error, do not attempt to update data until all rows
- have been read by Access.
-
- 4) When using scrollable multi-row cursors without the 7.3 or 8.1
- server, deleted rows will not return the SQL_ROW_DELETED status.
- Instead, the deleted row will duplicate the values of the row that
- follows the deleted row in the result set.
-
- For Microsoft SQL Server Users
- -------------------------------
- Attempting to execute DDL statements that contain errors will cause an
- implicit rollback of the current transaction if executing in manual
- commit mode. There is no warning that this has happened. This is a
- Microsoft SQL Server limitation and there is no driver work around.
-
- For SQL Server Users
- --------------------
- Note: When executing multiple statements in a stored procedure, the
- function SQLMoreResults will ignore all statements other than Select
- statements. Since the SQL Server and Sybase drivers do not have a way to
- prepare statements, the driver will not send those statements to the
- server until SQLExecute is called. Prepare will not return any of the
- normal errors that most of the drivers will return. However, if the
- user requests information about result columns, the driver will execute
- a Select statement and return warnings or errors at SQLNumResultCols,
- SQLDescribeCol, or SQLColAttributes time.
-
- Note: If you have problems with the catalog functions returning
- incorrect data, you may need to upgrade your catalog stored procedures.
- Make sure that you have installed the latest version of the stored
- procedures, which are available from your database vendor. Refer to
- your SQL Server documentation for more information.
-
- For Sybase Users
- ----------------
- Sybase 4.9 server is supported only with Sybase Open Client 10.03 or
- greater in the 10.x series or 11.1.1 or greater in the 11.x series.
-
- When using the Sybase driver to access a Sybase SQL Server version
- 4.9.2, you must install the Catalog Stored Procedures (CSPs) on the
- server to insure correct operation of the driver. To install the CSPs
- on your server, run the script file ivcsp492.sql included with the
- installation of the driver through the Sybase ISQL utility. The
- following is an example of the command line to run the script file:
- isql -S<servername> -U<userid> -P<password> -iivcsp492.sql
-
- where: <servername> is the name of your SQL Server, <userid> is a valid
- userid with write permission to the master database, and <password> is a
- valid password for <userid>.
-
- If you encounter any problems running the script file, contact
- Sybase technical support at 1-800-8SYBASE.
-
- You may experience a problem using catalog stored procedures when
- running the the driver with Sybase Adaptive Server 11.5. Contact Sybase
- for information about fixes.
-
- For Text Users
- --------------
- Restriction: When encountering an invalid file, you may receive too
- many or duplicate errors from SQLError.
-
-
- Installing and Using the Online Documents
-
- You can view the online documents with the Adobe Acrobat Reader version
- 3.0. Copies of this reader are provided on the CD for all product
- platforms. These versions are stored under the \READERS directory on
- the CD.
-
- The Online Documents for DataDirect Connect ODBC are located in
- \BOOKS\ODBC\. Opening the BOOKS.PDF file with the Acrobat Reader will
- point you to either the Connect ODBC Reference or the Connect ODBC
- Installation Guide.
-
- For instructions about how to install and use the Online Documents and
- Acrobat Reader, refer to the booklet in the CD-ROM case or the INTERSOLV
- Website.
-
-
- Installed Files
-
- If you install all drivers, Setup copies the following files to the
- product installation directory, by default, \IVODBC:
-
- IVSETUP.INF Uninstall directive file
- PRODLIST.INI Installer file
- QPROFILE.DLL Uninstall utility file
- READ.ME This file
- UNINST.ISU Uninstall initialization file
-
- Setup copies the following files to the \IVODBC\TRANSLAT directory:
-
- LIBMAIN.C
- README.TRN Translation Library information file
- TRANSLAT.C Sample Translation Library source file
- WINNT.MAK Makefile for the Sample Translation Library
-
- Setup copies the following files to the \IVODBC\HEADERS directory:
-
- SQL.H ODBC 3.5 Include files
- ODBCINST.H
- SQLTYPES.H
- SQLEXT.H
- SQLUCODE.H
-
- Setup copies the following files to the \IVODBC\OLEODBC directory:
-
- MSDADLL.EXE
- MSDAHELP.EXE
- MSDAINST.BAT
- MSDAHELP.EXE
- REGSVR32.EXE
-
- Setup copies the following files to your system directory (by default,
- the Windows SYSTEM32 directory for Windows NT or SYSTEM for Windows 95):
-
- CTL3D32.DLL
- IVINFO.EXE License information
- MSVCRT40.DLL Visual C 4.1 Runtime Library
- MSVCRT.DLL Visual C 4.2 Runtime Library
- MTXDM.DLL Microsoft ODBC Connection Pooling Library
- ODBC32.DLL Microsoft 3.5 ODBC Driver Manager
- ODBCAD32.EXE ODBC Administrator
- ODBCCP32.DLL Microsoft ODBC driver Installation DLL for Windows NT
- ODBCCP32.CPL
- ODBCCR32.DLL Microsoft ODBC Cursor Library DLL
- ODBCINT.DLL Microsoft ODBC support DLL
- ODBCTRAC.DLL Microsoft ODBC trace DLL
-
- Setup copies the following files to the driver directory you have
- selected (by default, the Windows SYSTEM32 directory for Windows NT or
- SYSTEM for Windows 95):
-
- IVBAS13.DLL INTERSOLV ODBC driver shared library
- IVBTR13.DLL Btrieve driver
- IVBTR13.HLP
- IVDB213.DLL DB2 driver
- IVDB213.HLP
- IVDBF13.DLL dBASE driver
- IVDBF13.HLP
- IVDRV13.CNT Driver Reference Help Contents file
- IVDRV13.HLP Driver Reference Help file
- IVFLT13.DLL INTERSOLV flat-file ODBC driver shared library
- IVGUP13.DLL SQLBase driver
- IVGUP13.HLP
- IVIDP13.DLL Paradox driver
- IVIDP13.HLP
- IVINF13.DLL INFORMIX driver
- IVINF13.HLP
- IVINF913.DLL INFORMIX9 driver
- IVINF913.HLP
- IVODBC.LIC INTERSOLV ODBC driver license file
- IVOING13.DLL OpenIngres driver
- IVOING13.HLP
- IVOI213.DLL OpenIngres 2.0 driver
- IVOI213.HLP
- IVOR713.DLL Oracle 7 driver
- IVOR713.HLP
- IVOR813.DLL Oracle 8 driver
- IVOR813.HLP
- IVPRO13.DLL PROGRESS driver
- IVPRO13.HLP
- IVSS613.DLL SQL Server driver
- IVSS613.HLP
- IVSYB13.DLL Sybase driver
- IVSYB13.HLP
- IVCSP492.SQL Sybase script that installs the Catalog Stored
- Procedures (CSPs)
- IVTRN13.DLL INTERSOLV sample translation DLL
- IVTXT13.DLL Text driver
- IVTXT13.HLP
- IVUTL13.DLL INTERSOLV ODBC driver utility DLL
- IVXLWB13.DLL Excel Workbook driver
- IVXLWB13.HLP
- ODBC.CNT ODBC 3.5 Programmer's Reference Help Contents File
- ODBC.HLP ODBC 3.5 Programmer's Reference Help File
- ODBCINST.CNT Microsoft ODBC Driver Installation Help Contents File
- ODBCINST.HLP Microsoft ODBC Driver Installation Help
- PROSQL32.DLL PROGRESS Client Library
- QECSV1.BND Bind files for the DB2 driver
- QECSWHV1.BND
- QERRV1.BND
- QERRWHV1.BND
- QEURV1.BND
- QEURWHV1.BND
-
-
- End of READ.ME
-