# Remote historical data access (Ignition 7.5 vs 7.6)

**URL:** <https://forum.inductiveautomation.com/t/remote-historical-data-access-ignition-7-5-vs-7-6/8705>\
**Category:** Ignition\
**Created:** [July 10, 2014, 3:03pm UTC](https://forum.inductiveautomation.com/t/remote-historical-data-access-ignition-7-5-vs-7-6/8705 "2014-07-10T15:03:28Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![koval\_yuriy](https://avatars.discourse-cdn.com/v4/letter/k/9e8a1a/32.png) [@koval\_yuriy](https://forum.inductiveautomation.com/u/koval_yuriy)\
**Post date:** [July 10, 2014, 3:03pm UTC](https://forum.inductiveautomation.com/t/remote-historical-data-access-ignition-7-5-vs-7-6/8705/1 "2014-07-10T15:03:28Z")

</div>

Hello! I have a main machine with Ignition 7.5.12 and several remote servers with Ignition 7.6.6. On the main machine i create the database connections pointed to remote servers. On the remote servers i have a tag history configured to local DB. Each remote server has unique system name. I create the easy chart component on the main server, go to costomize and add some tags from remote machines ([db\_name/system\_name]tag\_path), click “ok” and have an error: “You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘OPTION SQL\_SELECT\_LIMIT=1’ at line 1”. What is wrong? Can somebody help?

---

<div class="post-metadata">

**Author:** ![Colby.Clegg](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/colby.clegg/32/3282_2.png) [@Colby.Clegg](https://forum.inductiveautomation.com/u/Colby.Clegg)\
**Post date:** [July 11, 2014, 4:43pm UTC](https://forum.inductiveautomation.com/t/remote-historical-data-access-ignition-7-5-vs-7-6/8705/2 "2014-07-11T16:43:29Z")

</div>

Hi,

Yes, the problem is that the remote mysql servers are probably 5.6+, and the main machine needs a new version of the MySQL JDBC driver.

Check out [this kb article](https://inductiveautomation.com/support/kb/154) for more info.

Regards,
