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"

Note

  1. If you've uploaded your MDB file in DB folder, you need to use physical path like d:\\domains\\yourdomain.com\\db\\yourdb.mdb
  2. 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.
  3. You can omit the User Id & Password attributes, if your Access Database is not password protected.

MS SQL

"Provider=sqloledb;Data Source=[sql.yourdomain.com];Initial Catalog=[DatabaseName];User Id=[SQL Login];Password=[SQL Password]" 

Note

  1. For ASP.NET applications, you should consider using the .NET native SQL data provider rather than using Ole.

Was this answer helpful?

 Print this Article

Also Read

What is DSN and DSN-less Connection ?

DSN or DSN-less? Connection to your database can be done using either a DSN (Data Source Name) or...