I have a connection to SQL server, it works fine as long as I connect through my firewall first, the problem arises when I/user forgets to do that.
It takes about 45 seconds for my error message box to pop up reminding the user to connect through the firewall first.
I would like to display a progress bar during that 45 seconds.
I can seem to get it to work at the same time, my progress bar will run fine, and then the check for the connection runs...that wont work ends up being 2 minutes or more. I can switch it around and get the connection check to run, then fire the progress
bar. I am attempting to use something like the code below.
Private Sub chkProgressBar()
ProgressBar1.Maximum = 150000
ProgressBar1.Step = 1
Me.Timer1.Enabled = True
While Not finished
ProgressBar1.PerformStep()
ProgressBar1.Refresh()
End While
End Sub
Private Function DBConne ...
Go to the complete details ...