No updates done on SQL Server using ODBC connector

stiantok · Post by **stiantok** » Tue Sep 09, 2014 9:12 am

I'm running a parallel job with an ODBC connector to update a table in an SQL Server database. The update statement is read from file.

The job always runs fine, and reports back "Number of rows consumed by the user-defined SQL statement: x". But, sometimes it takes longer than usual to run, and when I look at the resulting table in SQL Server, no updates were done, even if the job-log looks fine.

It is a generic job, and I run several (2) instances of it simultaneously.

Any tips on where to start looking/debugging?

ray.wurlod · Post by **ray.wurlod** » Tue Sep 09, 2014 5:14 pm

Welcome aboard.

Perhaps you could start with enabling ODBC tracing, to see what actually gets passed "over the wire".