If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
ADODB.Connection to Teradata Timesout
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" |
Thread Tools | |
Display Modes | |
|
|