MySql connection ressource need to be freed ?

[gerfred]

Hi,

I ve read the "Database Checkpoint and QTP" blog from Saket, it was really helpful

I would like to know if used ressources (like oConnection = CreateObject("ADODB.Connection") or recordSet) need to be freed (and when/how if needed) ? or if they are auto freed at the end of the test run.


Second point, is there a way to build a connection string with an encrypted password instead of a clear one ? (just to not having readable DB password in multiple places)

regards,

[Saket]

[gerfred]

thanks for the answer.

it seems that msdn link does not work

[Saket]

[gerfred]

link works now
thanks you are really very reactive

[Priyanka Arya]

Hi,

For DB connectivity i have to give full connection string with DSN, username, password, SID etc. like this: ConnectionString = "DSN=QTPDSN;Description=desc;UID=;PWD=;APP=;WSID=;DATABASE=;"

but in donot want to give this UID, pwd, WSID in each and every script again again. I want do this setting in DSN and then provide only DSN name in connectingString. Is it possible?

Please reply to me ASAP.

With Regards,
Priyanka

[basanth27]

Priyanaka,
Make it a function. Call it wherever you want to..isint that feasible ?

Defining a DSN is like creating a dependency on that machine. Creating a Connection string on the fly helps you to execute on any machine irrespective of any configuration.