PRB: Using OLAP to Access a DBC Gives Error Message "Cannot Open File" (266167)


The information in this article applies to:

  • Microsoft SQL Server OLAP Services 7.0
  • Microsoft ODBC Driver for Visual FoxPro (Build 6.00.8281.00) 6.0
This article was previously published under Q266167

SYMPTOMS

The following errors messages may occur when you use Microsoft SQL Server On-Line Analytical Processing (OLAP) Services 7.0 to access a Microsoft Visual FoxPro table (.DBF) by using Open Database Connectivity (ODBC):
[Microsoft][ODBC Visual FoxPro Driver]Cannot open file j:\testdata.dbc.;S1000; Time:3/29/2000 5:29:11 PM

-or-

[Microsoft][ODBC Visual FoxPro Driver]File '<tablename.dbf>' does not exist.;S0002; Time:3/29/2000 5:33:02 PM

RESOLUTION

In most cases, the preceding symptoms can be overcome with the following steps:
  1. Install Active Directory Service Interface (ADSI) from the following Microsoft Web site:http://www.Microsoft.com/NTWorkstation/downloads/Other/ADSI25.asp

  2. On the Start menu, under Settings, select Control Panel, select Services, and then modify the following services to use a valid domain logon: SQL Server Agent, MSSQL Server Service, and MSSQL Server OLAP Service. Use these steps to accomplish this:
    1. Double-click on each of these services to open their properties.
    2. Choose the This Account option in the Log On As section.
    3. Enter a valid domain account and password. This domain account should have access to the FoxPro data on the remote computer.
    Follow the steps in the "Steps to Reproduce Behavior" section of this article and you should receive a message saying Processing Completed Successfully.

MORE INFORMATION

The errors mentioned in the "Symptoms" section occur on Microsoft Windows NT Server 4.0 and Microsoft Windows NT Workstation 4.0 with the data residing on a remote computer. These errors occur with both a mapped drive letter or universal naming convention (UNC) paths to the FoxPro data on the remote computer.

NOTE: The following steps assume that you have Microsoft SQL Server OLAP Services 7.0 installed.

Steps to Reproduce Behavior

  1. Create a System data source name (DSN) called VFPTESTDATA by using the Microsoft Visual FoxPro Driver that is pointing to the Visual FoxPro samples database testdata.dbc on a remote computer.
  2. Open the OLAP Manager.
  3. Right-click on your OLAP server and choose New Database.
  4. Name the database OLAPTest.
  5. Expand the OLAPTest folder, and then expand the Library folder.
  6. Right-click on Data Sources and choose New Data Source.
  7. Click to select Microsoft OLE DB Provider for ODBC Drivers from the list, and then click Next.
  8. Select the Use Data Source Name option, and then click to select the VFPTESTDATA DSN from the drop-down list.
  9. Verify your connection by clicking Test Connection, and then clicking OK to close the Datalink Properties dialog box.
  10. Right-click the Shared Dimensions folder and select New Dimension Wizard.
  11. Select the Single dimension table (flat or star schema), and then click Next.
  12. Click the plus sign (+) next to the VFPTESTDATA node. Select the customer table, and then click Next.
  13. Add custid, company, and contact to the Dimension Levels list, and then click Next.
  14. Name your dimension TestData, and then click Finish.
  15. From the Dimension Editor menu, select File, select Exit, and then click Yes to save changes.
  16. Expand the Shared Dimensions folder.
  17. Right-click on Testdata, and click to select Process.
  18. Choose Rebuild the dimension structure and click OK to process. Note that the preceding error messages appear.
(c) Microsoft Corporation 2000, All Rights Reserved. Contributions by Kenneth Robison, Microsoft Corporation.

REFERENCES

For additional information, click the article numbers below to view the articles in the Microsoft Knowledge Base:

164145 Cannot Open File Accessing Visual FoxPro Database

190463 INFO: What are MDAC, DA SDK, ODBC, OLE DB, ADO, RDS, and ADO/MD?


Modification Type:MajorLast Reviewed:10/29/2003
Keywords:kbDatabase kbprb KB266167
©2003 Microsoft Corporation. All rights reserved.