Connecting to a SQL Server database using Integrated Security from JavaScript
I have a BDD test. One of the step definitions connects to SQL Server database and fetches some data. I use JavaScript. This the JavaScript code I have. The connection used Integrated Security, so no need to give user id and password var connection=ADO.CreateADOConnection(); connection.ConnectionString="Provider=SQLOLEDB;Data Source=<datasource>;Initial Catalog=<database>;Integrated Security=SSPI"; connection.Open(); connection.Open() is throwing up a message box asking for user id and password. See the attached screenshot. The above connection string works fine with Database Tables (Stores=>DbTable). See the attached screenshot. Does anyone has code sample to connect to SQL database using integration security.
RuntimeErrors after upgrading to 15.68.8.7
Hello, I recently upgraded to the latest version of TestComplete, and unfortunately, I'm experiencing issues. I'm still facing a RuntimeError originating from TestComplete's native functions (I'm using it with Python scripts). The errors occur with functions like Log.Message, Log.AppendFolder, and others. However, the problem is quite random, as it's not always the same line of code that fails. As a result, I'm unable to execute any tests at the moment and will need to downgrade to the previous version. Is anyone facing this problem as well?
Name Mapping not working on remote browser
The name mapping and test cases work fine on local browsers, but would complain about page or object not found when running headless remote browsers and in parallel testing. I have the following setup for browser name mapping: For headless setup I have: server = "localhost" capabilities = { "browserName": "chrome", "headless" : "true", "screenResolution": "1920x1080", "platform" : "Headless", "record_video": "true" } Browsers.RemoteItem[server, capabilities].Run(url) Is this the correct way to work with name mapping on headless browser?
TestComplete cannot find chrome webdriver
Hello, I am trying to get TestComplete to run headless tests. I am following this guidehttps://support.smartbear.com/testcomplete/docs/app-testing/web/supported-browsers/headless.html#localand I am running into the issue that TestComplete cannot download/see the needed WebDriver. This is the JavaScript used in the guide. function Test_Chrome_Headless() { var server = "localhost"; var capabilities = { "browserName": "chrome", "screenResolution": "1920x1080" }; var url = "myurl"; Browsers.RemoteItem(server, capabilities).Run(url); } I downloaded the chrome driver manually and created the path as shown above. But even with the driver in the correct location he cannot seem to open it. When I try to open the driver myself, it works. Does anyone have an idea what I am doing wrong? Kind regards, Luuk
ClickItem not selecting the proper item from a dropdown
I am working with TestComplete for the first time, evaluating it for ease of use for our organization. I'm a tester, not a developer I tried recording a test that fills out a form including a dropdown list. The code generated by a record as JavaScript shows as browser.pageLeaveHomePageGc.framePtifrmtgtframe.formW3lvLeaveTranG.selectGDerivedW3lvDescr500.ClickItem("Vacation"); However, when I play it back, it just clicked on the first (sometimes second) item in the dropdown list, not the item that I recorded selecting. There are a large number of items in the dropdown list (20+) Is there a different sort of command that would select the correct item? I tried recording as script and recording as keyword, but still got the same resultRunning tests by tag name in specific order
Hello, I will be running my suite of tests in a CI/CD pipeline (Jenkins) but I realized from the documentation that running tests by tag name (following the CLI commands) does not guarantee the tests will be run in a certain order. (Note:The tests that match the specified tag will be run in an arbitrary order.) While trying to find a workaround to this inconvenience, I realized that it does indeed follow a specific order. The order is given by how the test files are sorted in the file script.tcscript. So, for whoever needs to run their tests using tag names, and also wants to run a "pre-step test" or something like that, all you have to do is open that file on any text editor, and move the row where your test file is, up to the place first place, or at whichever place you want it to be executed. Example: # Assuming all tests have the tag "@Smoke" <folder name="MaiGroup"> <folder name="Group1"> <child name="TestMethod1" key="ZZZZ-YYYYY-VVVVV}" path="File1.js" /> <child name="TestMethod2" key="ZZZZ-YYYYY-VVVVV}" path="File2.js" /> <child name="TestMethod3" key="ZZZZ-YYYYY-VVVVV}" path="File3.js" /> </folder> </folder> # Test run for the @Smoke tag will look like: TestMethod1 TestMethod2 TestMethod3 ----------------------------------------------------------- # Now, if we want to run TestMethod3 first, all we have to do is open the script.tcscript file and move the TestMethod3 to the first place: <folder name="MaiGroup"> <folder name="Group1"> <child name="TestMethod3" key="ZZZZ-YYYYY-VVVVV}" path="File3.js" /> <child name="TestMethod1" key="ZZZZ-YYYYY-VVVVV}" path="File1.js" /> <child name="TestMethod2" key="ZZZZ-YYYYY-VVVVV}" path="File2.js" /> </folder> </folder> # And now, the test run for the @Smoke tag will look like: TestMethod3 TestMethod1 TestMethod2 ----------------------------------------------------------- Hope this helps someone, and maybe the TestComplete team can now update the documentation. Regards.
