OleDB connection string examples

MS Access (Jet)

"PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA Source=[Path to database];User ID=Admin;Password=dbpassword"

Note:

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 Site Info Manager section in your control panel.
You can omit the User Id & Password attributes, if your Access Database is not password protected.

MS SQL

"Provider=sqloledb;Data Source=[SQLServerName];Initial Catalog=[DatabaseName];User Id=[SQL Login];Password=[SQL Password]"

Note:

For ASP.NET applications, you should consider using the .NET native SQL data provider rather than using Ole
You can find the SQL server information in the Site Tools section of Control Panel

If you run in to problems using this code, please post in our community forum. Technical support cannot assist with specific coding related issues.

Article ID: 630, Created: 8/14/2009 at 4:42 PM, Modified: 5/6/2016 at 11:30 AM