Hey all. I have query we're working with that is part of a larger process. When it runs, it will show the progress bar at the bottom and it slowly progresses. The problem is about three times before it will finish, it will pop up and say something like Connection Lost/Timed Out. If you click okay, it comes up with another pop up that is a log in screen with the SQL information entered. If you hit okay on that, the query will keep running. As I said this will happen about 2-3 times before it finishes.
They have a Access front end and an SQL backend. I have the ODBC Timeout set to 0 in the query properties but apparently that's for connecting, not running. Is there any way to keep this from happening? I don't understand seeing as how I just have to click okay for it to keep running. Is this something in the settings of the SQL server?
Thanks for any help.
They have a Access front end and an SQL backend. I have the ODBC Timeout set to 0 in the query properties but apparently that's for connecting, not running. Is there any way to keep this from happening? I don't understand seeing as how I just have to click okay for it to keep running. Is this something in the settings of the SQL server?
Thanks for any help.
