Create MS Access DSNLess connection string

Many people have requested this so here it is: 


"DRIVER={Microsoft Access Driver (*.mdb)}; 
DBQ=C:\MYDB\TEST.MDB" 

If you want to use the native OLEDB provider for 
Access, here it is. This should perform a 
little better than ODBC: 

conn.Open "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("./db/database.mdb")

  • 1 کاربر این را مفید یافتند
آیا این پاسخ به شما کمک کرد؟

مقالات مربوطه

Do you support ASP?

 Yes, we support ASP.

Do you support Cold Fusion?

We do not support or Cold Fusion on our shared hosting servers, however you are more than welcome...

Do you support Servlets/JSP on Windows Server?

Yes, we support Servlet/JSP on our Windows Server.

Enable Parent Paths in Plesk - Windows Server

Many scripts use a function called parent paths. If you are running one of these scripts and...

Give write permissions to .mdb, files & folders

Plesk give write permissions to MS Access database .mdb file OR normal file & folder...