SQL Server Handshake

Question

Hi

I am having a problem with some code and I believe that it cannot connect with the SQL server and this makes my Microsoft Access Databases freeze.

I have a form with an Ontimer event procudure.

What I am after is some sort of code that checks the odbc or SQL connection and then when it confirms there is a connection, it then runs the rest of the code.

Any suggestions?

Regards

Aaron

Answer 1

Thanks Bill.

Do you have any examples of the code for the timeout?

What does your code look like now? Usually you just add the ConnectTimeout. But there are lots of ways to connect. Here is one example Where a user name and password are needed.

Dim cnn As ADODB.Connection

'Prompt for username and password (set prompt first):

cnn.Provider = "sqloledb"

cnn.Properties("Prompt") = adPromptAlways

cnn.ConnectionTimeout = 30

cnn.Open "Data Source=MySever;Initial Catalog=MyDatabase;"

A good source for connection strings is http://www.carlprothman.net/Default.aspx?tabid=81

Answer 2

Thanks Bill.

Do you have any examples of the code for the timeout?

Answer 3

Make sure your connection string includes a timeout and that the timeout is not zero. Otherwise, it will attempt to connect forever. Then put a break in the event and step through it when it breaks.