Has anyone executed sqlcmd (command-line) utility from a Ranorex automation script and fired a T-SQL script to query the database?
I need to do this in a web application testing scenario that needs to both run SELECTs as well as INSERTs and DELETEs against the back-end SQL Server database.
Thanks.
Search found 8 matches
- Fri Aug 19, 2016 4:17 pm
- Forum: How To …
- Topic: Run sqlcmd and query database from script
- Replies: 1
- Views: 3582
- Thu Mar 10, 2016 9:12 pm
- Forum: Automation API
- Topic: Stuck accessing SQL Server in code
- Replies: 7
- Views: 3570
Stuck accessing SQL Server in code
I'm trying to get a SQLClient database connector initialized and open then to run embedded SQL queries in my Ranorex user code. it is Failing on initialization of the connection string. Any code that is working for anyone out there, I'd love to take a look at it and how you are structuring the code ...
- Thu Feb 18, 2016 5:55 pm
- Forum: Automation API
- Topic: SQL Delete Query - How to ?
- Replies: 1
- Views: 2769
SQL Delete Query - How to ?
How do I fire a SQL delete query to clear out records created by my web app? Is this a simple API call, or does it involve a SQL Data Connector to be setup?
All the steps / actions needed here.
Thanks.
Zee
All the steps / actions needed here.
Thanks.
Zee
- Tue Feb 09, 2016 1:26 pm
- Forum: Automation Tools
- Topic: Scheduling Ranorex script execution - Tools ?
- Replies: 2
- Views: 2325
Scheduling Ranorex script execution - Tools ?
I am running my Ranorex .EXE automation scripts on a VM in an automated/scheduled way daily. Or trying to plan for that. What tool (Task Scheduler ?) is best on Windows Server 2008. I've heard of Jenkins, but we're not using that for anything else such as builds. It is only to schedule and execute t...
- Wed Jan 27, 2016 8:47 pm
- Forum: Automation Tools
- Topic: Detect that a PDF document displayed in page
- Replies: 1
- Views: 1887
Detect that a PDF document displayed in page
I have a link that navigates to a PDF file within the browser. How do I validate the page as PDF document [displayed]? It does show the .PDF in the browser address toolbar: http://Orgname.org/education/partners/2013participationguidelines.pdf The script code is what I'm looking for. Not sure what re...
- Wed Jan 20, 2016 4:55 pm
- Forum: Automation API
- Topic: How to find child TAGs in DOM tree?
- Replies: 1
- Views: 2551
How to find child TAGs in DOM tree?
I have Repo items in Web application that represent HTML tags that may or may not have children. I'll show examples below. I want to determine through script what the DOM tree is and manipulate it accordingly. Here I want to see what sits beneath <>TD. <>TBody <>TR <>TD <>TBody <>TR <>TD <>Big '20' ...
- Thu Jan 07, 2016 5:18 pm
- Forum: Automation Tools
- Topic: No error info - The user code class has compile error
- Replies: 2
- Views: 2491
No error info - The user code class has compile error
I cannot find meaningful explanation of the error on Build when UserCode fails with message: Failed to update code for 'C:\QA\KC-Main\Tickets\MainSitePurchaseTickets\MainSitePurchaseTickets\PurchTC3.rxrec'. The user code class has compile errors - C:\QA\KC-Main\Tickets\MainSitePurchaseTickets\MainSi...
- Wed Jan 06, 2016 1:12 pm
- Forum: How To …
- Topic: Saving offline and viewing log files?
- Replies: 1
- Views: 2061
Saving offline and viewing log files?
I saved the .rxlog and .rxlog.data files to a separate file folder and tried to load and view them in Ranorex studio unsuccessfully. I got the following message: Data file (<SolutionName>_20160104_144439.rxlog.data) or transformation file is missing. How do I save these files off and view them via R...