Forum Discussion

kaiiii's avatar
kaiiii
Regular Contributor
6 years ago

How to create connecton with Aqua Data Studio 3.7.6

Hi,

I need to build a connection string to get OTP from database.

here i am using Aqua Data Studio 3.7.6 which is already installed in my system.

In below lines, i do'nt understand what to put in provider and data source ?

what is the meaning of exactly provider and data source ?

-------------------------------------------------------------------------------------------

  Set DBTab = DBTables.Table1
  
  ' Specifies a connection string
  DBTab.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" + _
  "Data Source=C:\Work\MyDB.mdb;"
  ' Specifies the login and password
  DBTab.Login = "Tester"
  DBtab.Password = "123"