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
Article ID: 152, Created: July 24, 2012 at 10:19 PM, Modified: July 24, 2012 at 10:19 PM