kaiiii
6 years agoRegular Contributor
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"