[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

OBDC timeout

Posted on 2011-10-25
6
Medium Priority
?
242 Views
Last Modified: 2012-05-12
I have a Pass-Through query in an MS Access (2007) database which times out on me.  How do I change the timeout value?  Thanks.
0
Comment
Question by:RishiSingh05
  • 3
  • 2
6 Comments
 
LVL 12

Expert Comment

by:danishani
ID: 37027825
0
 

Author Comment

by:RishiSingh05
ID: 37027874
The screen shots in the link show a Access 2000 file format.  Anyway,  when I am in SQL view I don't see a "View" command in the menu bar at the top.  I am therefore not able to get to Properties.
0
 
LVL 12

Accepted Solution

by:
danishani earned 2000 total points
ID: 37027903
You can go to the Properties of the SQL, click on Property Sheet, there you will see the settings.

See attached screenshot:
 SQL ODBC Time Out
0
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 

Author Comment

by:RishiSingh05
ID: 37027929
ok ,,, I changed the OBDC Timeout vale to 0  ,,, I believe that means no timeout, and I am now running the query ,,,
0
 
LVL 58
ID: 37028785
<<I believe that means no timeout, >>

 Yup!

Jim.
0
 

Author Comment

by:RishiSingh05
ID: 37031104
Thanks ... it worked fine.
0

Featured Post

Fill in the form and get your FREE NFR key NOW!

Veeam is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
Ever visit a website where you spotted a really cool looking Font, yet couldn't figure out which font family it belonged to, or how to get a copy of it for your own use? This article explains the process of doing exactly that, as well as showing how…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question