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. The connection string needs to be formatted as below form:


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

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

Add Feedback