| || |
In my test, I was able to establish a connection to a database, but the connection object is lost as the test moves from the first iteration to subsequent ones. How can I preserve the connection from one iteration to another?
Run Error Object required: ''
Line (55): "objRecordSet.Open objSqlQuery, objConn".
If testIteration = 1 then
strTblName = DataTable.Value(4,"Global")
strField = DataTable.Value(5,"Global")
objSqlQuery = "select "&strField& " from "&strTblName
objRecordSet.Open objSqlQuery, objConn
Re: SQL connections
Try to declare it as a global object in an associated function library.