Archives of the TeradataForum

Message Posted: Mon, 07 Jun 2004 @ 19:39:29 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

We've got a VB application that has been up and running for 3 years now without serious problems using ADO (version 2.6) to connect to teradata to run large SQL statements (both in length, and return set size). Recently we upgraded our teradata ODBC driver, and things started going haywire. It looks like an error is occurring when we try to open a recordset (by issuing the command: rptSet.open sqlStatement), but it only occurs with specific queries... The error is repeatable, uncatchable, brings down the app, and the erring queries don't appear to have anything in common. After searching through many postings on your site, it has come to my attention that maybe I should be using the native driver rather than ODBC (TDOLEDB.DLL rather than tdata32.dll)? I'm not sure of the differences, or how to go about getting/using this driver. Is there any hope for me?

	<Prev	Next>		<<First	<Prev	Next>	Last>>