Ross wrote:
Hi All,

I am running Teradata queries from MS Access using a
ADODB.Connection.

So you're doing this in VBA code rather than via a passthru query, correct?

The queries run directly unsing Teradata in about
3 Min. I can't keep the ADODB connection from timing out before
three minutes. The error message is:

"[NCR][ODBC Teradata Driver] Query Timeout Expired"

I guess that I don't understand the ODBC reference on a
ADODB.Connection.

There is an ole db provider for ODBC databases ... you must be using an ODBC
dsn ... ehich isn't really relevant.

You can increase the timeout (or set it to 0 so it's unlimited) by using the
Connection's CommandTimeout property (or the Command object's corresponding
property if you are using an explicit Command object).

--
Microsoft MVP - ASP/ASP.NET - 2004-2007
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"