| || |
I use a query that I run via SQLPLUS from a batch file to access an Oracle database to do some clean up operations after my script has completed running. Currently I do this manually. I have a questions on the best route to do this through TC.
1. I can open an ADO connection to the database and run the query. Can I open the ADO connection and run the query from a file?
Set AConnection = ADO.CreateADOConnection
AConnection.ConnectionString = "Provider=msdaora;Data Source=sf-rgs-dev-db-01-v/xxxx;User Id=xxxx;Password=xxxx;"
AConnection.LoginPrompt = False
' run query from a file here
2. The other option is to simply call the batch file from the script. How do I call the batch file from TC?
Re: Database Question
I always run a batch file via tested apps.
Also with database queries I always just use them in a subroutine. I do however pass a parameter to a few of these routines using a projectsuite variable that has grabbed a value from the database somewhere in another script. (ie when wanting load a previous record).