Got it worked. I went to database checkpoint and try connecting and ran teh code again without any changes it worked. not sure what the issue was. but its working.
What were you expecting? Syntax wise, you have it incorrect. It should be
Qry1.Execute("<the sql statement to be executed>")
Just as a side note... the online documentation for TestComplete that I've been linking you to is pretty well written with code examples and such in multiple languages. If you haven't done so already, I'd highly recommend two things.
1) Take a look at the internal documentation for TestComplete for using ADO for connectivity. Several topics in the help files cover the different methods. For the ADO object you are using, you can start here https://support.smartbear.com/testcomplete/docs/reference/program-objects/ado/index.html
2) That link I sent you has several links embedded which will take you to other specific documentation for the Microsoft and Borland ADO objects and methods.
