Microsoft KB Archive/234645

= ODE97: Error While Configuring SQL Server Driver During Installation of ODE Application =

Article ID: 234645

Article Last Modified on 9/25/2003

-

APPLIES TO


 * Microsoft Office 97 Developer Edition

-



This article was previously published under Q234645





SYMPTOMS
When you install an application that you built with the Office 97 Developer Edition Setup Wizard that includes ODBC Support for SQL Server, you may receive the following error message:

The Setup routine for the SQL Server ODBC Driver could not be loaded due to system error code(1157).

ODBC's SQL Config Driver Failed for Driver SQL Server.

Setup is not completed successfully.



CAUSE
You ran the Setup wizard on a computer that has the Microsoft Data Access Components version 2.1 (MDAC 2.1) or later and the computer that you tried to install your application onto does not have MDAC 2.1 or later installed.



RESOLUTION
You can use one of the following three methods to work around this problem.

NOTE: After you have used one of the following solutions, you need to re-create your disk images and re-install your application to the target computers. To do this successfully, you need to rename or remove the newer versions of the files listed in step 1 of the "Solution 1" section that were copied to the computer during the previous failed installation before you try to reinstall your application.

Solution 1
Moderate: Requires basic macro, coding, and interoperability skills.

NOTE: A file is available for download from the Microsoft Download Center (Mdtupdtr.exe) that automatically carries out the manual steps listed for this solution. For more information, please see the following article in the Microsoft Knowledge Base:

179567 SetupWizard Template Files Updater Available in Download Center

It is possible to change the version of ODBC Components that is included in your disk images by changing the entries in one of the Setup Wizard tables. You can use this solution if you need the updated ODBC drivers on your development computer, but do not need to redistribute the updated ODBC drivers to the target computers.

WARNING: Because the following solution will modify the default tables in the Setup Wizard, you should back up the following table for reference. If you completed a default installation of the Microsoft Office 97 Developer Edition, move the following file to a different folder.

C:\Program Files\Microsoft Office\ODETools\Setup Wizard\Msaccomp\10ODBC Support With SQL Server.MDT

After you have made backups of this table, follow these steps:  Copy a version of the ODBC files that can be registered properly by the ODE installation program into the C:\Program Files\Microsoft Office\ODE Tools\Setup Wizard\Redist folder on your development computer.

NOTE: Version 3.6x, or earlier, which is on both the Office 97 Professional CD-ROM and the Microsoft Access 97 CD-ROM, will work. Start Microsoft Access. In the Microsoft Access dialog box, select Open An Existing Database, and then select More Files from the list. Click OK. In the Open dialog box, select All Files (*.*) in the Files Of Type box, and move to the following folder:

C:\Program Files\Microsoft Office\ODETools\Setup Wizard\Msaccomp

 Select and open the 10ODBC Support With SQL Server.MDT file. Open the ODBC table and find the lines where the LineID contains the values listed in the following table; then, change Param2 and Param3 to match the list in the table:

</li> Close the database.</li></ol>

The next time that you run the Setup Wizard and select the ODBC Support for SQL Server, it will include the specific files that you placed in the Redist folder instead of the current ODBC support files on the computer.

Solution 2
Novice: Requires knowledge of the user interface on single-user computers.

Use the Setup Wizard to create disk images on a computer that matches the lowest common configuration for all of the anticipated target computers for your application. Some configurations that would suit this purpose:
 * Windows 95 or Windows 98 without the Updated SQL Server ODBC Driver
 * Windows NT 4.0 Workstation or Server without the Updated SQL Server ODBC Drivers

Solution 3
Moderate: Requires basic macro, coding, and interoperability skills.

If you must redistribute the SQL Server 7.0 ODBC driver, use the Setup Wizard to create disk images and do not include ODBC Support for SQL Server with the Office Developer Edition Disk set.

Include ODBC Support as a separate setup program using the Microsoft Data Access Components redistribution set available from the Microsoft Data Access Components Web site

<div class="status_section">

STATUS
Microsoft has confirmed that this is a problem in Microsoft Office 97 Developer Edition.

<div class="moreinformation_section">

MORE INFORMATION
When you include the ODBC Support with SQL Server component in an ODE application install, the Setup wizard includes the current ODBC files from the computer in the disk image that it creates. When MDAC 2.1 or later is installed on a computer, a newer version of the SQL Server driver (SQLSRV32.DLL), version 3.7x or later, is installed. The proper function of this version of SQLSVR32.DLL is dependent on a new file, SQLWOA.DLL, which is not included in disk images made by the Setup Wizard. Without SQLWOA.DLL, the Setup program can not register SQLSRV32.DLL and you receive the error described in the "Symptoms" section of this article.

<div class="references_section">