README
DataDirect Technologies
DataDirect Connect(R) for ADO
Version 2.7, Service Pack 1
December 2005
This README file contains Connect for ADO information not included
in the CONNECT ADO USER'S GUIDE AND REFERENCE or the online help.
IMPORTANT: You must have version 2.6 or higher of the Microsoft Data
Access Components (MDAC) installed to use Connect for ODBC. The version on
the DataDirect CD is 2.7. You can download a utility that determines the
version of your currently installed MDAC from the following Microsoft
site:
http://www.microsoft.com/data/download.htm#26SDKinfo
CONTENTS
Changes Since 2.7 GA (Build 0000)
Version 2.7 Features
Getting a Quick Start with a Connect ADO Default Data Source
Deprecated Platform
Notes, Known Problems, and Restrictions
Contacting DataDirect Technologies Answerline for Technical Support
Online Books
Installed Files
Changes Since 2.7 GA (Build 0000)
See FIXES.TXT for a detailed list of issues that have been addressed
since Release 2.7 (Build 0000).
* All GA data providers have been certified with Windows Server 2003.
* All GA data providers have been certified with Windows XP Service Pack 2.
Version 2.7 Features
Connect ADO for Informix
------------------------
* Supports the Informix 9.30 server
Connect ADO for Oracle8
-----------------------
* Supports Oracle 9i servers
Connect ADO for Sybase
----------------------
* Supports the use of Interfaces file
Connect ADO for XML
-------------------
* Supports hierarchical-formatted XML files
New Platform Support
--------------------
* Windows XP Home Edition and Professional
Getting a Quick Start with a Connect ADO Default Data Source
Setup creates a data source for each data provider that you
install. When you start the DataDirect Technologies Configuration Manager,
the default data sources are displayed under the Data Sources
folder. You can use these data sources to define the connection
instructions to the data store. To modify the data source,
double-click on the data source name; a Setup window is displayed.
Refer to the online help for information on completing the Setup and
testing the connection to your database.
Deprecated Platform
* Windows 95 is no longer supported.
Notes, Known Problems, and Restrictions
The following are notes, known problems, or restrictions
with Connect ADO, version 2.7.
General
-------
* On a Windows NT 4.0, Windows 2000, or Windows XP machine,
you must have administrator privileges to use some features
of the DataDirect Technologies Configuration Manager. Any user
can create, delete, or modify the data sources for the
Connect ADO data providers; however, a user who does not have
administrator privileges cannot change the current directory
for the Connect ADO data sources.
* Conversions from variant types to date/time types should always use
4-digit years. Use of 2-digit years is not supported and will result
in undefined behavior.
* If you created catalog files for a Connect ADO 2.5 provider or
earlier provider using the default catalog, you will need to delete
those catalogs and re-create them. If you created catalogs that
were NOT based on the default catalog, you will need to upgrade the
catalogs after installing this updated release. The catalog can be
upgraded through the DataDirect Configuration Manager. If the
Configuration Manager detects an older version of the catalog,
it will alert you with an error message. You can upgrade the catalog
by right-clicking it in the Configuration Manager and selecting
"Upgrade."
* When connecting to a Connect ADO provider from a few select
applications, you may receive the message "Provider is no longer available.
Ensure that the provider is installed properly." To eliminate this problem,
run regsvr32.exe on the Connect ADO provider. Follow these steps:
1) From a DOS prompt, change to the installation directory for the
Connect ADO data provider. For example, if you installed the providers in
the default location, enter: cd C:\Program Files\DataDirect\Providers
2) At the DOS prompt, register the data provider:
- To register the Informix provider, enter regsvr32 ininf09.dll
- To register the Oracle8 provider, enter regsvr32 inor809.dll
- To register the Oracle7 provider, enter regsvr32 inor709.dll
- To register the Sybase provider, enter regsvr32 insyb09.dll
- To register the XML provider, enter regsvr32 inxml09.dll
Installation
------------
* A Connect ADO provider uses the default permissions for a specified
installation directory (or that directory's parent if the installation
creates the directory). The default privileges may not allow providers
to act as entrusted impersonators, which is required by IIS for this
situation. If this is the case, the providers cannot be accessed or used
by IIS.
Workaround: Change the permissions on the directory.
* If you install Connect ADO 2.7 data providers on a machine on which
the Connect ADO 2.5 data providers are already installed, you cannot
create new data sources for the Connect ADO 2.5 data providers.
* If you created data sources for the Connect OLE DB data
provider version 2.1 or earlier, you must create new data sources.
You cannot modify the older data sources to work with the 2.7 data
providers.
For Connect ADO for Oracle7 Provider Users
------------------------------------------
* The Oracle7 data provider does not support Microsoft DTC.
For Connect ADO for Microsoft SQL Server Provider Users
------------------------------------------
* The Microsoft SQL Server data provider supports Microsoft SQL Server
version 7.0 and 2000. The supported versions listed in the CONNECT ADO
INSTALLATION GUIDE and CONNECT ADO USER'S GUIDE AND REFERENCE
are incorrect.
For Connect ADO for Sybase Provider Users
-----------------------------------------
* The Sybase data provider supports Microsoft DTC only when used with
version 12.x of the Sybase Server.
* In an OLE DB transaction, if the user calls IRowsetChange::SetData
on any row which contains a BLOB type (i.e. Sybase's text type), the
changes made to that row cannot be rolled back via ITransaction::Abort.
This situation does NOT apply to changes made with IRowsetChange::InsertRow
or IRowsetChange::DeleteRows.
For Connect ADO for XML Provider Users
--------------------------------------
* The IE5 datatype namespace in IE5 Data Island style XML must be
given the prefix "dt". Example:
xmlns:dt="urn:schemas-microsoft-com:datatypes"
* The IE5 HTML parser is used to parse HTML files for embedded XML
data islands. If IE5 is not installed, the functionality to access
embedded XML data islands is disabled.
* TABLES and COLUMNS schema rowsets return empty rowsets if the
catalog is specified as an http URL. This is due to security issues
with enumerating files with the http protocol.
* The number of rows in a record set is limited to 16000 records.
* All columns report a default value even if no default value
was specified.
* When adding a column to a table, the default property specified
for the column is not persisted to the XML file.
* Externally linked schema files show up in the TABLES schema rowset
if those schema files are in the catalog directory.
* IE5 Data Island data types bin.base64, uri, and uuid are not yet
supported.
* The provider has been tested only with the default UTF-8 character
encoding.
For Users Updating from an Earlier Version of Connect OLE DB
------------------------------------------------------------
* If you configured a connection with a version earlier than 2.6
of a Connect OLE DB provider for use with a third-party application,
you must update the connection information.
Workaround: Change the provider string from INTERSOLV OLE DB
to DataDirect ADO .
For Users Who Have Installed Connect ADO and SequeLink OLE DB
-------------------------------------------------------------
The Connect ADO data providers and the SequeLink OLE DB
Provider use the DataDirect Technologies Configuration Manager, formerly
called the MERANT DataDirect OLE DB Administrator, to create and
configure data sources. By default, Connect ADO 2.70 and SequeLink
OLE DB Edition 2.0 create data sources in different directories.
To ensure that SequeLink OLE DB Provider data sources are saved
correctly when you install both providers on the same machine, you must
install the SequeLink OLE DB Provider BEFORE you install the Connect
ADO provider. After both are installed, remember that the data sources
will be stored in different directories:
* Connect ADO data sources are in the install directory (by default,
\Program Files\DataDirect)
* SequeLink OLE DB Provider 2.0 data sources are on the system disk
Program Files\Common Files\DataDirect Shared\Admin.
To view the data sources in the Configuration Manager, select
Tools/Options/Main Data Source Directory and navigate to the
appropriate directory.
NOTE: Be sure to click OK; clicking Cancel will not write the correct
current directory information to the system information.
Contacting DataDirect Technologies for Technical Support
Before calling DataDirect Technologies for technical support, please
collect basic information about your system to help us understand the
environment in which you are working and the exact steps to
reproduce the problem. You can find detailed SupportLink
contact information in the online help or on the World Wide Web
at http://datadirect-technologies.com/support/support_index.asp.
Online Books
You can view the Online Documents with the Adobe Acrobat Reader
version 4.0 or higher. For instructions about how to install
and view the Online Books, refer to the CONNECT ADO INSTALLATION
GUIDE.
Note that the Connect ADO installer has new functionality that
allows you to install the online books when you install the product.
If you do not install the books when you install the product,
you can use the Modify option in the installer to install the online
books at a later time.
Installed Files
If you install all of the Connect ADO components, Setup copies
all of the following files to the specified directories. Otherwise,
a subset of these files, corresponding to your installation choices,
is installed.
Setup copies the following files to the product installation
directory (\Program Files\DataDirect by default).
401COMUPD.EXE
MSVCRT40.DLL
ADOREAD.ME Connect ADO README File
INFORMIX for ADO.IDS Default Informix data source
ORACLE7 for ADO.IDS Default Oracle7 data source
ORACLE8 for ADO.IDS Default Oracle8 data source
SYBASE for ADO.IDS Default Sybase data source
XML for ADO.IDS Default XML data source
Setup copies the following files to the provider installation
directory ( \Program Files\DataDirect\Providers by default).
INIAC09.CNT Integrator Help Contents File
INIAC09.DLL Integrator component
INIAC09R.DLL Integrator resource component
INIAC09.HLP Integrator Help File
INIAD09.CNT Integrator Help Contents File
INIAD09.DLL Integrator component
INIAD09R.DLL Integrator resource component
INIAG09.DLL Configuration Manager Modeler file
INIAG09R.DLL Configuration Manager Modeler file
ININF09.CNT Connect ADO for Informix Help Contents File
ININF09.DLL Connect ADO for Informix component
ININF09R.DLL Connect ADO for Informix resource component
ININF09.HLP Connect ADO for Informix Help File
INOR709.CNT Connect ADO for Oracle7 Help Contents File
INOR709.DLL Connect ADO for Oracle7 component
INOR709R.DLL Connect ADO for Oracle7 resource component
INOR709.HLP Connect ADO for Oracle7 Help File
INOR809.DLL Connect ADO for Oracle8 component
INOR809R.DLL Connect ADO for Oracle8 resource component
INOR809.HLP Connect ADO for Oracle8 Help File
INOR809.CNT Connect ADO for Oracle8 Help Contents File
INSYB09.CNT Connect ADO for Sybase Help Contents File
INSYB09.DLL Connect ADO for Sybase component
INSYB09R.DLL Connect ADO for Sybase resource component
INSYB09.HLP Connect ADO for Sybase Help File
INXML09.CNT Connect ADO for XML Help Contents File
INXML09.DLL Connect ADO for XML Component
INXML09R.DLL Connect ADO for XML Resource Library
INXML09.HLP Connect ADO for XML Help File
MSDATL3.DLL
SQLOLEDB.DLL
SQLOLEDB.RLL
XMLREDIST.EXE XML Parser Installer
Setup copies the following files to the Program Files\DataDirect\catalog
directory:
IVCMPLX.DBF
IVCON.CDX
IVCON.DBF
IVCPROP.CDX
IVCPROP.DBF
IVONEROW.DBF
IVPARAM.CDX
IVPARAM.DBF
IVSCHM.CDX
IVSCHM.DBF
IVSCON.CDX
IVSCON.DBF
IVSHARE.CDX
IVSHARE.DBF
IVSPROC.CDX
IVSPROC.DBF
IVSPROP.CDX
IVSPROP.DBF
IVSRVR.DBF
IVSSYN.CDX
IVSSYN.DBF
IVSTAT.CDX
IVSTAT.DBF
IVSTR.CDX
IVSTR.DBF
IVSVIEW.CDX
IVSVIEW.DBF
IVVCOL.CDX
IVVCOL.DBF
Setup copies the following files to the
\Program Files\Common Files\DataDirect Shared\Admin directory:
INADMIN.CNT Configuration Manager Help Contents File
INADMIN.HLP Configuration Manager Help File
INADMIN.EXE DataDirect Technologies Configuration Manager Program
INADMINR.DLL DataDirect Technologies Configuration Manager
INIAD09.CNT Integrator Help Contents File
INIAD09.HLP Integrator Help File
MFC42.DLL
MSVCRT.DLL Visual C 4.2 Runtime Library
Setup copies the following files to the
\Program Files\DataDirect\Drivers directory:
ADOLICENSE.INI Provider license information
IVBAS18.DLL
IVBAS18R.DLL
IVDBF18.DLL DataDirect 4.10 FoxPro Driver
IVDBF18R.DLL DataDirect 4.10 FoxPro Driver Resource File
IVDBF18.CNT DataDirect 4.10 FoxPro Driver Help Contents File
IVDBF18.HLP DataDirect 4.10 FoxPro Driver Help File
IVFLT18.DLL
IVFLT18R.DLL
IVODBC.LIC
IVUTL18.DLL
IVUTL18R.DLL
Setup copies the Connect ADO documentation to the books
directory, by default, C:\PROGRAM FILES\DataDirect\BOOKS\ADO:
BOOKS.PDF Connect ODBC library listing
INDEX.PDX Index file for full-text search
\INDEX Full-text search directories and files
\ADOINTUG\ADOINTUG.PDF Connect ADO Integrator User's Guide and
Reference
\COLEIG\COLEIG.PDF Connect ADO Installation Guide
\COLEREF\COLEREF.PDF Connect ADO User's Guide and Reference
~~~~~~~~~~~~~
End of README