ContributionsMost RecentMost LikesSolutionsRe: TestComplete and SQL databases - Restoring per test 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(); } Re: TestComplete and SQL databases - Restoring per test I tried adding an extra '\' for the folder but am still getting: [DBNETLIB][ConnectionOpen(Connect()).]SQL Server does not exist or access denied. Re: Training There is a free course here: http://www.testmanagement.com/courses/fast-start-testcomplete/ and then the advanced is paid for if you want to go further. Re: TestComplete and SQL databases - Restoring per test 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"](); } Re: TestComplete and SQL databases - Restoring per test 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! Re: TestExecute licencing issue on Nutanix server DWalsh Would it be possible to take a 'Snapshot' of the VM with Licence Manager on it? I have been assured the IP address, hardware and MAC address will remain the same in all instances. Would the snapshot still work or could that break the licenses? This is more of a backup procedure than for any other reason. Re: TestComplete and SQL databases - Restoring per test m_essaid do you have a link to how to run batch files? I am quite new to Test Complete and looking towards sorting out the environment at the moment before I get training under way. Re: TestExecute licencing issue on Nutanix server I could get that port opened so that might be the best case solution with a physical machine on our test network working as the licence manager. Thanks! Re: TestExecute licencing issue on Nutanix server Thanks for the reply. the issue with the auto search is that it's 2 networks being joined together protected with firewalls & policies. I can double check with the Operations Department but am sure we can have a fixed permanent VM for the licence manager setup. This will solve the problem. The other way round is more difficult as its adding a new physical machine to a protected network. Re: TestExecute licencing issue on Nutanix server Yes I used the form that you linked to Thursday 17th October 2019. Ok cool will do that if we need to go with option 1 of a physical machine connected.