Can I connect QTP to the Database?
Can i connect QTP to my back-end(Oracle)?
I Have this scenario where i do have some valid logins (combination of username & password).
These are not consistant; password can be changed frequently. Righjt now what im doing is parameterizing my username-password combo in the spreadsheet. I would like QTP to pick the valid data from the table directly and match with the login action. Is there any way to do this in QTP?
Im confused here......
Re: Can I connect QTP to the Database?
So far, there is no way to use dinamic value via QTP DataBase CheckPoint.
But it is possible to do via VBscript (external or internal, doesn't matter).
In the line, where you specifying ConnectionString -
point the dinamic part into your DataTable values, like that:
ConnectString = "somePermanentValues" & (DataTable("Password", dtGlobalSheet)) & "restOfConnectionString"