Microsoft KB Archive/814700

= BUG: &quot;Error installing ODBC driver&quot; error message when you use the Vfpodbc.msm merge module in a Visual Studio .NET setup and deployment project =

Article ID: 814700

Article Last Modified on 5/11/2007

-

APPLIES TO


 * Microsoft Visual Studio .NET 2003 Enterprise Architect
 * Microsoft Visual Studio .NET 2003 Enterprise Developer
 * Microsoft Visual Studio .NET 2003 Academic Edition
 * Microsoft Visual Studio .NET 2002 Professional Edition
 * Microsoft Visual Studio .NET 2002 Enterprise Architect
 * Microsoft Visual Studio .NET 2002 Enterprise Developer
 * Microsoft Visual Studio .NET 2002 Academic Edition

-





SYMPTOMS
When you use the Vfpodbc.msm merge module in a Visual Studio .NET Setup and Deployment project, you may receive the following error message:

Error installing ODBC driver: Microsoft FoxPro VFP Driver (*.dbf), ODBC error 13: Could not load the setup or translator library. Verify that the file Microsoft FoxPro VFP Driver exists and that you can access is.

The Vfpodbc.msm merge module is used to install the Microsoft Visual FoxPro ODBC driver.



STATUS
Microsoft has confirmed that this is a bug in the Microsoft products that are listed in the &quot;Applies to&quot; section.



WORKAROUND
To work around this problem, use the Windows Installer Development Tool named Orca to modify the tables in an installer database file.

To make you Visual Studio .NET Setup and Deployment project work as expected while using the Vfpodbc.msm merge module, follow these steps:
 * 1) Start Orca.exe.
 * 2) On the File menu, click Open.
 * 3) In the Open dialog box, type the path of the Windows Installer database file that was generated for your Setup and Deployment project, and then click Open.
 * 4) Under Tables in the left pane, click File. In the FileName column in the right pane, click VFPODBC.DLL|vfpodbc.dll, and then modify the contents to vfpodbc.dll.
 * 5) On the File menu, click Save As. In the Save as type drop-down list box, click Windows Installer Database.
 * 6) Click Save.
 * 7) Run your Setup and Deployment project again.

Note For more information about how to install Orca, see the &quot;References&quot; section of this article.



Steps to reproduce the behavior

 * 1) In Visual Studio .NET, use Visual Basic to create a new Windows Application project.
 * 2) Add a Setup Project to your solution.
 * 3) In Solution Explorer, right-click the project node for the setup project, point to Add, and then click Project Output.
 * 4) In the Add Project Output Group dialog box, click the Windows application project that you created in step 1, and then click OK.
 * 5) In Solution Explorer, right-click the project node for the setup project, point to Add, and then click Merge Module.
 * 6) In the Add Modules dialog box, locate the path of the Vfpodbc.msm merge module, and then click Open.
 * 7) Build the application.
 * 8) In Solution Explorer, right-click the project node for the setup project, and then click Install.
 * 9) In the Setup wizard, click Next until the installation begins.

