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
<<inline: image001.gif>>
<<inline: image002.gif>>
