Forum Discussion

whuang's avatar
whuang
Regular Contributor
7 years ago
Solved

How can I get TC to run query against SQL database?

Hi everyone,   I have a test that I need to ask TC to run a query in SQL database to update some data, but I have no knowledge about database at all. I read about ADO Object and tried to do the s...
  • whuang's avatar
    whuang
    7 years ago

    Nevermind, I figured out, it should be DBConnection.Execute(Query to run)

AlexKaras's avatar
AlexKaras
Community Hero
7 years ago

Hi,

 

> Multiple-step OLE DB operation generated errors.

This means that executed SQL contained more than one statement. ADO supports one statement per SQL, so instead of batch SQL execution you need to execute it line-by-line.