non-Ascential ODBC drivers give strange results

MickO · Post by **MickO** » Sun Aug 06, 2006 9:20 pm

When we create jobs using the MS SQL ODBC driver, we get unpredictable results, seeming to often go into infinite loops during staging, producing a never-ending stream of junk records from a 2-row
source table in MS SQL 2000. This wasted us a couple of mandays until we fixed the problem by using the Ascential-supplied ODBC driver instead of the Microsoft-supplied one. Is this normal?

loveojha2 · Post by **loveojha2** » Sun Aug 06, 2006 9:31 pm

Which version of Data Stage?
Was it 7.5.1a?
We also had simliar problem, for which an ODBC related patch was supplied by the Ascential.

MickO · Post by **MickO** » Tue Aug 08, 2006 1:46 am

Yes, 7.5.1a. Can you give us the patch numbers? Also, after the patch, are you using the Ascential drivers rather than the Microsoft or Oracle supplied driver?