Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Mr.Fresh
Starting Member
2 Posts |
 Posted - 2002-11-12 : 07:26:14
|
| Hi, Im pretty new to sql an developing. Our SQL Server is restartet some times because that makes it faster than before. But my Programs will get an connection error in Visual Basic. I use the ADODC object to connect to an SQL server.Does any1 know how to prevent such errors?I've been searching in the Microsoft knowledge base already but they only say: If you get an error than the SQL connection string has got a wrong IP adress.Thnx,Fred |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-11-12 : 07:32:15
|
| If your app tries to connectto the server and it's not there then you will get an error.You can put some code in your database access layer to detect and handle the error though.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
Mr.Fresh
Starting Member
2 Posts |
Posted - 2002-11-12 : 09:06:02
|
| Ok thanks I set the timout to more minutes so my problem is solved :-) |
|
|
|
|
|
|
Wait for SQL server restart in VB