Hi All,

I am trying to do a Try...Catch, like this:

    gocnn     = CREATEOBJECT('adodb.connection')
    lconStr  = "Provider=SQLOLEDB;Data Source=" + lcserver + ";Initial Catalog=" + lcdb + ;
               ";Integrated Security=SSPI;Persist Security Info=False"
    TRY
      gocnn.Open(lconstr)
    CATCH
      lconStr = "Provider=sqloledb; Server=" + lcserver + ;
           ";Database=" + lcdb + ";User Id=" + lcuser + ;
           ";Password=" + lcpwd
      gocnn.Open(lconstr)    <<---------------Error here, I think
    ENDTRY
    gocnn.commandtimeout = 1000

But I am getting an unstructured Error ( not correct wording) on the line indicated. This is my first time trying this error catching method and want to be sure it is not something stupid, yet.

We need to be able to avoid getting an error thrown to the user, prompting them to enter their user name and password if the machine they remote desk topped into does not have a trusted connection with the sql server.

TIA
Beth