August 27, 2012 at 11:55 pm
Hi folks,
this is getting me crazy...
Situation:
We have an old ERP-Software, running on Informix IDS 7.31UD8 on HPUX 11.11.
As ODBC-Driver, we use "IBM INFORMIX ODBC DRIVER" in Version 3.50TC9 (As part of the IBM Informix Client SDK, 32Bit).
Everything Informix-relevant is set up correctly (INFORMIXDIR, ...).
I have no problem, connecting with native C# Code and perform SELECT, DELETE and INSERT-Statements with OdbcConnection.
I tried the same with "IBM.Data.Informix" as .NET-Component. No problem with connection and performing different statements.
But with SSIS, I get an error message in the Source-Component: "[ODBC-Quelle [2]] Fehler: ODBC-Fehler (Open Database Connectivity). state: '08S01'. Native Error Code: -11020. [Informix][Informix ODBC Driver]Communication link failure."
Of course, running the debug-mode with 32Bit, not 64Bit.
Every other tool using ODBC with Informix has no problems (e.g. a Query-Tool, written in C#).
So, why is the SSIS-Package not working?
October 25, 2012 at 8:32 am
Nobody with any hint? :crying:
November 8, 2012 at 2:43 am
Hello again,
we finally found the solution.
It works with Informix SDK 3.50. The only thing we had to do, is to set the Destination Component to "Zeile für Zeile" and not Batch-Mode!
After 3 month of testing, this was the little trick to get it handled 😉
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply