Microsoft KB Archive/150328

= INF: Files Needed for ODBC Driver(s) Redistribution =

ID: Q150328

The information in this article applies to:


 * Microsoft Open Database Connectivity version 2.x

SUMMARY
This article describes the DLLs and other files that you need to redistribute before you can use a specific Microsoft Desktop Database ODBC Driver with respect to Jet 3.0.

IMPORTANT: The drivers in Odbcddp3 are now obsolete. Version 3.5 of the ODBC desktop drivers are in the Data Access Pack included with the Value Pack that is shipped with Microsoft Office 97. For additional information, about the Data Access Pack (Wx1350.exe), please see the following article in the Microsoft Knowledge Base:

ARTICLE-ID: Q159674 TITLE    : WX1350: ODBC Desktop Database Drivers 3.5 for 32-Bit Programs

Application Note
The ODBC Desktop Database Driver Pack (DDP) v3.0 is available as an application note from Microsoft Technical Support. This pack has the Microsoft SQL Server and Visigenic Oracle drivers (client/server databases) apart from the Microsoft Access, FoxPro, dBase, Paradox, Microsoft Excel, and Text (desktop databases) drivers. If you have the application note and would like to redistribute one or more drivers, refer to the ODBC.INF file for information on the DLLs required.

(Note that as of 12/9/98, Visigenic has been acquired by INPRISE, Inc.)

The ODBC DDP 3.0 uses the ACME setup program and accordingly the format of ODBC.INF has been changed from ODBC version 2.0. Most the sections in this file have a 'DA' prefix. In the following, this prefix has been omitted for brevity. Unless otherwise noted, the files are common to both Windows NT and Windows 95.

ODBC core components include the driver manager, cursor library, installer, and thunking (optional) files. These files should be installed regardless of the driver you would like to redistribute. The files are listed under the following sections:


 * ODBC Driver Manager
 * ODBC
 * ODBC Administrator
 * Generic Thunk ODBC Driver Manager
 * Generic Thunk DLL

You also need the files under the following sections:


 * Shared MSVC Components
 * CTL3D-NT (only on Windows NT)

The following sections include common files for the Microsoft Access, FoxPro, dBase, Paradox, Excel, and Text drivers:


 * Desktop Driver Components
 * Shared VBA Components
 * Desktop Help Files

To install a specific desktop database driver, you need the files under the [Driver Name] and [Driver Name-IISAM] sections. The [Driver Name] section has the setup DLL(s), if there is a separate setup DLL for the driver, and the [Driver Name-IISAM] has the driver ISAM files. For example, to know about the files for the Microsoft Excel driver, you should look under the following sections:


 * Excel
 * Excel-IISAM

For the Microsoft SQL Server driver, look under the following sections:


 * SQLServer
 * MS CP Translators
 * SQLServer Help Files

For the Visigenic Oracle Driver, look under the following sections:


 * Oracle
 * Oracle Help Files
 * CTL3D-W95-VSORA (Only on Windows 95)

In this application note, there is a ODBCKEY.INF file that contains information about the keywords for each driver. This information will be written to HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI in the registry. You should modify the ODBCKEY.INF file by removing the driver sections for the drivers that you do not want to install. For example, remove the 'TEXT' section, if you do not want to install the Text driver.

Visual C++ 4.1 Compact Disc:
The redistributable ODBC components and drivers are available under the Msdev\Redist directory. The ODBC.INF in this directory is similar to the one in the appnote mentioned above. Follow the same steps listed under the appnote section to redistribute the drivers.

Notes:
You can use the setup program (SETUP.EXE) in the appnote to redistribute the drivers. Note that SETUP.EXE uses ACMESETUP.EXE. Your installation disks should have these two EXEs, the modified ODBC.INF, and ODBCKEY.INF files (that include only the drivers that you want to redistribute), and all the files listed in the modified ODBC.INF. Make sure that the following sections of ODBC.INF are not removed:


 * Source Media Descriptions
 * Default File Settings
 * Win95QFE (Only on Windows 95)

You can also write your own installation program using either the ODBC Installer API or a third party installation software. Use the information provided in the above section(s) for the list of files needed by a driver. For information on using the ODBC 2.5 installer API and installation changes, refer to README25.TXT in the appnote.

If you would like to use the ODBC 2.0 Installer API, for information on using the ODBC Installer DLL, and other important information about installing ODBC files, see Chapter 19, "Installing ODBC Software" under Part 4, Installing and Configuring ODBC Software in the Microsoft ODBC 2.0 "Programmer's Reference and SDK Guide."

If you want an ODBC 2.0 formatted INF file, refer to the VCODBC.INF file under the Msdev\Redist directory of the VC++ 4.1 compact disc.

For information about how to contact INPRISE, Inc., query in the Knowledge Base for one of the following articles:

ARTICLE-ID: Q65416 TITLE    : Hardware and Software Third-Party Vendor Contact List, A-K

ARTICLE-ID: Q60781 TITLE    : Hardware and Software Third-Party Vendor Contact List, L-P

ARTICLE-ID: Q60782 TITLE    : Hardware and Software Third-Party Vendor Contact List, Q-Z Additional query words: 2.00 3.00 mfc rdo odbc driver pack visual c++ Vc Visigenic

Keywords         : ODBC Version          : Windows:2.0, 2.1, 2.5 Platform         : WINDOWS Last Reviewed: December 30, 1998