WX1350: ODBC Desktop Database Drivers 3.5 for 32-Bit Programs

Last reviewed: January 30, 1998
Article ID: Q159674

The information in this article applies to:

Microsoft SQL Server, versions 4.21a, 6.0, and 6.5
Microsoft Access version 7.0 and Microsoft Access 97
Microsoft FoxPro versions 2.0, 2.5, and 2.6
dBASE III, dBASE IV, and dBASE 5 for Windows
Paradox versions 3.x, 4.x, and 5.0
Microsoft Excel, versions 3.x, 4.x, 5.0/7.0, and Microsoft Excel 97
Microsoft Office 97
Microsoft Visual Basic 5.0
Microsoft Visual C++ 5.0
Microsoft Visual Studio 97

This Application Note contains the latest Microsoft Open Database Connectivity (ODBC) drivers for the following data sources:

Microsoft SQL Server versions 4.21a, 6.0 and 6.5

Microsoft Jet database engine version 3.5, which supports the following formats:

    - Microsoft Access versions 2.0, 7.0, and Microsoft Access 97

    - Microsoft FoxPro versions 2.0, 2.5, and 2.6

    - dBASE III, dBASE IV, and dBASE 5 for Windows

    - Paradox versions 3.x, 4.x, and 5.0

    - Microsoft Excel versions 3.x, 4.x, 5.0/7.0, and Microsoft Excel 97

    - Text

The ODBC drivers are 32-bit only, and are designed for use by ODBC- compliant, 32-bit programs running under Microsoft Windows 95 or Microsoft Windows NT 3.51 or 4.0.

Your rights and limitations for redistributing these ODBC drivers are fully documented in the END USER LICENSE agreement below.

You can obtain this Application Note from the following sources:

Microsoft's World Wide Web Site on the Internet
The Internet (Microsoft anonymous ftp server)
The Microsoft Network (MSN)
Microsoft Download Service (MSDL)

For complete information, see the "To Obtain This Application Note" section at the end of this article.

TEXT OF WX1350

  Microsoft(R) Product Support Services Application Note (Text File)

WX1350: MICROSOFT ODBC Desktop Database Drivers 3.5 FOR 32-BIT PROGRAMS

                                                  Revision Date: 11/96

              Note About the Microsoft License Agreement

In using this software product you implicitly agree to the terms of the applicable license agreement, which follows at the end of this Application Note.

Installation

To install the Microsoft ODBC drivers, do the following:

This procedure assumes that you have already downloaded and extracted the compressed file to a folder on drive C named Wx1350.

If you are running Windows 95, click the Start button, and then click Run. (If you are running Windows NT 3.51, click Run from the File menu in either Program Manager or File Manager.)
In the Open box (or in the Command Line box of Windows NT 3.51), type the following command, and then click OK:
```
      c:\wx1350\dataacc
```
Follow the Setup instructions on the screen. Note that the Setup program also runs the ODBC Administrator (Odbcad32.exe), which enables you to set up data sources for the Microsoft ODBC drivers.

Help Files for ODBC Drivers

This Application Note includes the following two driver-specific Help files:

The ODBC SQL Server Help file (Drvssrvr.hlp) contains information about adding, modifying, and connecting to Microsoft SQL Server data sources, connection string attributes, and ODBC conformance levels.
The ODBC Desktop Database Drivers Help file (Odbcjet.hlp) contains information about adding and modifying Microsoft Jet database engine data sources, connecting to and deleting data sources, and levels of ODBC conformance. The Odbcjet.hlp file contains a "Product Support" topic with details about ODBC support offerings from Microsoft. The Odbcjtnw.hlp file is a subset of the Odbcjet.hlp file and describes new features of the ODBC drivers.

END-USER LICENSE AGREEMENT FOR MICROSOFT SOFTWARE IMPORTANT_READ CAREFULLY: This Microsoft End-User License Agreement ("EULA") is a legal agreement between you (either an individual or a single entity) and Microsoft Corporation for the Microsoft software accompanying this EULA, which includes computer software and may include associated media, printed materials, and "online" or electronic documentation ("SOFTWARE PRODUCT" or "SOFTWARE"). By exercising your rights to make and use copies of the SOFTWARE PRODUCT, you agree to be bound by the terms of this EULA. If you do not agree to the terms of this EULA, you may not use the SOFTWARE PRODUCT. Software PRODUCT LICENSE

The SOFTWARE PRODUCT is protected by copyright laws and international copyright treaties, as well as other intellectual property laws and treaties. The SOFTWARE PRODUCT is licensed, not sold.

