Home » Categories » CHARTrunner

CR: Charts not working on a new PC

Revision Date: 2005-09-19

Problem:

Customers have reported that after installing CHARTrunner on a new PC, charts that used to work begin producing errors. One error message contained the following text:

            Check each OLEDB status value

Solution:

Each chart definition contains information about the data source. Where does the data for this chart reside? Often when you get a new PC, the location of various programs and data files can change. If your chart refers to data in a location such as this:

   D:QualityData eadings.xls

Then each time you try to display the chart, CHARTrunner looks for data in this location.

If your data comes from SQL Server or an Oracle database, there is additional client software that must be installed on the PC before CHARTrunner can use the database. When you get a new PC, this client software is often missing. The error message above will be displayed (or one very similar) when this situation occurs with SQL Server.

If CHARTrunner is using an ODBC data source to get to the data,  there is a good chance that your new PC will not have the same ODBC driver or the same ODBC data sources defined. If this is the case, you may need to use the Windows control panel to define an ODBC data source that will allow CHARTrunner to find the data.

Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
CR: Charting pass-fail data as a p-chart
Viewed 4354 times since Fri, Feb 29, 2008
CR: CR1.5 - My control chart data lines are not printing
Viewed 2152 times since Fri, Nov 9, 2007
CR: Grouping counts by date in Excel
Viewed 2115 times since Fri, Nov 9, 2007
CR: Why is my first row of data not included when I get my chart from Excel
Viewed 2076 times since Fri, Nov 9, 2007
CR: A custom query for Length of Stay data
Viewed 2450 times since Fri, Nov 9, 2007
CR: Background on out-of-control test rules
Viewed 2261 times since Fri, Nov 9, 2007
CR: Charts with large amounts of data
Viewed 1870 times since Fri, Nov 9, 2007
CR: Formatting an Excel Date
Viewed 2399 times since Fri, Nov 9, 2007
CR: SQL Server Stored Procedures Returns No Records
Viewed 2234 times since Fri, Nov 9, 2007
CR: CR1.1 - Notes and Causes Problem
Viewed 2049 times since Fri, Nov 9, 2007