Sideway from Sideway
Draft for Information Only


ADO.NET Connection String
  .NET Data Provider
 .NET Connection
  .NET Connection String
  Common Problems

ADO.NET Connection String

ADO.NET connection string is simply the string used by the connection provided by the corresponding data provider.

.NET Data Provider

A .NET Data Provider is a component designed to access the data source. The included data providers in .Net are System.Data.SqlClient namespace for accessing Microsoft SQL Server, System.Data.OleDb namespace for accessing OLE DBFor data sources exposed by using OLE DB, System.Data.Odbc namespace for accessing data sources exposed by using ODBC, System.Data.OracleClient namespace for accessing Oracle data sources of Oracle client software version 8.1.7 and later, System.Data.EntityClient namespace for accessing EntityClient data sources of  Entity Data Model (EDM) applications, and System.Data.SqlServerCe namespace for accessing data sources of Microsoft SQL Server Compact 4.0.

.NET Connection

A .NET connection is an element of data provider for providing a unique connection to a data source. In order to establish a connection to a data source, some connectting information are needed. These information is stored as ConnectionString property of the corresponding .NET connection. Some information

.NET Connection String

There are many ways to present a connection string. Some information is Provider, Data Source, For example, ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=T:\test.mdb;User Id=admin;Password=;"

Common Problems

Some common problems are

  • If you have a 64 bit machine and have Office 32 bit installed, you can try to download the 32 bit version of the Access Database Engine. Microsoft Access Database Engine 2010 Redistributable
  • Installing Access Database Engine without uninstalling Microsoft office.

    Launching the install of a Microsoft ACE OLEDB Provider on a machine with an Office install other than the current one (e.g. 32 on 64) will cause the install to fail. To have it run properly you need to launch it from a command line with the “/passive” argument specified.

    • To install the Microsoft ACE OLEDB Provider 32-bit on a machine running Office 2010 64-bit:

    $> AccessDatabaseEngine.exe /passive

    • To install the Microsoft ACE OLEDB Provider 64-bit on a machine running Office 2010 32-bit:

    $> AccessDatabaseEngine_X64.exe /passive



ID: 201000031 Last Updated: 31/10/2020 Revision: 0 Ref:



  1. Active Server Pages,  ,
  2. ASP Overview,  ,
  3. ASP Best Practices,  ,
  4. ASP Built-in Objects,  ,
  5. Response Object,  ,
  6. Request Object,  ,
  7. Server Object (IIS),  ,
  8. Application Object (IIS),  ,
  9. Session Object (IIS),  ,
  10. ASPError Object,  ,
  11. ObjectContext Object (IIS),  ,
  12. Debugging Global.asa Files,  ,
  13. How to: Debug Global.asa files,  ,
  14. Calling COM Components from ASP Pages,  ,
  15. IIS ASP Scripting Reference,  ,
  16. ASP Keywords,  ,
  17. Creating Simple ASP Pages,  ,
  18. Including Files in ASP Applications,  ,
  19. ASP Overview,  ,
  20. FileSystemObject Object,  ,
  21.,  , ADO Object Model
  22. ADO Fundamentals,  ,

Home 5






Hobbies 8


Chinese 1097

English 337

Reference 67


Hardware 151


Application 202

Digitization 25

Latex 10

Manim 159

Numeric 19


Web 285

Unicode 494


CSS 59


OS 391

DeskTop 7

Python 37



Formulas 8

Algebra 29

Number Theory 206

Trigonometry 18

Geometry 18

Calculus 67

Complex Analysis 21


Tables 8


Mechanics 1

Rigid Bodies

Statics 92

Dynamics 37

Fluid 5

Fluid Kinematics 5


Process Control 1

Acoustics 19

FiniteElement 2

Natural Sciences

Electric 27

Biology 1

Geography 1

Copyright © 2000-2021 Sideway . All rights reserved Disclaimers last modified on 06 September 2019