GRANT OF LICENSE. This EULA grants you the following rights:
```
       Use with Microsoft Excel, Project, Word, FoxPro, Microsoft
```
Access, and/or Office for Windows (individually, "MS Application"). If you license the SOFTWARE for use in conjunction with one or more MS Application(s), the terms and conditions of the end user license agreement you received with such MS Application(s) apply to the SOFTWARE, except that you have the additional right to make and use up to that number of copies of the SOFTWARE equal to the number of copies of such MS Application(s) that you have licensed. Note: you may make only one copy of the SOFTWARE for each unit of Microsoft Office for Windows that you have licensed.
```
       Developing applications using the Visual Basic for
```
Applications ("VBA") component of MS Applications. In addition to the rights set forth in Section 1(a) above, Microsoft grants you the nonexclusive, royalty-free right to reproduce and distribute the object code version of the SOFTWARE, provided you comply with Section 5 herein.
```
       Developing applications using Microsoft Access Developer's
```
Toolkit, Visual C++, Microsoft FoxPro, or Visual Basic (individually, "MS Development Tool").
```
       (i) If you license the SOFTWARE for use in conjunction with an
```
MS Development Tool, you may make and use up to the number of copies of the SOFTWARE equal to the number of copies of MS Development Tools that you have licensed. Each copy of the SOFTWARE must be used on a single computer. The SOFTWARE is "in use" on a computer when it is loaded into temporary memory (i.e., RAM) or installed into permanent memory (e.g., hard disk, CD-ROM, or other storage device) of that computer. However, installation on a network server for the sole purpose of internal distribution to one or more other computer(s) shall not constitute "use" for which a separate license is required, provided you have a separate license for each computer to which the SOFTWARE is distributed. You may make an unlimited number of copies (either in hard copy or electronic form) of any electronic documents included with the SOFTWARE, provided that such copies shall be used for internal purposes and are not republished or distributed beyond the user's premises. In addition, Microsoft grants you the nonexclusive, royalty-free right to reproduce and distribute the object code version of the SOFTWARE provided you comply with Section 5 herein, and subject to Section 1(c)(ii) herein.
```
       (ii) The following additional restrictions apply if you use
```
the SOFTWARE other than solely for internal business purposes. (For applicable licensing terms for all such uses of the SOFTWARE, please contact Microsoft Corporation at (425) 703-4515.) (1) You
may commercially distribute the SOFTWARE only in conjunction with and as part of your software product to which you have added significant and primary functionality and value. (2) Unless your software product requires your customer to license Microsoft Office for Windows, or a component of it, in order to operate, you may not reproduce or use the SOFTWARE for commercial distribution in conjunction with a general purpose word processing, spreadsheet, or database software product, or an integrated work or product suite whose components include a general purpose word processing, spreadsheet, or database management software product except for the exclusive purpose of importing or exporting data to the various formats supported by the SOFTWARE and included in your application (e.g., reading data from and writing data to a single data source at one time). Note: a product which includes limited word processing, spreadsheet, or database components along with other components that provide significant and primary value, such as an accounting product with limited spreadsheet capability, is not considered to be a "general purpose" product.

2.DESCRIPTION OF OTHER RIGHTS AND LIMITATIONS.

  Redistribution Requirements. If you redistribute the SOFTWARE, you
  must: (i) distribute the SOFTWARE in object code only in
  conjunction with and as a part of your software application product
  which adds significant and primary functionality and which is
  designed, developed, and tested to operate in the Microsoft Windows
  or Windows NT environments; (ii) not use Microsoft's name, logo, or
  trademarks to market your software application product;
  (iii) include a valid copyright notice on your software product;
  (iv) agree to indemnify, hold harmless, and defend Microsoft from
  and against any claims or lawsuits, including attorney's fees, that
  arise or result from the use or distribution of your software
  application product; and (v) not permit further distribution of the
  SOFTWARE by your customers.

  Limitations on Reverse Engineering, Decompilation, and Disassembly.
  You may not reverse engineer, decompile, or disassemble the
  SOFTWARE PRODUCT, except and only to the extent that such activity
  is expressly permitted by applicable law notwithstanding this
  limitation.

  Software Transfer. You may permanently transfer all of your rights
  under this EULA, provided the recipient agrees to the terms of this
  EULA.

  Termination. Without prejudice to any other rights, Microsoft may
  terminate this EULA if you fail to comply with the terms and
  conditions of this EULA. In such event, you must destroy all copies
  of the SOFTWARE PRODUCT and all of its component parts.

