Forum Discussion

nakshatra's avatar
nakshatra
Contributor
5 years ago
Solved

how to change DB connection string dynamically

Hi all,   I automated nearly 100 test cases by using test complete. Used 20 variables to read the data from external data sources. In this 11 variables are used for fetching data from Sql Data ...
  • tristaanogre's avatar
    tristaanogre
    5 years ago

    You shouldn't need to store your connection string in several different places.  If the connection string is common, then you can store that in a single variable and consume that in all the places you need.

nakshatra's avatar
nakshatra
Contributor

Thanks for the reply.

 

here I am using 11 variables and 11 different queries and same connection string.

 

Could  you please expalin me how to use single variable in all places. It will be helpfull.

 

Regards,

Nakshatra.

 

tristaanogre's avatar
tristaanogre
Esteemed Contributor
5 years ago

I'm not sure I understand the question.  You set up a global variable and store your connection string in there and utilize that in your tests.

 

It might be helpful to know a bit more about how you're setting things up.  Are these Keyword tests that you're doing a DB connection for a data driven loop?  Please give us an example of one of these 11 situations and we can, perhaps, answer your question in grated detail.

  • nakshatra's avatar
    nakshatra
    Contributor
    5 years ago

    Thanks for the reply.

     

    Create global variable and it''s working.

     

    Regards,

    Nakshatra.