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

Access

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

Ex:asp

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

Ex:asp.net

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.net

Server=;Database=;uid=;pwd=;

Ex: :asp

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

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

conn.open DSNtemp

EX: asp.net

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

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

      name="connectionString"

      connectionString="Server=;Database=;uid=;pwd=;"

      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...

Powered by WHMCompleteSolution