Explain connection string in test complete in detail

[kaiiii]

on the link below:

https://support.smartbear.com/testcomplete/docs/testing-with/advanced/working-with-external-data-sou...


in the line

 AConnection.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" + _
  "Data Source=C:\Microsoft Visual Studio\VB98\biblio.mdb"

What is provider how can i find it or it's just a connection string Syntax ??

And  in the line

 Cmd.CommandText = "Select * From Authors WHERE Authors.[Year Born] < :MyParam"
  Cmd.CommandType = adCmdText

What is MyParam ?
what is the mean CommandType and adCmdText ?
Can we execute as many query as we need ?

[AlexKaras]

Hi,

All the mentioned objects are not something provided by TestComplete but objects that are provided by ADO in Windows. Thus search for the ADO documentation to get an understanding of the technology and objects provided.

E.g.:

https://www.google.com/searchq=vbscript+oledb+command+object&oq=vbscript+oledb+command+object

https://www.w3schools.com/asp/ado_ref_command.asp

https://www.w3schools.com/asp/prop_conn_connectionstring.asp