Pgsql-odbc driver issue - Mailing list pgsql-odbc

From Chun Zhu
Subject Pgsql-odbc driver issue
Date
Msg-id CABHy1N8GxG9nUVECgKvNEJx9gFvMxaFYEVobsw1ZBz4fUqWe-A@mail.gmail.com
Whole thread Raw
List pgsql-odbc
Hello, 

When building SSIS package, I usually write SQL queries for the ODBC Source connecting to a postgres SQL database. Everything works find until today I found when I hit the database access mode as 'SQL Command', there is no command box for me to type. And if I hit the access mode as 'table name' there is no 'preview' button for me to preview the dataset. I have been stuck at this for long time, trying to find why, but was unable to. So I am reaching out to see if you have any insights into this issue? Will this something related to the ODBC driver? fyi, I updated both the pgsql odbc driver and SSIS to their latest versions. image.png


any inputs will be appreciated!

Thanks, 

Kay 

Attachment

pgsql-odbc by date:

Previous
From: Färber, Franz-Josef (StMUK)
Date:
Subject: send current username with gssapi
Next
From: Jon Raiford
Date:
Subject: Re: Bug report: odbc driver does not convert wide chars to chars