Forum Discussion

DKumar04's avatar
DKumar04
Contributor
6 years ago

Unable to connect to my local db

Error thrown when I am trying to restore my local DB using ADO object available in Testcomplete   Here is my full script (Written in Jscript) var con,query,result; con=ADO.CreateADOConnecti...
AlexKaras's avatar
AlexKaras
Champion Level 3
6 years ago

Hi,

 

a) The message does not say that ADO cannot connect to the database. It says that the system is out of resources. It's better to reboot.

b) ADO Query object assumes that a recordset is returned, while your SQL will not return a recordset. Not sure about ADO wrapper in TestComplete, but in 'pure' ADO you should use Command object instead of Recordset in this case.

 

  • TanyaYatskovska's avatar
    TanyaYatskovska
    SmartBear Alumni (Retired)
    6 years ago

    Thanks for sharing your suggestions, Alex.

    DKumar04, did Alex reply help you overcome the error message? If it did, please accept his reply as a solution.