You will find the answer at the following url http://support.microsoft.com/kb/153756
>>> On 4/5/2013 at 12:00 PM, <[email protected]> wrote: > All, > > Does anyone know if there is a way to adjust the ODBC timeout when > connecting through the BWS DataStation? It appears to be timing out at 30 > seconds. Below is how I have it configured. It works great as long as the > query completes in under 30 seconds. According to the BWS Help document, it > looks like I could set a timeout if I switch over to using ADODB. Before > switching my script over to this, I wanted to first look into an ODBC timeout > setting. > > D.Open_ "C:\BVHSLiveIN", ftODBC > > BVHSLiveIN.bds > [general] > closed=4/5/2013 12:34:13 PM > DSN=BVHSLive > Login=0 > TableQuery=False > SQLQuery=True > SQL=Exec GetAdmLocPatientStats @PatientType = 'IN', @StatusType = 'Summary', > @FromTMinusDays = 9, @ThruTMinusDays = 1 > filetype=11 > filetime=8/15/2012 11:48:45 AM > > Thanks, > Drew Glaser > Data Programmer Analyst > CareTech Solutions / > Blanchard Valley Health System > Office: (419) 429-7614 > [cid:[email protected]]<http://www.caretech.com/> > Helping extraordinary people do extraordinary things > > Best in KLAS > Extensive IT Outsourcing > 2008, 2009 & 2010 > Top 20 Best in KLAS Awards > www.KLASresearch.com<http://www.klasresearch.com/> > > [cid:[email protected]] > > > > > --- To post a message to this list, send mail to: [email protected] You > are > currently subscribed as: [email protected] Unsubscribe in the customer center > on our website: > http://www.bostonworkstation.com/customer_center/virtual_user_group_talk.aspx CONFIDENTIALITY NOTICE: This e-mail message (including attachments) is covered by the Electronic Communications Privacy Act, 18 U.S.C. 2510-2521, and is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any unauthorized review, use, disclosure, dissemination, copying, forwarding or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. If you are the intended recipient but do not wish to receive communication through this medium, please advise the sender immediately. --- To post a message to this list, send mail to: [email protected] You are currently subscribed as: [email protected] Unsubscribe in the customer center on our website: http://www.bostonworkstation.com/customer_center/virtual_user_group_talk.aspx
