Forum Discussion

kaiiii's avatar
Regular Contributor
6 years ago

Explain connection string in test complete in detail

on the link below:

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