README.OLEDB.TXT Sybase ASE OLE DB Provider, TDS Version Microsoft Windows 9x and Microsoft Windows NT 4.0 Version 2.50 (12.0.0/CNTL-TDS/02.50.0022) September 2000 ******************************** NOTE **************************************** Do not use the product in a production environment until you have signed the license agreement between your company and Sybase. This license agreement is forthcoming... ******************************************************************************
DOWNLOAD Instructions: --------------------------------------------------------- ftp ftp.sybase.com login as user "anonymous" use your email address as the password (name@company.com) cd /pub/incoming/wcss/asetds use binary mode get asetds.zip --------------------------------------------------------- CONTENTS Sybase ASE OLE DB Provider, TDS Version Installation Instructions Notes and Known Problems Contacting Sybase Technical Support Installed Files Sybase ASE OLE DB Provider, TDS Version
The Sybase ASE OLE DB Provider connects an ADO-based application to Sybase ASE 11.X, 12.X. The Sybase ASE OLE DB Provider is supported on current and recent 32-bit Windows operating systems Windows 9x, Windows NT 4.0 and Windows 2000. It is compliant with the Microsoft OLE DB 2.5 specification and the ODBC 3.51 specification IMPORTANT NOTE: This is a special "Controlled" release of the Sybase ASE OLE DB Provider. This OLE DB Provider does not require, nor use, the Sybase Open Client Client-Library API. The OLE DB Provider interfaces the OLE DB (ADO) API calls directly to the TDS wire protocol API. The name of this release may change when this product is released as part of SDK 12.5 GA. Windows 2000 Users **** IMPORTANT!!!!!!!! **** If you are using Windows 2000 DO NOT INSTALL MDAC 2.1 or 2.5 since Windows 2000 already includes MDAC 2.6. This product is certified for use on Windows 2000. Installation Instructions
Please read the file "installoledb.txt" for installation instructions. Notes and Known Problems The following are notes, known problems, or restrictions with Sybase ASE OLEDB Provider, 2.50. 1. On a Windows NT 4.0 machine, administrator privileges are required to use all features of the Sybase Configuration Manager: * With the Sybase ASE OLE DB Provider, any user can create, delete, or modify the data sources; however, a user who does not have administrator privileges cannot change the current directory for the Sybase ASE OLE DB Provider data sources. 2. To trace an OLE DB application, you must download the latest version of the OLE DB Software Development Kit (SDK) from the Microsoft web site (http://www.microsoft.com/data/oledb/). The Provider does provide some tracing of OLE DB calls. 3. When you install a Sybase ASE OLE DB Provider to a specified directory, it uses the default permissions for that directory (or that directory's parent if the installation creates the directory) for the files that get installed. The default privileges do not allow providers to act as entrusted impersonators, which is required by IIS for this situation. Therefore, the providers cannot be accessed or used by IIS. Workaround: Change the permissions on the directory. 4. 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. 5. The default value of the OLE DB Services property has changed. * For the Sybase ASE OLE DB Providers, the value is -3. These data providers enable all OLE DB Services except DBPROPVAL_OS_TXNENLISTMENT. 6. If you created data sources for the Sybase ASE OLE燚B Provider version 2.1 or earlier, you must create new data sources. You cannot modify the older data sources to work with the 2.5 data providers. Sybase ASE OLE DB Provider
The following notes apply if you are installing the Sybase ASE OLE DB Provider. *** NOTE **** 1. The Sybase data provider does not support Microsoft DTC. 2. 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:eleteRows. The following notes apply if you are installing the release on a machine that has an earlier version of a Sybase ASE OLE DB Provider installed. 1. If you configured a connection with a previous version of the Sybase ASE OLE DB Provider for use with a third-party application, you can use the same connection string. However you must recreate the Data Source. This is due to the additional connection parameters that are required when used with the TDS API. Contacting Sybase Technical Support ----------------------- Please report problems to Sybase Technical Support (1-800-8SYBASE or 1-800-879-2273) or via your conventional method (ie. web) *** NOTE *** : When logging cases against this product, open cases under the currently licensed Sybase ASE OLE DB Provider (12.0 Version). Then in the case notes description, mention that the problem reported is in this 'Special release TDS OLE DB Provider'. Installed Files These files are located in %SYBASE%\OLEDB-2_5: SYDAASE.CNT Sybase ASE OLE DB Provider Help Contents File SYDAASE.DLL Sybase ASE OLE DB Provider component SYDAASER.DLL Sybase ASE OLE DB Provider resource component SYDAASE.HLP Sybase ASE OLE DB Provider Help File REGSVR32.EXE *** Windows 2000 Users *** **** IMPORTANT!!!!!!!! **** If you are using Windows 2000 DO NOT INSTALL MDAC 2.1 or 2.5 since Windows 2000 already includes MDAC 2.6. This product is certified for use on Windows 2000. Setup copies the following files to the %SYBASE%\OLEDB-2_5 directory:
SYADMIN.CNT Configuration Manager Help Contents File SYADMIN.HLP Configuration Manager Help File SYADMIN.EXE Syabse Configuration Manager Program SYADMINR.DLL Sybase Configuration Manager For information on the files that are installed when the MDAC 2.1/2.5 runtime components are installed, please see the following Microsoft web site: http://msdn.microsoft.com/library/techart/msdn_redistmdac.htm End of readme.OLEDB.txt
|