Object Required dbConnection
We're new to TestComplete and are trying to bring as much of our existing architecture over as possible. We use an MS-Access back end for data, and I'm right now writing and calling a sub that ...
Forum Discussion
Hello Kathryn
Your dbConnection should be a global variable when you are defining it in one script and using it in another script.
Try this
Set dbConnection = CreateObject("ADODB.Connection")
dbConnection.ConnectionString = "Provider=Microsoft.Jet.OLEDB.3.51;" & "Data Source=C:\MyTestData.mdb"
dbConnection.Open
Set Cmd = CreateObject("ADODB.Command")
Cmd.ActiveConnection = dbConnection
Cmd.CommandText = "SELECT * FROM TestSets WHERE TestSetID LIKE '"
& VI_TESTSET & "%%% ' " & "ORDER BY TestSetID"
& VI_TESTSET & "%%% ' " & "ORDER BY TestSetID"
Cmd.CommandType = adCmdText
Set rsTestSetDB= Cmd.Execute
Thankyou
