ASP.NET and ASP connection strings for MSSQL and Access databases


Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\mydatabase.mdb


set conn=Server.CreateObject("ADODB.Connection")
conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;data source=c:/webdata/northwind.mdb"

OleDbConnection myConnection = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;data source=c:/webdata/northwind.mdb")


Access 2007

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccess2007file.accdb;Persist Security Info=False

MSSQL 2008 & 2012
Ex: asp

Driver={SQL Server};Server=;Database=;Uid=;Pwd=;



Ex: :asp

Set conn = Server.CreateObject("ADODB.Connection")

DSNtemp="DRIVER={SQL Server};SERVER=serverURL;UID=username;PWD=pwd;DATABASE=dbname" DSNtemp


string connectionString = "SERVER=serverURL;UID=username;PWD=pwd;DATABASE=dbname";

SqlConnection connection = new SqlConnection(connectionString);
or Write this into your web.config:



      providerName="System.Data.SqlClient" />


  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

SQL server- network related or instance-specific error happened while connection establishing

  Instance-specific or network related error happening while connecting to SQL server   Please...

OleDB connection string examples

OleDB connection string examples MS Access (Jet) "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA...

Do you allow custom COM components?

Do you allow custom COM components? We are not offering to install the custom COM components...

Error when accessing a WCF services

Error when accessing a WCF services Error when accessing a WCF service: "IIS specified...

How to cache static contents to client with UseMaxAge?

You can consider to caches static contents to the client with UseMaxAge if your website has too...