Search found 31 matches
- Fri Sep 23, 2016 7:46 pm
- Forum: Automation API
- Topic: Need to Test REST webservice using Ranorex
- Replies: 5
- Views: 5274
Need to Test REST webservice using Ranorex
Hi All, I have a requirement to test REST webservice in Ranorex and Compare the Data in Response JSON with the Hadoop query result. Below is the flow: 1) Submit the REST request with some parameters and Get the Response in JSON format 2) Execute Hadoop query and Convert the output the JSON format 2)...
- Thu Apr 28, 2016 6:04 pm
- Forum: Automation Tools
- Topic: Bind data from 2 data connectors for a single testcase
- Replies: 2
- Views: 1716
Re: Bind data from 2 data connectors for a single testcase
Let me explain in a better way. I have 2 testcases (2nd testcase is a child testcase of 1st testcase). Parent testcase uses 5 variables of which 3 variable needs to be used by Child testcase as well. Apart from these 3 variables, Child testcase has some other variables and I can put the 3 variables ...
- Wed Apr 27, 2016 10:32 pm
- Forum: Automation Tools
- Topic: Bind data from 2 data connectors for a single testcase
- Replies: 2
- Views: 1716
Bind data from 2 data connectors for a single testcase
Hi, I have a scenario where one testcase is a parent testcase of another testcase. I have used Sheet 1 of an excel sheet as data input sheet for variable binding of Parent testcase and named that as "DataConnector". Similarly, used Sheet 2 of an excel sheet as data input sheet for variable binding o...
- Tue Apr 19, 2016 8:42 pm
- Forum: Object Identification and Technologies
- Topic: excel sheet name is displayed as jr_page_anchor_0_1
- Replies: 1
- Views: 3140
excel sheet name is displayed as jr_page_anchor_0_1
Hi, I am trying to import data from excel sheet to data table. Below code worked last week and I was able to import data from excel to data table. But when I try today, It is nor retrieving correct sheet name. Sheet name is displayed as "JR_PAGE_ANCHOR_0_1". Please help me in resolving the issue. Be...
- Thu Apr 14, 2016 5:55 pm
- Forum: Object Identification and Technologies
- Topic: How to get Selected item list from a combo box dropdown list
- Replies: 2
- Views: 4544
How to get Selected item list from a combo box dropdown list
Hi, I have a dropdown list when we can select multiple items. I need to unselect the already selected items and then select the items as need per my testcase. Could you please let me know how to unselect the already selected items. I have attached a snapshot of the dropdown list for reference. Thank...
- Fri Apr 08, 2016 3:36 am
- Forum: Object Identification and Technologies
- Topic: Not able to excel data connector after installing excel 2016
- Replies: 1
- Views: 3505
Not able to excel data connector after installing excel 2016
Hi, I have installed excel 2016 in my laptop and after that I am not able to use excel data connector functionality of Ranorex. When i try to use, excel data connector, I am getting the below error. "An error occurred while loading data connector. Unable to cast COM object of type Excel.ApplicationC...
- Thu Apr 07, 2016 10:17 pm
- Forum: Object Identification and Technologies
- Topic: Error related to Microsoft.ACE.OLEDB.12.0
- Replies: 1
- Views: 2704
Error related to Microsoft.ACE.OLEDB.12.0
Hi, I am trying to import data from excel to data table. When use the below connection string, I am getting the error "The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine." Please let me know how to resolve the issue. ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;D...
- Thu Apr 07, 2016 12:55 pm
- Forum: Automation Discussions
- Topic: "CommandText property has not been initialized" error
- Replies: 3
- Views: 7129
Re: "CommandText property has not been initialized" error
Hi,
I think this another issue when code is executed from recorder. I am getting this error when I am executing the code module from recorder even thought the parameter values are defined in the code itself.
I think this another issue when code is executed from recorder. I am getting this error when I am executing the code module from recorder even thought the parameter values are defined in the code itself.
- Thu Apr 07, 2016 12:52 pm
- Forum: Object Identification and Technologies
- Topic: Pass parameter to SQL query from excel data connector
- Replies: 3
- Views: 3692
Re: Pass parameter to SQL query from excel data connector
Hi, Thank you for your reply. I have tried parsing but that didn't workout. I have attached my code here. Could you please take a look at this and let me know what is the issue. Database connection is establishing but parameter value is not passing to the query in all the iterations. I am really str...
- Wed Apr 06, 2016 10:37 pm
- Forum: Object Identification and Technologies
- Topic: Pass parameter to SQL query from excel data connector
- Replies: 3
- Views: 3692
Pass parameter to SQL query from excel data connector
Hi, I have a scenario where I need to run the same SQL query with different values. I made the dynamic value in the query as parameter and pass value to that parameter using excel data connector. Below is the same query that i have used. This query is not working when I enter "weekID" values in the ...
- Wed Apr 06, 2016 5:47 pm
- Forum: Automation Discussions
- Topic: "CommandText property has not been initialized" error
- Replies: 3
- Views: 7129
"CommandText property has not been initialized" error
Hi, I am passing sql query as a parameter to the function. When i try to execute the code, it is throwing me error "ExecuteReader: CommandText property has not been initialized" It works fine when i put SQl query in the code and execute. The problem is when I am passing that query as parameter using...
- Tue Apr 05, 2016 9:17 pm
- Forum: Object Identification and Technologies
- Topic: Writing multiline query using vb.net in ranorex
- Replies: 5
- Views: 3444
Re: Writing multiline query using vb.net in ranorex
Hi, Instead of writing the query in the code, Can we store the queries in excel and pass the query as parameter using an excel data connector.
If this is possible, Can we include parameters in that query which we are storing in excel sheet.
Thanks
Vivek
If this is possible, Can we include parameters in that query which we are storing in excel sheet.
Thanks
Vivek
- Tue Apr 05, 2016 4:16 pm
- Forum: Object Identification and Technologies
- Topic: Writing multiline query using vb.net in ranorex
- Replies: 5
- Views: 3444
Re: Writing multiline query using vb.net in ranorex
Thanks for your reply. I am using ranorex version 5.4.5....With the same version, we are able to write multiline sql queries by using @ in front of the query. Ex: String getDateID = @"select col1, col2, col9, round(sum(col3)) as ATD from datbase.table where col4=&year and col5=1" Please let me know ...
- Tue Apr 05, 2016 3:31 pm
- Forum: Object Identification and Technologies
- Topic: Writing multiline query using vb.net in ranorex
- Replies: 5
- Views: 3444
Writing multiline query using vb.net in ranorex
Hi, I have to write a very big sql query to retreive data from hadoop database. It is showing syntax error when the query is included in double quotes. Please let me know the easy way to write mutliline sql query in vb.net. Below is the query that i have used and it is not working. I have to pass th...
- Mon Apr 04, 2016 4:50 pm
- Forum: Automation Discussions
- Topic: Compiler initialization failed unexpectedly error is coming
- Replies: 0
- Views: 2601
Compiler initialization failed unexpectedly error is coming
Hi, I have written a function for connect to hadoop database in VB.net. When i try to execute the function, am getting the error "Compiler initialization failed unexpectedly: The filename, directory name, or volume label syntax is incorrect" When I try to build/rebuild a solution, it is not throwing...