Forum Discussion

whuang's avatar
whuang
Regular Contributor
6 years ago

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
    6 years ago

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

whuang's avatar
whuang
Regular Contributor

Hi AlexKaras I think I still need your help regarding this. Now I can setup the SQL connection, but when I tried to execute the query below, it returned me another error: "Object doesn't support named arguments: DBConnection.CommandText".

 

Set DBConnection = ADO.CreateConnection
DBConnection.ConnectionString = "Provider=xxxx;Integrated Security=xxxx;Persist Security Info=False;User ID=xxxx;Initial Catalog=xxxx;Data Source=xxxx"
DBConnection.Open

DBConnection.CommandText = "My Query to Run"
DBConnection.Execute()

DBConnection.Close

whuang's avatar
whuang
Regular Contributor
6 years ago

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