3.COPYRIGHT. All title and copyrights in and to the SOFTWARE

  PRODUCT (including but not limited to any images, photographs,
  animations, video, audio, music, text, and "applets" incorporated
  into the SOFTWARE PRODUCT), the accompanying printed materials, and
  any copies of the SOFTWARE PRODUCT are owned by Microsoft or its
  suppliers. The SOFTWARE PRODUCT is protected by copyright laws and
  international treaty provisions. Therefore, you must treat the
  SOFTWARE PRODUCT like any other copyrighted material.

4.U.S. GOVERNMENT RESTRICTED RIGHTS. The SOFTWARE PRODUCT and

  documentation are provided with RESTRICTED RIGHTS. Use,
  duplication, or disclosure by the Government is subject to
  restrictions as set forth in subparagraph (c)(1)(ii) of the Rights
  in Technical Data and Computer Software clause at DFARS 252.227-
  7013 or subparagraphs (c)(1) and (2) of the Commercial Computer
  Software_Restricted Rights at 48 CFR 52.227-19, as applicable.
  Manufacturer is Microsoft Corporation/One Microsoft Way/Redmond, WA
  98052-6399.

5.EXPORT RESTRICTIONS. You agree that neither you nor your customers

  intend to or will, directly or indirectly, export or transmit
  (i) the SOFTWARE or related documentation and technical data or
  (ii) your software product as described in sections 5 and 6 of this
  License (or any part thereof), or process, or service that is the
  direct product of the SOFTWARE, to any country to which such export
  or transmission is restricted by any applicable U.S. regulation or
  statute, without the prior written consent, if required, of the
  Bureau of Export Administration of the U.S. Department of Commerce,
  or such other governmental entity as may have jurisdiction over
  such export or transmission.

LIMITED WARRANTY

NO WARRANTIES. Microsoft expressly disclaims any warranty for the SOFTWARE PRODUCT. The SOFTWARE PRODUCT and any related documentation is provided "as is" without warranty of any kind, either express or implied, including, without limitation, the implied warranties or merchantability, fitness for a particular purpose, or noninfringement. The entire risk arising out of use or performance of the SOFTWARE PRODUCT remains with you.

NO LIABILITY FOR CONSEQUENTIAL DAMAGES. In no event shall Microsoft or its suppliers be liable for any damages whatsoever (including, without limitation, damages for loss of business profits, business interruption, loss of business information, or any other pecuniary loss) arising out of the use of or inability to use this Microsoft product, even if Microsoft has been advised of the possibility of such damages. Because some states/jurisdictions do not allow the exclusion or limitation of liability for consequential or incidental damages, the above limitation may not apply to you.

MISCELLANEOUS

If you acquired this product in the United States, this EULA is governed by the laws of the State of Washington. If this product was acquired outside the United States, then local laws may apply. Should you have any questions concerning this EULA, or if you desire to contact Microsoft for any reason, please contact the Microsoft subsidiary serving your country, or write: Microsoft Sales Information Center/One Microsoft Way/Redmond, WA 98052-6399.

Copyright (C) 1996 Microsoft Corporation. All Rights Reserved. FoxPro, Microsoft, MS-DOS, Visual Basic, and Windows are registered trademarks and Visual FoxPro and Windows NT are trademarks of Microsoft Corporation. dBase III, dBase IV, dBase, and Paradox are registered trademarks of Borland International, Inc.

ORACLE and SQL*Net are registered trademarks of Oracle Corporation.

TO OBTAIN THIS APPLICATION NOTE

The following file is available for download from the Microsoft Software Library:

 ~ Wx1350.exe (size: 4471905 bytes)

For more information about downloading files from the Microsoft Software Library, please see the following article in the Microsoft Knowledge Base:

   ARTICLE-ID: Q119591
   TITLE     : How to Obtain Microsoft Support Files from Online Services

Another Application Note containing Microsoft Open Database Connectivity (ODBC) 32-bit drivers is also available (WX1220). The main difference is that WX1220 includes a driver for ORACLE versions 7.0 and 7.1.

For more information about the WX1220 Appnote, please see the following article in the Microsoft Knowledge Base:

   ARTICLE-ID: Q139487
   TITLE     : WX1220: ODBC 32-Bit Drivers Appnote w/Desktop Drivers Ver.
3.4

KBCategory: kbref kbappnote kbfile
KBSubcategory: SSrvGen
Additional reference words: 7.00 driver pack 3.50 odbc kit 97 Softlib
Keywords : SSrvGen kbappnote kbfile kbref
Version : 3.50
Platform : WINDOWS

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: January 30, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.