Accessing Ingres via ODBC

Question

I am creating a series of SSIS packages to extract data from an Ingres data source.

We have created the ODBC User Source. We have created an SSIS Connection Manager, which tests correctly.

But when we define the ODBC Data Source, we are not able to retrieve anything via the connection - not even table names. Instead, we get the following error message:

Has anyone seen this before, and might be able to give some ideas as to what is going wrong?

Many thanks ...

Answer 1

Hi @Paul Marriott ,

Could you please check if you edit the ODBC source and the ODBC Connection Manager successfully?

Please refer to the following links:

Extract Data by Using the ODBC Source

SSIS Connection Managers: OLE DB vs ODBC vs ADO.NET

Best Regards,
Mona

----------

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hot issues in October--Users always get connection timeout problem when using multi subnet AG via listener. Especially after failover to another subnet.

Answer 2

Monal,

As already stated, the ODBC driver is installed and correctly configured. It tests successfully in SSIS. We can use it within MS Query. We just can't use it within SSIS.

Thanks for your consideration.

Answer 3

Yes ... the ODBC connection can be successfully used in other settings on the same machine by the same user (e.g. MS Query)

The SSIS machine is running Windows 10, so the DTC settings are slightly different, but I think I have them set. I am not sure, though, what they have to do with using an ODBC connection? I have not had to set them before.