How to modify connection string in a stored DB table element without modifying the data?
I tried using the ellipsis button of the Data binding box and follow the Select Database Table wizard and change the connection string. But as you follow the wizard and say finish it changes all data stored before. Is there any way i can just change the connection string in a stored database element without altering the data?
There is no way to do this by using DBTable Element Editor. We have an appropriate suggestion in our DB, and your message has increased its rating.
However, you can use the "<MyDBTable>.ConnectionString" property (see the "DBTable Object" help topic for more information) to change the connection string of <MyDBTable> from your script during the test execution. This modification is actual only during the test execution (after the test ends, all changes will be discarded).
Thanks for your reply. Can you please send me a piece of code about how to handle connection string modification from the script. I couldn't get much help from the DB table object Help topic. I have created a database checkpoint in my script. The only code it brings up during recording is the Compare method.I need to change the connection string for my database connection.
Any help is really appreciated.