Connection String for MS Access

Last modified: February 25, 2020
You are here:
Estimated reading time: < 1 min

Connection String for MS Access

Connection String is a string which contains database connection information and it will be passed to the Driver Manager and driver (ADO) directly.

Beside that,The connection string need to be formatted as below form:

Argument1=Value1; Argument2=Value2; Argument3=Value3;…;ArgumentX=ValueX

Example:
Provider=MSDASQL; DRIVER={Microsoft Access Driver (*.mdb)}; UID=; PWD=SamplePassword; DBQ=C:\Domains\sample.net\db\sample.mdb;

Was this article helpful?
Dislike 0
Views: 18