# Archived Topics

**URL:** https://forum.inductiveautomation.com/c/archived-topics/9.md?no_subcategories=false

[Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md)

---

## [About the Archived Topics category](https://forum.inductiveautomation.com/t/about-the-archived-topics-category/15)

<div class="topic-metadata">

**Author:** [@system](https://forum.inductiveautomation.com/u/system)\
**Replies:** 0\
**Last updated:** [March 31, 2006, 1:33pm UTC](https://forum.inductiveautomation.com/t/about-the-archived-topics-category/15 "2006-03-31T13:33:18Z")

</div>

Category that houses old posts relating to our legacy software products.

---

## [Favorite Resources](https://forum.inductiveautomation.com/t/favorite-resources/1108)

<div class="topic-metadata">

**Author:** [@Colby.Clegg](https://forum.inductiveautomation.com/u/Colby.Clegg)\
**Replies:** 8\
**Last updated:** [August 3, 2018, 5:51pm UTC](https://forum.inductiveautomation.com/t/favorite-resources/1108 "2018-08-03T17:51:09Z")

</div>

Inductive Automation prides itself on building software centered around open and accessible technologies. Of course, this means that in order to be as effective as possible it is necessary to have a good understanding of…

---

## [HOWTO: Log to CSV with FactorySQL](https://forum.inductiveautomation.com/t/howto-log-to-csv-with-factorysql/701)

<div class="topic-metadata">

**Author:** [@Colby.Clegg](https://forum.inductiveautomation.com/u/Colby.Clegg)\
**Replies:** 0\
**Last updated:** [June 18, 2008, 5:54pm UTC](https://forum.inductiveautomation.com/t/howto-log-to-csv-with-factorysql/701 "2008-06-18T17:54:59Z")

</div>

As of version 4.2.3, FactorySQL can now be used with the CSV ODBC driver that is included with Windows. While we strongly advocate the use of databases instead of CSV when possible, sometimes it is useful or necessary to…

---

## [MySQL Storage Engines](https://forum.inductiveautomation.com/t/mysql-storage-engines/604)

<div class="topic-metadata">

**Author:** [@Travis.Cox](https://forum.inductiveautomation.com/u/Travis.Cox)\
**Replies:** 12\
**Last updated:** [March 26, 2009, 3:24pm UTC](https://forum.inductiveautomation.com/t/mysql-storage-engines/604 "2009-03-26T15:24:59Z")

</div>

MySQL supports several storage engines that act as handlers for different table types. MySQL storage engines include both those that handle transaction-safe tables and those that handle non-transaction-safe tables. The t…

---

## [FactoryPMI New Version Announcements](https://forum.inductiveautomation.com/t/factorypmi-new-version-announcements/433)

<div class="topic-metadata">

**Author:** [@Carl.Gould](https://forum.inductiveautomation.com/u/Carl.Gould)\
**Replies:** 16\
**Last updated:** [August 12, 2009, 8:11pm UTC](https://forum.inductiveautomation.com/t/factorypmi-new-version-announcements/433 "2009-08-12T20:11:17Z")

</div>

Hello everyone, As a convenience, we'll post to this thread when a new version FactoryPMI is released. Click on "Watch this topic for replies" at the bottom of this page to be notified by e-mail when a new version is…

---

## [FactorySQL Performance increase with MySQL 5](https://forum.inductiveautomation.com/t/factorysql-performance-increase-with-mysql-5/156)

<div class="topic-metadata">

**Author:** [@nathan](https://forum.inductiveautomation.com/u/nathan)\
**Replies:** 2\
**Last updated:** [August 7, 2007, 12:54am UTC](https://forum.inductiveautomation.com/t/factorysql-performance-increase-with-mysql-5/156 "2007-08-07T00:54:45Z")

</div>

Colby posted this to the Knowledge base. I've had several users ask about it and it's relevant to many of our FSQL users. here's a link.

---

## [How to Prevent: MS SQL Server bogs down over time](https://forum.inductiveautomation.com/t/how-to-prevent-ms-sql-server-bogs-down-over-time/119)

<div class="topic-metadata">

**Author:** [@admin1](https://forum.inductiveautomation.com/u/admin1)\
**Replies:** 4\
**Last updated:** [January 28, 2015, 9:21pm UTC](https://forum.inductiveautomation.com/t/how-to-prevent-ms-sql-server-bogs-down-over-time/119 "2015-01-28T21:21:38Z")

</div>

MSSQL Server databases used with FactorySQL groups which overwrite the same record repeatedly (for example, bi-directional items) should be placed into the partial backup mode. If this is not done then the transaction …

---

## [Free SQL databases](https://forum.inductiveautomation.com/t/free-sql-databases/47)

<div class="topic-metadata">

**Author:** [@admin1](https://forum.inductiveautomation.com/u/admin1)\
**Replies:** 4\
**Last updated:** [July 25, 2017, 5:05pm UTC](https://forum.inductiveautomation.com/t/free-sql-databases/47 "2017-07-25T17:05:24Z")

</div>

Free versions include: PostgreSQL - always free MySQL - Community Edition falls under the GPL license. Don't sell it to your customer or alter the source code. 10g Express is Oracle's free database. IBM offers DB Express…

---

## [Configuring Windows XP for auto-logon](https://forum.inductiveautomation.com/t/configuring-windows-xp-for-auto-logon/40)

<div class="topic-metadata">

**Author:** [@admin1](https://forum.inductiveautomation.com/u/admin1)\
**Replies:** 1\
**Last updated:** [October 30, 2006, 3:24pm UTC](https://forum.inductiveautomation.com/t/configuring-windows-xp-for-auto-logon/40 "2006-10-30T15:24:40Z")

</div>

You can configure Windows XP for auto logon, which is useful for FPMI touchscreen terminals. This page has good instructions: support.microsoft.com/default.as ... -us;315231

---

## [Where to begin with SQL](https://forum.inductiveautomation.com/t/where-to-begin-with-sql/18)

<div class="topic-metadata">

**Author:** [@admin1](https://forum.inductiveautomation.com/u/admin1)\
**Replies:** 0\
**Last updated:** [March 31, 2006, 1:33pm UTC](https://forum.inductiveautomation.com/t/where-to-begin-with-sql/18 "2006-03-31T13:33:18Z")

</div>

First download a copy of MySQL community edition from our Database Download Page or from the official MySQL website. You will want to download the database engine, Query Browser (a frontend to run your queries in), and M…

---

## [Limiting the values of operator input setpoints](https://forum.inductiveautomation.com/t/limiting-the-values-of-operator-input-setpoints/240)

<div class="topic-metadata">

**Author:** [@calles33](https://forum.inductiveautomation.com/u/calles33)\
**Replies:** 1\
**Last updated:** [March 9, 2007, 7:27pm UTC](https://forum.inductiveautomation.com/t/limiting-the-values-of-operator-input-setpoints/240 "2007-03-09T19:27:40Z")

</div>

I am using an input box to allow users to input setpoints into the system. These setpoints are bound by allowing high and low limits. If the operator enters a value outside of the limits, then I would like to prompt th…

---

## [Connecting to a DESPATCH protocol 3 using Modbus](https://forum.inductiveautomation.com/t/connecting-to-a-despatch-protocol-3-using-modbus/7955)

<div class="topic-metadata">

**Author:** [@drewdin](https://forum.inductiveautomation.com/u/drewdin)\
**Replies:** 12\
**Last updated:** [October 3, 2022, 2:52pm UTC](https://forum.inductiveautomation.com/t/connecting-to-a-despatch-protocol-3-using-modbus/7955 "2022-10-03T14:52:16Z")

</div>

Hi Guys, I'm not sure if anyone has used a Despatch protocol 3, it connects using MODBUS TCP protocol, i have the OPC-UA connection with Ignition but i am having issues trying to read the registers. I'm new at this …

---

## [Specify a printer when printing an Easy Chart](https://forum.inductiveautomation.com/t/specify-a-printer-when-printing-an-easy-chart/3177)

<div class="topic-metadata">

**Author:** [@MickeyBob](https://forum.inductiveautomation.com/u/MickeyBob)\
**Replies:** 6\
**Last updated:** [September 7, 2022, 6:04am UTC](https://forum.inductiveautomation.com/t/specify-a-printer-when-printing-an-easy-chart/3177 "2022-09-07T06:04:31Z")

</div>

Is there a way to specify the printer when printing an Easy Chart without showing the printer selection dialog? I have multiple windows, each having a single Easy Chart, that I want to print as a batch. I only want to …

---

## [Right Click and Double Click actions](https://forum.inductiveautomation.com/t/right-click-and-double-click-actions/193)

<div class="topic-metadata">

**Author:** [@clark](https://forum.inductiveautomation.com/u/clark)\
**Replies:** 1\
**Last updated:** [February 9, 2007, 4:05pm UTC](https://forum.inductiveautomation.com/t/right-click-and-double-click-actions/193 "2007-02-09T16:05:44Z")

</div>

This thread reminded me that I don't understand how actions work with mouse clicks. I remember that it has something to do with the event object. How can I write a script that distinguishes between a left click, right …

---

## [Connection path for CompactLogix 5380](https://forum.inductiveautomation.com/t/connection-path-for-compactlogix-5380/12697)

<div class="topic-metadata">

**Author:** [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\
**Replies:** 9\
**Last updated:** [May 24, 2022, 11:12pm UTC](https://forum.inductiveautomation.com/t/connection-path-for-compactlogix-5380/12697 "2022-05-24T23:12:28Z")

</div>

The new 5380 series can be configured to use a different IP address on each port. What would the connection path then be in the attached example? Also, as another thought comes to me, can the target use the legacy dr…

---

## [Programmatically Setting Selection on chart](https://forum.inductiveautomation.com/t/programmatically-setting-selection-on-chart/990)

<div class="topic-metadata">

**Author:** [@Jonathan](https://forum.inductiveautomation.com/u/Jonathan)\
**Replies:** 7\
**Last updated:** [May 20, 2022, 3:58pm UTC](https://forum.inductiveautomation.com/t/programmatically-setting-selection-on-chart/990 "2022-05-20T15:58:39Z")

</div>

I see there is a method to clear the selection on a chart. Is there a way to set a point as selected? I was thinking something along the lines of: setSelection(x\_point,y\_point)

---

## [Informix data conexion](https://forum.inductiveautomation.com/t/informix-data-conexion/12777)

<div class="topic-metadata">

**Author:** [@arielking](https://forum.inductiveautomation.com/u/arielking)\
**Replies:** 3\
**Last updated:** [March 3, 2022, 10:45pm UTC](https://forum.inductiveautomation.com/t/informix-data-conexion/12777 "2022-03-03T22:45:05Z")

</div>

Help in connecting informix with dirver jdcb, I connect as follows Jdbc: informix-sqli: //192.9.200.102: 9088 / follow: INFORMIXSERVER = cobocecem And I get the error of the image

---

## [IBM Informix jdbc driver](https://forum.inductiveautomation.com/t/ibm-informix-jdbc-driver/11814)

<div class="topic-metadata">

**Author:** [@caritoel27](https://forum.inductiveautomation.com/u/caritoel27)\
**Replies:** 3\
**Last updated:** [January 2, 2022, 2:06am UTC](https://forum.inductiveautomation.com/t/ibm-informix-jdbc-driver/11814 "2022-01-02T02:06:21Z")

</div>

Hi, I write for asking help about installing and connecting to an Informix database, I know Ignition has a DB2 jdbc driver but i couldn’t use it to connect the database informix, and so I thought to download de informi…

---

## [Unix/Linux vs Win for Industrial Automation Software](https://forum.inductiveautomation.com/t/unix-linux-vs-win-for-industrial-automation-software/7150)

<div class="topic-metadata">

**Author:** [@Sencan](https://forum.inductiveautomation.com/u/Sencan)\
**Replies:** 8\
**Last updated:** [October 26, 2021, 1:32pm UTC](https://forum.inductiveautomation.com/t/unix-linux-vs-win-for-industrial-automation-software/7150 "2021-10-26T13:32:41Z")

</div>

We have a discussion in progress at LinkedIn's Industrial Automation and Process Controls Group: Please join if you would like to contribute.

---

## [Allen-Bradley Micro850](https://forum.inductiveautomation.com/t/allen-bradley-micro850/6676)

<div class="topic-metadata">

**Author:** [@pphillips](https://forum.inductiveautomation.com/u/pphillips)\
**Replies:** 11\
**Last updated:** [May 20, 2021, 10:14pm UTC](https://forum.inductiveautomation.com/t/allen-bradley-micro850/6676 "2021-05-20T22:14:19Z")

</div>

Has anyone used an A-B Micro850 PLC or tried to connect to it with Ignition? These are a new tag-based small PLC that supposedly talk both Ethernet IP and/or Modbus TCP. I presume that Ignition would talk to it one w…

---

## [MSAccess file size](https://forum.inductiveautomation.com/t/msaccess-file-size/1425)

<div class="topic-metadata">

**Author:** [@Justin](https://forum.inductiveautomation.com/u/Justin)\
**Replies:** 6\
**Last updated:** [December 3, 2020, 8:42pm UTC](https://forum.inductiveautomation.com/t/msaccess-file-size/1425 "2020-12-03T20:42:54Z")

</div>

Would like to find out what the maximum recommended file size of a MSAccess db file should be when running an SQL query in a table. I am trying to view data from a db file that is around 2 gig and that is apperently too…

---

## [Application Error - Unable to Launch the Application](https://forum.inductiveautomation.com/t/application-error-unable-to-launch-the-application/1427)

<div class="topic-metadata">

**Author:** [@Rockman1\_1](https://forum.inductiveautomation.com/u/Rockman1_1)\
**Replies:** 9\
**Last updated:** [January 11, 2010, 6:25pm UTC](https://forum.inductiveautomation.com/t/application-error-unable-to-launch-the-application/1427 "2010-01-11T18:25:23Z")

</div>

I've been having issues trying to launch any project or the development environment, any FPMI application. I have been able to run in the past on this machine, which happens to be my laptop. It looks like the gateway s…

---

## [Siemens 1500 PLC](https://forum.inductiveautomation.com/t/siemens-1500-plc/6262)

<div class="topic-metadata">

**Author:** [@craigb](https://forum.inductiveautomation.com/u/craigb)\
**Replies:** 11\
**Last updated:** [May 4, 2018, 1:18pm UTC](https://forum.inductiveautomation.com/t/siemens-1500-plc/6262 "2018-05-04T13:18:56Z")

</div>

Folks, I'm having trouble communicating with 1500 PLC. I've set it up in the config as a 1200 and its showing connected but when assigning OPC Tag, the tag fails and shows as a config error. Just to confirm tax ex…

---

## [Prepared Statements](https://forum.inductiveautomation.com/t/prepared-statements/1093)

<div class="topic-metadata">

**Author:** [@TimE](https://forum.inductiveautomation.com/u/TimE)\
**Replies:** 6\
**Last updated:** [August 6, 2020, 1:55am UTC](https://forum.inductiveautomation.com/t/prepared-statements/1093 "2020-08-06T01:55:42Z")

</div>

I have been reading in the manual about prepared statements and still do not quite understand when they should be used. Which of the following queries are better and why? userText = event.source.parent.getComponent("T…

---

## [Java Fonts and Linux](https://forum.inductiveautomation.com/t/java-fonts-and-linux/1112)

<div class="topic-metadata">

**Author:** [@Kyle\_Chase](https://forum.inductiveautomation.com/u/Kyle_Chase)\
**Replies:** 33\
**Last updated:** [July 29, 2020, 5:51am UTC](https://forum.inductiveautomation.com/t/java-fonts-and-linux/1112 "2020-07-29T05:51:56Z")

</div>

In Ubuntu anyways, the Dialog logical font maps to LucidaSans, whereas in Windows, it maps to Arial. The result of this is you text wont always look proper, or in my case, fit in the specified text box. To fix this, you…

---

## [Connection problem with JDBC driver Progress 10.1.C](https://forum.inductiveautomation.com/t/connection-problem-with-jdbc-driver-progress-10-1-c/4027)

<div class="topic-metadata">

**Author:** [@fitzgibbonb](https://forum.inductiveautomation.com/u/fitzgibbonb)\
**Replies:** 3\
**Last updated:** [July 27, 2020, 4:34pm UTC](https://forum.inductiveautomation.com/t/connection-problem-with-jdbc-driver-progress-10-1-c/4027 "2020-07-27T16:34:07Z")

</div>

Hi folks, I have just added a new Progress Database driver (JDBC driver Progress 10.1.C) in Ignition. However I am unable to connect to the progress database when I use this driver. The following error is displayed: \[…

---

## [Modal windows](https://forum.inductiveautomation.com/t/modal-windows/651)

<div class="topic-metadata">

**Author:** [@AlThePal](https://forum.inductiveautomation.com/u/AlThePal)\
**Replies:** 9\
**Last updated:** [May 17, 2019, 7:15am UTC](https://forum.inductiveautomation.com/t/modal-windows/651 "2019-05-17T07:15:14Z")

</div>

Is it possible to make a FactoryPMI window modal? I am using a small window as a popup with further controls on it - for example when a user clicks on a tank, they are given the option to set the temperature up or down. …

---

## [How to change Gateway Timezone?](https://forum.inductiveautomation.com/t/how-to-change-gateway-timezone/2127)

<div class="topic-metadata">

**Author:** [@skallepalli](https://forum.inductiveautomation.com/u/skallepalli)\
**Replies:** 5\
**Last updated:** [May 28, 2020, 3:54am UTC](https://forum.inductiveautomation.com/t/how-to-change-gateway-timezone/2127 "2020-05-28T03:54:08Z")

</div>

Hi, We have some few challenges: When we run SELECT NOW(); statement in MySQL Browser it returned '2010-08-17 17:24:51' as a result. When we used same query in FactoryPMI Text Field the result is '2010-08-18 05:56:…

---

## [Customizing Table Column's Font Color](https://forum.inductiveautomation.com/t/customizing-table-columns-font-color/199)

<div class="topic-metadata">

**Author:** [@Travis.Cox](https://forum.inductiveautomation.com/u/Travis.Cox)\
**Replies:** 1\
**Last updated:** [February 14, 2007, 5:29am UTC](https://forum.inductiveautomation.com/t/customizing-table-columns-font-color/199 "2007-02-14T05:29:51Z")

</div>

FactoryPMI’s Table component is a popular way to efficiently view all sorts of data. The Table component’s columns are easilly configured do display data in a variety of ways, including mapped row background colors, imag…

---

## [Sqlite](https://forum.inductiveautomation.com/t/sqlite/11495)

<div class="topic-metadata">

**Author:** [@wweb](https://forum.inductiveautomation.com/u/wweb)\
**Replies:** 10\
**Last updated:** [May 14, 2020, 7:24pm UTC](https://forum.inductiveautomation.com/t/sqlite/11495 "2020-05-14T19:24:28Z")

</div>

Can an Ignition Project connect to a SQLite database? If so, how?

[Next page](https://forum.inductiveautomation.com/c/archived-topics/9.md?no_subcategories=false&page=1)
