Re: Issue with TPT and Postgresql ODBC Driver - Mailing list pgsql-odbc
From | Adrian Klaver |
---|---|
Subject | Re: Issue with TPT and Postgresql ODBC Driver |
Date | |
Msg-id | 560B09B1.9050204@aklaver.com Whole thread Raw |
In response to | Issue with TPT and Postgresql ODBC Driver (Aravindh Varadharaju <avaradharaju@shutterfly.com>) |
Responses |
Re: Issue with TPT and Postgresql ODBC Driver
|
List | pgsql-odbc |
On 09/29/2015 02:53 PM, Aravindh Varadharaju wrote: > Hi Adrian > CCing list. > I am not quite sure about that. But I have iODBC set up on the server. So > I think that we use iODBC manager. Probably worth finding out as your original report had: MSG='[DataDirect][ODBC lib] Unicode converter truncated character’ DataDirect would be from Progress, if I am following correctly. So either the driver you are using is the Progress one or the manager is. > > Aravindh Varadharaju | DevOps Engineer > avaradharaju@shutterfly.com |o. 650.610.5173 | m. 812.369.3537 > > > > > > > > > On 9/29/15, 2:47 PM, "Adrian Klaver" <adrian.klaver@aklaver.com> wrote: > >> On 09/29/2015 02:23 PM, Aravindh Varadharaju wrote: >>> Hi Adrian >>> >>> >>> My TPT script is used to copy a table from Postgres to Teradata. My >>> ODBC.INI was not quite right. So I fixed the ODBC.INI but could not get >>> it >>> work with TPT. >> >> What is your ODBC manager? >> >>> >>> This is my ODBC setup: >>> -- >>> [ODBC Data Sources] >>> OPDB=PostgresSQL Connection to OPDB >>> >>> >>> [OPDB] >>> Driver=/var/odbc/usr/lib64/psqlodbcw.so >>> Description=PostgresSQL Connection to OPDB >>> Database=<Database Name> >>> HostName=<Host Name> >>> LogonID=opdb_read >>> MaxPoolSize=100 >>> MinPoolSize=0 >>> PortNumber=5432 >>> -- >>> >>> >>> >>> >>> Aravindh Varadharaju | DevOps Engineer >>> avaradharaju@shutterfly.com |o. 650.610.5173 | m. 812.369.3537 >>> >>> >>> >>> >>> >>> >>> >>> >>> On 9/29/15, 2:00 PM, "Adrian Klaver" <adrian.klaver@aklaver.com> wrote: >>> >>>> On 09/29/2015 11:23 AM, Aravindh Varadharaju wrote: >>>>> Hi >>>>> >>>>> I am trying to use Postgresql ODBC Unicode Driver to pull data from >>>>> Postgres Database into Teradata through Teradata Parallel Transporter. >>>>> When I run the TPT scripts it is throwing an error as shown below: >>>>> -- >>>>> ODBC_OPERATOR: TPT17101: Fatal error received from ODBC driver: >>>>> STATE=S1000, CODE=0, >>>>> MSG='[DataDirect][ODBC lib] Unicode converter >>>>> truncated >>>>> character¹ >>>> >>>> Looks like you are still using DataDirect. >>>> >>>> Can you supply more information on how your ODBC is setup? >>>> >>>> Also what the TPT script is doing? >>>> >>>>> >>>>> ‹ >>>>> The same script is working with Postgresql driver from Progress. >>>>> >>>>> Can you give me a hint or point me in the right direction to get this >>>>> resolved? >>>>> >>>>> *Aravindh Varadharaju* | DevOps Engineer >>>>> >>>>> _avaradharaju@shutterfly.com_ |o. 650.610.5173 | m. 812.369.3537 >>>>> >>>>> >>>>> >>>> >>>> >>>> -- >>>> Adrian Klaver >>>> adrian.klaver@aklaver.com >>> >> >> >> -- >> Adrian Klaver >> adrian.klaver@aklaver.com > -- Adrian Klaver adrian.klaver@aklaver.com
pgsql-odbc by date: