cancel
Showing results for 
Search instead for 
Did you mean: 

Explain connection string in test complete in detail

kaiiii
Regular Contributor

Explain connection string in test complete in detail

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 ?

1 REPLY 1
AlexKaras
Community Hero

Re: Explain connection string in test complete in detail

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

Regards,
  /Alex [Community Hero]
____
[Community Heroes] are not employed by SmartBear Software but
are just volunteers who have some experience with the tools by SmartBear Software
and a desire to help others. Posts made by [Community Heroes]
may differ from the official policies of SmartBear Software and should be treated
as the own private opinion of their authors and under no circumstances as an
official answer from SmartBear Software.
The [Community Hero] signature is used with permission by SmartBear Software.
https://community.smartbear.com/t5/custom/page/page-id/hall-of-fame
================================
New Here?
Join us and watch the welcome video:
Top Kudoed Authors