Login Problem ??

• Shital P

  SSC Enthusiast

  Points: 109

  More actions

  December 19, 2005 at 2:00 am

  #66855

  Hi !!!

  I am connecting to SQL SERVER with following code :-

  Set SQLInstance = New SQLDMO.SQLServer

  ' Log in

  SQLInstance.LoginSecure = True

  SQLInstance.Connect "serverName","userid","pwd"

  This code works proprerly if the server is already on,but if server is off I get error

  Can anyone suggest any method to detect whether Server is on or off.

  Thanx

  SP

• David.Poole

  SSC Guru

  Points: 76001

  More actions

  December 19, 2005 at 5:48 am

  #610282

  Wrap up your code in a Try, Catch block

  LinkedIn Profile