home *** CD-ROM | disk | FTP | other *** search
- __________________________________________________
-
- MICROSOFT ODBC SQL SERVER DRIVER 2.0 RELEASE NOTES
- __________________________________________________
-
- This revision the Microsoft ODBC SQL Server Driver contains the following
- new features:
- 1. 16 and 32-bit support.
- 2. ODBC 2.0 compliant
- 3. Win32s and Windows on Windows (WOW) support
- 4. Support for Windows Sockets netlib shipping with SQL Server 4.21
- 5. Configurable net packet size (connection option)
- 6. Support for setting remote passwords for RPC (connection option)
- 7. Performance enhancements (see below)
-
- For futher information on the above features, see the
- ODBC version 2.0 Programmer's Reference and the SQL Server Help file,
- DRVSSRVR.HLP, which will be installed in the WINDOWS\SYSTEM or
- WINDOWS\SYSTEM32 directory.
-
- _______________________________________
- SUPPORTED SQL SERVER PLATFORMS
-
- The Microsoft ODBC SQL Server Driver 2.0 supports Microsoft SQL Server 4.2
- and later versions. Do not use this driver with Microsoft SQL Server 1.1 or
- 1.1.1 or any Sybase SQL Servers.
-
- _______________________________________
- INSTALLATION
-
- The Microsoft ODBC SQL Server Driver 2.0 supports the following operating
- systems:
-
- o Windows 3.1
- o Windows for Workgroups 3.1
- o Win32s
- o Windows NT
- o Windows on Windows (WOW) subsystem for NT
-
- The following are installation instructions for the different operating
- systems.
-
- ---------------------------------------------------
- Windows 3.1, Windows for Workgroups 3.1, and Win32s
- ---------------------------------------------------
-
- 1. Run a:\SETUP.EXE
-
- 2. The setup will give you instructions to proceed with installation. If
- you need help during the installation, press the "Help" button.
-
- Please be aware that the 16-bit driver will replace the 1.x version. If
- you wish to keep the 1.x version, please make a back-up copy of SQLSRVR.DLL
- and DRVSSRVR.HLP which can be found in your WINDOWS\SYSTEM directory.
-
- ----------
- Windows NT
- ----------
-
- 1. Run a:\32i\SETUP.EXE
-
- 2. The setup will give you instructions to proceed with installation. If
- you need help during the installation, press the "Help" button.
-
- ----------------------------------
- Windows on Windows (WOW) Subsystem
- ----------------------------------
-
- This installation will allow a 16-bit application such as Microsoft Access
- to use the 32-bit SQL Server Driver 2.0. This is supported only from the
- WOW subsystem under Windows NT.
-
- 1. Install the 16-bit driver following the installation procedures above
- for Windows 3.1 and Windows for Workgroups 3.1
-
- 2. Install the 32-bit driver following the installation procedures above
- for Windows NT.
-
- _______________________________________
- INSTCAT.SQL
-
- There are new catalog stored procedures for this driver.
- If you are using a version of Microsoft SQL Server other than
- version 4.21a, these stored procedures must be installed on SQL Server
- before using the driver. For information on how to install the catalog
- stored procedures, see the "Installing the Catalog Stored Procedures"
- topic in the driver help file (DRVSSRVR.HLP).
-
- _______________________________________
- PERFORMANCE ENHANCEMENTS
-
- The Microsoft ODBC SQL Server driver 2.0 provides the option of generating
- stored procudures for prepared statements. When this option is selected,
- the Microsoft SQL Server driver prepares a statement by placing it in a
- procedure and compiling that procedure. This option is avaiable in the
- driver setup dialog box in the ODBC control panel. This option is selected
- by default.
-
- This driver also provides faster connections to data sources. In addition
- to improving the regular connection time, this driver provide a Fast
- Connect option. This option is used to disable the execution of ODBC
- informational queries at connect time. The informational queries are
- deferred until they are needed.
-
- For more information about the "Generate Stored Procedures for Prepared
- Statements" and "Fast Connect" options, see the driver help file
- (DRVSSRVR.HLP).
-
-
-
-
-