Search found 31 matches

by vivek.guvva
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)...
by vivek.guvva
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 ...
by vivek.guvva
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...
by vivek.guvva
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...
by vivek.guvva
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...
by vivek.guvva
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: 3507

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...
by vivek.guvva
Thu Apr 07, 2016 10:17 pm
Forum: Object Identification and Technologies
Topic: Error related to Microsoft.ACE.OLEDB.12.0
Replies: 1
Views: 2705

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...
by vivek.guvva
Thu Apr 07, 2016 12:55 pm
Forum: Automation Discussions
Topic: "CommandText property has not been initialized" error
Replies: 3
Views: 7130

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.
by vivek.guvva
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...
by vivek.guvva
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 ...
by vivek.guvva
Wed Apr 06, 2016 5:47 pm
Forum: Automation Discussions
Topic: "CommandText property has not been initialized" error
Replies: 3
Views: 7130

"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...
by vivek.guvva
Tue Apr 05, 2016 9:17 pm
Forum: Object Identification and Technologies
Topic: Writing multiline query using vb.net in ranorex
Replies: 5
Views: 3445

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
by vivek.guvva
Tue Apr 05, 2016 4:16 pm
Forum: Object Identification and Technologies
Topic: Writing multiline query using vb.net in ranorex
Replies: 5
Views: 3445

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 ...
by vivek.guvva
Tue Apr 05, 2016 3:31 pm
Forum: Object Identification and Technologies
Topic: Writing multiline query using vb.net in ranorex
Replies: 5
Views: 3445

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...
by vivek.guvva
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...