• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3438
  • Last Modified:

Any way to adjust ODBC timeout in linked table properties?

Any way to adjust ODBC timeout in linked table properties?  I am trying to link a table from Teradata into an Access 97 Database.  However, the table is receiving "ODBC call failed Timeout Error".  Is there anyway to adjust the timeout seconds in the table properties similar to the way you can adjust the timeout seconds in a pass-through query to 32766?
0
SpeedsterZ28
Asked:
SpeedsterZ28
  • 2
  • 2
2 Solutions
 
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:

  No.  ODBC Timeouts only apply to querydefs.

JimD.
0
 
SpeedsterZ28Author Commented:
If the table times out when I try to open it, will it still timeout if I adjust the ODBC timeout in the query?
0
 
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
<<If the table times out when I try to open it, will it still timeout if I adjust the ODBC timeout in the query?>>

  No, it should not.  Simple enough to check though.  Just create a query on the table, then set the queries ODBC timeout value to something like 300 (view/properties).  Then try and execute it.

JimD.
0
 
SpeedsterZ28Author Commented:
Thank you for answering the original question and my follow ups.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now