Microsoft KB Archive/164145

= Cannot Open File Accessing Visual FoxPro Database =

Article ID: 164145

Article Last Modified on 6/23/2005

-

APPLIES TO


 * Microsoft Internet Information Server 2.0

-



This article was previously published under Q164145



We strongly recommend that all users upgrade to Microsoft Internet Information Services (IIS) version 6.0 running on Microsoft Windows Server 2003. IIS 6.0 significantly increases Web infrastructure security. For more information about IIS security-related topics, visit the following Microsoft Web site:

http://www.microsoft.com/technet/security/prodtech/IIS.mspx



SYMPTOMS
When you perform an Internet Database Connector (IDC) query from an IIS 2.0 server to a Microsoft Visual FoxPro database on a different server, you may get the following error message on the client browser:

Error Performing Query

[State=S1000][Error=171][Microsoft][ODBC Visual FoxPro Driver]Cannot

open file {filename}.DBF

If the FoxPro database is on the same computer as the IIS server, the query returns data properly.



RESOLUTION
To correct this problem, perform the following steps:


 * 1) In Control Panel, click the ODBC icon.
 * 2) Select the System DSN option; then select the Visual FoxPro DSN used by the IDC file. Click the Setup or the Configure button.
 * 3) Select the Options button, and clear the Fetch Data in Background check box.
 * 4) Select OK. Then select Close to apply these changes.

The query should work correctly.



MORE INFORMATION
In looking at a trace from the problem, a different User ID is used to Open the .DBC file and other files. However, when the .DBF file is accessed a blank or different user name is sent from the IIS server to the Microsoft Windows NT Server where the database is located. However, if Fetch Data in Background is not selected, the same User ID is used to access all files in the database.

Additional query words: uncheck

Keywords: kberrmsg kbprb KB164145

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.