# ODBC-JDBC and Foxboro AIM\*Historian ODBC Provider

**URL:** <https://forum.inductiveautomation.com/t/odbc-jdbc-and-foxboro-aim-historian-odbc-provider/2557>\
**Category:** Ignition\
**Created:** [January 26, 2011, 4:13pm UTC](https://forum.inductiveautomation.com/t/odbc-jdbc-and-foxboro-aim-historian-odbc-provider/2557 "2011-01-26T16:13:01Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![gnguyen](https://avatars.discourse-cdn.com/v4/letter/g/41988e/32.png) [@gnguyen](https://forum.inductiveautomation.com/u/gnguyen)\
**Post date:** [January 26, 2011, 4:13pm UTC](https://forum.inductiveautomation.com/t/odbc-jdbc-and-foxboro-aim-historian-odbc-provider/2557/1 "2011-01-26T16:13:01Z")

</div>

Hi,

I have an XP workstation with all the stuff from Foxboro installed (AIM\*Historian V3.3). Tools from Fox are working and I need to connect via jdbc-odbc connector to the historian.

So, I’ve created a system dsn on this machine (wich hold fox tools and Ignition gateway). This dsn is called ‘histfb’.

To verify if the dsn is okay, I tried to pull data from Excel with external data using the dsn ; everything went ok.

I create the database connexion in the gateway with the dsn but no way to have it working.

Can you help me ?

Enclosed : errors messages, dsn configuration (registry extract)

Tia

 ![](https://us1.discourse-cdn.com/inductiveautomation/original/1X/9cc715e7180d73a3d4596ba28e32d8da2dfa54ce.png)  
  
[odbc-conf.txt](https://us1.discourse-cdn.com/inductiveautomation/original/1X/cf532e9b3d73b90a8469f5a241a1f4babe2841ce.txt) (27.1 KB)

---

<div class="post-metadata">

**Author:** ![Carl.Gould](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/carl.gould/32/7262_2.png) [@Carl.Gould](https://forum.inductiveautomation.com/u/Carl.Gould)\
**Post date:** [January 28, 2011, 5:25pm UTC](https://forum.inductiveautomation.com/t/odbc-jdbc-and-foxboro-aim-historian-odbc-provider/2557/2 "2011-01-28T17:25:22Z")

</div>

It looks like that ODBC driver isn’t very compatible with the ODBC-JDBC bridge.

I highly suggest you use a pure-JDBC driver connect instead of the ODBC connection.

---

<div class="post-metadata">

**Author:** ![priscilla.tiedman](https://avatars.discourse-cdn.com/v4/letter/p/7ba0ec/32.png) [@priscilla.tiedman](https://forum.inductiveautomation.com/u/priscilla.tiedman)\
**Post date:** [July 29, 2025, 5:27pm UTC](https://forum.inductiveautomation.com/t/odbc-jdbc-and-foxboro-aim-historian-odbc-provider/2557/3 "2025-07-29T17:27:08Z")

</div>

Hello,

wanted to ask you if you were able to figure out how to connect your Foxboro AIM server to ignition? I am trying to find a way to connect it and retrieve data.

Thank you!

---

<div class="post-metadata">

**Author:** ![gnguyen](https://avatars.discourse-cdn.com/v4/letter/g/41988e/32.png) [@gnguyen](https://forum.inductiveautomation.com/u/gnguyen)\
**Post date:** [July 30, 2025, 4:36pm UTC](https://forum.inductiveautomation.com/t/odbc-jdbc-and-foxboro-aim-historian-odbc-provider/2557/4 "2025-07-30T16:36:35Z")

</div>

Wow, I can't quite remember all the details… sorry about that.

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [July 30, 2025, 5:02pm UTC](https://forum.inductiveautomation.com/t/odbc-jdbc-and-foxboro-aim-historian-odbc-provider/2557/5 "2025-07-30T17:02:02Z")

</div>

_ **Fifteen Years** _ later. Oy!