public inbox for [email protected]  

help / color / mirror / Atom feed

From: Chun Zhu <[email protected]>
To: [email protected]
Subject: Pgsql-odbc driver issue
Date: Mon, 8 Nov 2021 16:01:45 -0800
Message-ID: <CABHy1N8GxG9nUVECgKvNEJx9gFvMxaFYEVobsw1ZBz4fUqWe-A@mail.gmail.com> (raw)

Hello,
<https://stackoverflow.com/posts/69801013/timeline;

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: image.png]


any inputs will be appreciated!

Thanks,

Kay


Attachments:

  [image/png] image.png (66.6K, 3-image.png)
  download | view image

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected]
  Subject: Re: Pgsql-odbc driver issue
  In-Reply-To: <CABHy1N8GxG9nUVECgKvNEJx9gFvMxaFYEVobsw1ZBz4fUqWe-A@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox