May 4, 2012 at 8:28 am
This might not be a database issue but I thought I would start from here....
I have a VB.NET app that connects to the datasbe server Sql server 2008 to run some stored procs. It times out when I run it from Machine A but it runs fine if I am running the VB.EXE apps from machine B or machine C.
Any help would be greatly appreciated.
Thanks
May 4, 2012 at 8:33 am
Are they all located in the same network area? Same subnet, physical location?
May 4, 2012 at 8:34 am
yes.
May 4, 2012 at 9:52 am
I have finally been able to resolve this. It seems like the query is running very slow from machine A compared to machine B & C. I increased the connection timeout from 600 to 1200 in my VB.NET code and it worked. I don't know why the query would run slow from machine A copmared to two other machines . My sys admin told me that machine A is a virual machine. May be that has something to do with it. But as of now my problem is resolved.
Thank you!
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply