Knowledgebase
Portal Home > Knowledgebase > Windows Hosting - Tutorials > Create MS Access DSNLess connection string
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")
|
Add to Favourites
Print this Article
|
Also Read