twe69
Occasional Contributor
Joined 6 years ago
User Profile
User Widgets
Contributions
Re: 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(); }2.5KViews2likes1CommentRe: 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"](); }2.3KViews0likes6CommentsRe: 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!2.4KViews0likes7CommentsRe: 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.2KViews0likes1CommentRe: 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.2.1KViews0likes0Comments