It’s excellent to know you are a Hexagon customer! I’ve tried the odbc drivers from https://odbc.postgresql.org/ . I am using them to connect to a Jira database employees use to record time on their projects. Unfortunately, these drivers are giving me issues on a few large columns.
[Source [84]] Error: Open Database Connectivity (ODBC) error occurred. state: '01004'. Native Error Code: -2. Fetched item was truncated. What’s happening the drivers are not reading the correct size. It wants to make the column 255 characters in length when it is a max (4000) column.
I know there are Devart drivers; however, it is not free.
From: Kevin Salisbury <Kevin.Salisbury@twinmro.com> Sent: Monday, October 1, 2018 12:40 PM To: SCHATTLE Kelly <kelly.schattle@hexagon.com>; pgsql-odbc@postgresql.org Subject: Re: Postgresql Drivers
Kelly,
Two things;
1) I think psqlODBC (the official ODBC driver documented here; https://odbc.postgresql.org/ ) is where I would start. If you absolutely must have OLE DB, we have used some non-free versions with mixed results -- the software catalog might point you in the right direction for open source options;