Products | Versions |
---|---|
Spotfire Statistica | 12.6 and higher |
When running a job in WebStatistica that is dependent on a Statistica spreadsheet as the data source, you get a script error: "Cannot connect to OLE DB Provider. Not a valida data source." and the provider points to a Statsoft OLEDB Provider as shown below:
Possible cause:
The permission to the directory you are trying to access the data source is denied for the WebStatistica default System User. When running a task via Webstatistica, it runs with Webstatistica server's "System User" Permissions. So if the task is reading or writing a file, then WebStatistica service must run with the identity of a windows domain user who has the necessary folder and file permission.
Solution 1: To create a direct data source stored in the Enterprise Server (This is preferred, when possible)
1. Upload the data (e.g. Astudy.sta) to the Enterprise Manager by clicking "Add to Enterprise" under "Enterprise" tab
2. Create a new database connection and select "Statsoft OLE DB Provider for STATISTICA Spreadsheets"
3. Enter the data source path for the Enterprise folder and click "Test Connection". If failed, check whether the path is correct.
4. Click "OK"
5. After the database connection is saved, point the data configuration to the built database connection that depends on Enterprise spreadsheet data source .
6. Verify the analysis configuration is dependent on the data configuration.
7. Run the analysis configuration in WebStatistica.
Solution 2:
1. Run WebStatistica Service as a Windows domain user that has permission to the data source directory through these steps
Note: You can impersonate the WebStatistica System User and the login user by changing the configuration of WebStatistica as follows:
Go to "All programs | Statistica | WebStatistica | Administration" and change "ImpersonateUser" value to be "True"