Can you provide me with some OleDB connection string examples?
MS Access (Jet)
"PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA Source=[Path to database];User ID=Admin;Password=dbpassword"
- If you've uploaded your MDB file in DB folder, you need to use physical path like d:\\domains\\yourdomain.com\\db\\yourdb.mdb
- You can use Server.Mappath function to identify Path to your database. For example, if the DB file is in the database directory under your web root, you would use server.mappath("/database/test.mdb"). As an alternative, you can also insert the full path. You can find the path in the Account Information section in your control panel.
- You can omit the User Id & Password attributes, if your Access Database is not password protected.
Was this answer helpful?
DSN or DSN-less? Connection to your database can be done using either a DSN (Data Source Name) or...