From: | SCHATTLE Kelly <kelly(dot)schattle(at)hexagon(dot)com> |
---|---|
To: | Kevin Salisbury <Kevin(dot)Salisbury(at)twinmro(dot)com>, "pgsql-odbc(at)postgresql(dot)org" <pgsql-odbc(at)postgresql(dot)org> |
Subject: | RE: Postgresql Drivers |
Date: | 2018-10-01 16:48:48 |
Message-ID: | HE1PR0602MB3290F3B89D4D70DB4C1AB8308EEF0@HE1PR0602MB3290.eurprd06.prod.outlook.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
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: Kelly(dot)Schattle(at)hexagon(dot)com<mailto:Kelly(dot)Schattle(at)hexagon(dot)com>
Hexagon Metrology, Inc.
250 Circuit Drive
North Kingstown, RI 02852
From: Kevin Salisbury <Kevin(dot)Salisbury(at)twinmro(dot)com>
Sent: Monday, October 1, 2018 12:40 PM
To: SCHATTLE Kelly <kelly(dot)schattle(at)hexagon(dot)com>; pgsql-odbc(at)postgresql(dot)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;
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 <kelly(dot)schattle(at)hexagon(dot)com<mailto:kelly(dot)schattle(at)hexagon(dot)com>>
To:
"pgsql-odbc(at)postgresql(dot)org<mailto:pgsql-odbc(at)postgresql(dot)org>" <pgsql-odbc(at)postgresql(dot)org<mailto:pgsql-odbc(at)postgresql(dot)org>>
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: Kelly(dot)Schattle(at)hexagon(dot)com<mailto:Kelly(dot)Schattle(at)hexagon(dot)com>
Hexagon Metrology, Inc.
250 Circuit Drive
North Kingstown, RI 02852
From | Date | Subject | |
---|---|---|---|
Next Message | Igor Korot | 2018-10-05 18:53:13 | Re: Building libpq independently of server |
Previous Message | Kevin Salisbury | 2018-10-01 16:40:27 | Re: Postgresql Drivers |