Microsoft KB Archive/266167

= PRB: Using OLAP to Access a DBC Gives Error Message &quot;Cannot Open File&quot; =

Article ID: 266167

Article Last Modified on 10/12/2007

-

APPLIES TO


 * Microsoft SQL Server OLAP Services
 * Microsoft Open Database Connectivity Driver for Visual FoxPro 5.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 '' 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:  Install Active Directory Service Interface (ADSI) from the following Microsoft Web site:http://www.microsoft.com/technet/archive/winntas/downloads/adsi25.mspx

 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:  Double-click on each of these services to open their properties. Choose the This Account option in the Log On As section. 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 &quot;Steps to Reproduce Behavior&quot; section of this article and you should receive a message saying Processing Completed Successfully.</li></ol>

<div class="moreinformation_section">

MORE INFORMATION
The errors mentioned in the &quot;Symptoms&quot; 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.

<div class="references_section">