There was a bug in the Data direct ODBC driver that is OEM by infromatica.
You can confirm by turning on an ODBC trace and reproduce the issue.
If the error in the trace shows as sqlsucess status then youre hitting this bug.
What version of the driver are you using?
I forgot to mention, if you're running PC on windows, you can use the SQL server native connectivity in order to avoid this problem.
Share the complete session log. Also as mentioned by Gabriel, enable ODBC trace and check.
Provide the complete session log - that will give us some context.
I dont think that the OP will respond back, so maybe this thread should be closed.
Please be a bit more patient. I have seen more than one case where the OP responded months later; you know, different project tasks, different priorities set by different managers... Let's wait a bit. This thread is just three days old, that's nothing in comparison to some other threads.
you might be right, lets wait, its always good to know the final outcome.
This makes me believe the session is running on Windows OS. However, let's wait for the session log
[Informatica][ODBC SQL Server Wire Protocol driver][Microsoft SQL Server]The statement has been terminated