Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3433
  • 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)PresidentCommented:

  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)PresidentCommented:
<<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

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone 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