Forum Discussion

twe69's avatar
twe69
Occasional Contributor
6 years ago

TestComplete and SQL databases - Restoring per test

Hi there,   Just looking at ways of implementing a way to restore a test SQL database back to it's original condition once a load of TestComplete tests run against it. I have found this link bu...
  • twe69's avatar
    twe69
    6 years ago

    Unfortunately it didn't however I was able to get some help from a developer within our company and have got the following working:

     

    function TestProc()
{
var Qry;
var con;
// Create a query
Qry = ADO.CreateADOQuery();
con = ADO.CreateADOConnection();
con.ConnectionString = "Provider=MSOLEDBSQL.1;User ID=XX;Password=XX;Initial Catalog=XXXXDB;Data Server=computer\\sqlserverinstance,1433;"
con.CommandTimeout = 1000
con.LoginPrompt = false;
    con.Open()
Qry.ConnectionString = con.ConnectionString;
Qry.SQL = "SELECT * FROM Users";
queryResult = Qry.FieldCount;
// Closes the query
con.Close();
}
     

     

twe69's avatar
twe69
Occasional Contributor

LinoTadros  Sorry I am a little confused on how to create/run this method.

 

From the tutorials I should be making a 'Script' with the ADO Object that points to the sql file? is that correct? I think I am seeing to many options and variations that are confusing me. Would you have a very basic sample handy? Thanks!

twe69's avatar
twe69
Occasional Contributor
6 years ago

Can someone point me in the right direction with this script please, am not able to connect to the SQL Server.

 

function TestADO()
{
var Conn = Sys["OleObject"]("ADODB.Connection");
Conn["ConnectionString"] = "Provider=SQLOLEDB;SERVER=\\UXXXXXXX\MSSQLSERVER2017;Database=DBXXXXX;User Id=UserXXXX;Password=PassXXXXX;"
Conn["Open"]();

ADO.CreateADOQuery("Select * FROM Users")
// Close the recordset and connection
Conn["Close"]();
}

  • tristaanogre's avatar
    tristaanogre
    Esteemed Contributor
    6 years ago

    If you're using JavaScript, you need to double-up on all you \ characters.

    • twe69's avatar
      twe69
      Occasional Contributor
      6 years ago

      I tried adding an extra '\' for the folder but am still getting:

       

      [DBNETLIB][ConnectionOpen(Connect()).]SQL Server does not exist or access denied.

      • tristaanogre's avatar
        tristaanogre
        Esteemed Contributor
        6 years ago

        Verify.

         

        this is your old line of code

         

        "Provider=SQLOLEDB;SERVER=\\UXXXXXXX\MSSQLSERVER2017;Database=DBXXXXX;User Id=UserXXXX;Password=PassXXXXX;"

        This should be your new line of code

         

        "Provider=SQLOLEDB;SERVER=\\\\UXXXXXXX\\MSSQLSERVER2017;Database=DBXXXXX;User Id=UserXXXX;Password=PassXXXXX;"