RE: Postgresql Drivers

Hi Kevin,

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.

Kind Regards,
Kelly

Kelly Schattle
Business Intelligence Analyst
Hexagon Manufacturing Intelligence
T: +1 401.886.2240
E: [email protected]<mailto:[email protected]>

Hexagon Metrology, Inc.
250 Circuit Drive
North Kingstown, RI 02852


From: Kevin Salisbury <[email protected]>
Sent: Monday, October 1, 2018 12:40 PM
To: SCHATTLE Kelly <[email protected]>; [email protected]
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;

 https://www.postgresql.org/download/products/2-drivers-and-interfaces/

2) As a Hexagon customer, I'm happy to see you here (regardless of whatever project you may be working on because we use many of them). :-)


All the best,

Kevin Salisbury





>>>
From:

SCHATTLE Kelly <[email protected]<mailto:[email protected]>>

To:

"[email protected]<mailto:[email protected]>" <[email protected]<mailto:[email protected]>>

Date:

10/1/2018 12:07 PM

Subject:

Postgresql Drivers

Hello,

I’m checking to see if there is a free OLE DB driver available.  If not, is there a free ODBC driver?


Kind Regards,
Kelly

Kelly Schattle
Business Intelligence Analyst
Hexagon Manufacturing Intelligence
T: +1 401.886.2240
E: [email protected]<mailto:[email protected]>

Hexagon Metrology, Inc.
250 Circuit Drive
North Kingstown, RI 02852