Forum Discussion

frank_vanderstr's avatar
frank_vanderstr
Contributor
8 years ago
Solved

Cannot Connect to New Database Server using ADO

I have created automation scripts that used an ADO command object to connect to our internal server's databases and make several select, update and insert statements, and that would run great.   We...
  • frank_vanderstr's avatar
    frank_vanderstr
    8 years ago

    The error occurs on the first instance of calling Qry[Execute], so the first loop where I call SELECT.

  • frank_vanderstr's avatar
    frank_vanderstr
    8 years ago

    I was able to figure out the root cause of the issue with some help.

     

    Turns out TestComplete likes to leave out "\" in strings, so putting \\ in my connection string got me connected properly.

tristaanogre's avatar
tristaanogre
Esteemed Contributor
8 years ago
Totally agree with that assessment. But comparing what you have with Microsofts published example, that seems to be the only major difference. Id at least give it a try. But I'll keep researching in the meantime
  • frank_vanderstr's avatar
    frank_vanderstr
    Contributor
    8 years ago

    Afraid using the connection object caused a log in prompt to appear when trying to connect even with the user info in the connection string.

     

    It also caused an error I could not exit from, as a pop up window saying the thread was not synchronized would not close.