View Single Post
  #1  
Old December 7th, 2009, 06:31 PM posted to microsoft.public.access.queries
Ross
external usenet poster
 
Posts: 297
Default ADODB.Connection to Teradata Timesout

Hi All,

I am running Teradata queries from MS Access using a ADODB.Connection. 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.

Anyway:

I have other quicker queries that run fine.

How do I keep from timing out?

Thanks

Ross