GN: MDAC Information
Revision Date: 2010-11-29 Both CHARTrunner and SQCpack use Microsoft Data Access Components (MDAC) in order to access database data. Microsoft includes MDAC as part of the operating system in Windows ME and higher. Versions of Windows prior to Windows ME (e.g. 95, 98, and NT) may have a versio ...
- Query to fetch the Last N rows of data from a table or view
Revision Date: 2009-05-28 Problem: I have tables and views in my database that contain a large number of rows of data. My CHARTrunner charts using this data take a long time to render. I only want to chart the most recent rows from the data source. I have tried setting "Result records to includ ...
- CR: Fetching Specification Limits from the Data Source
Revision Date: 2008-05-30 Problem: How can I have CHARTrunner fetch the specification limits for a chart from the data source? Solution: CHARTrunner 2.0 and above has the ability to treat a column from the data source as a specification limit. This is done using the "Treat as" column of the gri ...
- CR: Chart refresh is not refreshing when data is added
Ref # 644 Problem: When I press F5 to refresh my displayed chart, or if the chart refreshes automatically every N seconds, the "refreshed" chart doesn't show any newly added data. Solution: Microsoft Access Data Source If Microsoft Access is being used to add new data to the Access database th ...
- CR: Using a Text File as a Data Source
Problem: When you specify a text file as the CHARTrunner data source, the data from the text file will not be read correctly if the format of the text file is “nonstandard”. In CHARTrunner, the symptom of this condition is incorrect column information shown on the “Data defini ...
- CR: SQL Server Data Source
(Updated: 14-May-2007) This article covers issues involved with using SQL Server as a CHARTrunner data source. On the Data source tab of the CHARTrunner chart definition you can specify the Type as either ADO; OLE DB provider or ODBC; Open database connectivity. PQ recommends that you specify ...
- CR: Using a Password Protected Microsoft Access Database
Problem: Ref #757, Last Revision 02-14-2003. A Microsoft Access database can be password protected using one of the following methods: · Database Password – A password is applied to the entire MDB file. The password must be supplied to open the database. · Workgroup or User-Leve ...
- CR: Lotus Data Source
Following is a brief description for creating a DSN for users to connect to Lotus Notes (*.nsf) databases with CHARTrunner. To create a DSN to connect Lotus Notes (*.nsf) databases with CHARTrunner: 1. You must have one of the following: Designer clients: Lotus Notes (full client) 4.5x, o ...
- CR: Excel Data Source Requirements
CHARTrunner allows you to create charts using data from a variety of sources. However, CHARTrunner thinks about data with a database metaphor. In a database, a table contains many rows (or records) of data. Each row will have the same fields (or columns.) For example, if row 1 contains name, ad ...
- CR: Charting from a Paradox Data Source
Ref # 615 Paradox 3 databases usually require you to use the "Custom query" option. Selecting "Table" with Paradox 3 databases will give you an error. If you have both the Paradox table AND the primary key table, you might be able to use the "table" option. For example, if you have a Paradox 3. ...
- CR: Minitab as a Data Source
Ref # 636 CHARTrunner can chart data that is stored in Minitab files. By default, Minitab stores data in Projects .MPJ and Worksheets .MTW but by using the following steps, you can store data in other formats. To do this: While in Minitab, open the File Menu and select Save Current Worksheet A ...
- CR: Simultaneous Use of CHARTrunner and Excel with a Workbook
Revision Date: 2005-11-07 Problem: Under some circumstances you may experience problems when using Microsoft Excel to open or edit a workbook file at the same time that CHARTrunner is using that same workbook file. The issues discussed here do not apply to CHARTrunner-XL. This issue can be infl ...
- CR: FoxPro and MDAC Information
CHARTrunner is shipping with MDAC 2.5. MDAC stands for Microsoft Data Access Components. This is a set of files required for accessing various data sources. MDAC 2.1 allowed users access to FoxPro 2.0, 2.5, and 2.6 databases by using the Jet database engine. When Microsoft upgraded MDAC, they r ...
- CR: Tips for Using Microsoft Access as a Data Source
Ref #728 In general, the format for data in Microsoft Access is that each row of the table is a set of data points connected to a time event, e.g., taken at 9:00 am, for the month of May, etc. A characteristic with a sample size of five would fill five sequential columns. A second characteristi ...
- CR: Using Custom Parameters in Your Custom Queries
(Updated 02-July-2004) On the "Data definition" tab of the chart description you can choose "Custom query" as the "Source for data records" which allows you to enter the SQL (Structured Query Language) statement that will be passed to the underlying database engine in order to fetch the chart&# ...
- CR: CHARTrunner locks data source
Problem: When I draw a CHARTrunner chart, the data source cannot be accessed. Solution: Download an updated version of CHARTrunner version 1.1.185 or higher from the CHARTrunner Maintenance Release page. Follow the directions on the maintenance release page. Although CHARTrunner opens all data ...
- CR: Missing the First Row of Data from an Excel Data Source
Ref # 635 Problem When linking to Excel, CHARTrunner uses the first row as a header. If the spreadsheet starts with the data, i.e. no header or column title, the first row will not be charted. Solution Insert a title in the first row.
- CR: Charting from a FoxPro Data Source
Ref # 616 To use FoxPro 2.0, 2.5, 2.6, or 3.0 data within CHARTrunner, you must follow these steps: On the Data source tab, set the Type to ADO; OLE DB Provider. In the ADO; OLE DB Provider field, select ODBC Driver for Visual FoxPro—without database container from the ADO combo box. Edit th ...
- CR: Charting from a Paradox password protected database
Problem: With a Paradox 5 table that is password protected, CHARTrunner is unable to chart this using the standard Paradox choice under "Type" on the data source tab. Solution: Setup an ODBC driver for Paradox using Start/Settings/Control Panel/32-bit ODBC drivers. This driver must point to t ...
- CR: Charting from IndustrialSQL Server
Problem: You need to setup a CHARTrunner chart definition to chart data from tags that reside in Wonderware's IndustrialSQL Server. IndustrialSQL Server is a real-time relational database that sits on top of SQL Server. An advantage of using IndustrialSQL Server is that it allows you to stor ...
