DSNless connection string



DSNless connection string for use with .mdb MS Access, etc.:

"DRIVER={Microsoft Access Driver (*.mdb)};
DBQ=C:\inetpub\vhosts\yourdomain.com\database.mdb"

Or

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



Was this answer helpful?

 Print this Article

Also Read

Import a MySQL or MSSQL database on Windows hosting

Importing Databases To import an existing database: If you are subscribed to several...

Enable URL Rewriting in Joomla

To enable URL rewriting in Joomla:   In "Global Configuration"   Select "Yes" for "Use URL...

Create SPF record in Plesk

Creating an SPF record can help with delivery sending issues and from other server rejecting your...

Enabling HTTP Compression In Windows Hosting

In your web.config file, add the following line of code to enable HTTP...