BUG: "Error installing ODBC driver" error message when you use the Vfpodbc.msm merge module in a Visual Studio .NET setup and deployment project (814700)


The information in this article applies to:

  • Microsoft Visual Studio .NET (2003), Enterprise Architect Edition
  • Microsoft Visual Studio .NET (2003), Enterprise Developer Edition
  • Microsoft Visual Studio .NET (2003), Academic Edition
  • Microsoft Visual Studio .NET (2002), Professional Edition
  • Microsoft Visual Studio .NET (2002), Enterprise Architect Edition
  • Microsoft Visual Studio .NET (2002), Enterprise Developer Edition
  • 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 "Applies to" 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 "References" section of this article.

MORE INFORMATION

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.

REFERENCES

For more information, visit the following Microsoft Web sites:

Deployment Projects
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vsintro7/html/vbconwhichtypeofdeploymentproject.asp

Windows Installer
http://msdn.microsoft.com/library/en-us/msi/setup/windows_installer_start_page.asp

Orca.exe
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/msi/setup/orca_exe.asp

To download and install the Windows Installer SDK (including Orca), visit the following Microsoft Web site:

Platform SDK
http://www.microsoft.com/msdownload/platformsdk/sdkupdate/

After you install the Windows Installer SDK, double-click Orca.msi (located in Installation Folder\Microsoft SDK\Bin).

To download the Vfpodbc.msm merge module, visit the following Microsoft Web site:

ODBC Driver
http://msdn.microsoft.com/vfoxpro/downloads/updates/odbc/default.aspx

Modification Type:MajorLast Reviewed:4/4/2006
Keywords:kbvs2005swept kbvs2005doesnotapply kbvs2002sp1sweep kberrmsg kbpending kbBug kbide kbsetup KB814700 kbAudDeveloper
©2004 Microsoft Corporation. All rights reserved.