Content


    ADO.NET Connection String
 
        .NET Data Provider
 .NET Connection
 
        .NET Connection String
 
        Common Problems
 Source/Reference

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 https://www.microsoft.com/en-us/download/details.aspx?id=13255
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

Source/Reference

./sideway/defaultpage.asp?qno=180200015=180

©sideway

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

References

Active Server Pages, , http://msdn.microsoft.com/en-us/library/aa286483.aspx
ASP Overview, , http://msdn.microsoft.com/en-us/library/ms524929%28v=vs.90%29.aspx
ASP Best Practices, , http://technet.microsoft.com/en-us/library/cc939157.aspx
ASP Built-in Objects, , http://msdn.microsoft.com/en-us/library/ie/ms524716(v=vs.90).aspx
Response Object, , http://msdn.microsoft.com/en-us/library/ms525405(v=vs.90).aspx
Request Object, , http://msdn.microsoft.com/en-us/library/ms524948(v=vs.90).aspx
Server Object (IIS), , http://msdn.microsoft.com/en-us/library/ms525541(v=vs.90).aspx
Application Object (IIS), , http://msdn.microsoft.com/en-us/library/ms525360(v=vs.90).aspx
Session Object (IIS), , http://msdn.microsoft.com/en-us/library/ms524319(8v=vs.90).aspx
ASPError Object, , http://msdn.microsoft.com/en-us/library/ms524942(v=vs.90).aspx
ObjectContext Object (IIS), , http://msdn.microsoft.com/en-us/library/ms525667(v=vs.90).aspx
Debugging Global.asa Files, , http://msdn.microsoft.com/en-us/library/aa291249(v=vs.71).aspx
How to: Debug Global.asa files, , http://msdn.microsoft.com/en-us/library/ms241868(v=vs.80).aspx
Calling COM Components from ASP Pages, , http://msdn.microsoft.com/en-us/library/ms524620(v=VS.90).aspx
IIS ASP Scripting Reference, , http://msdn.microsoft.com/en-us/library/ms524664(v=vs.90).aspx
ASP Keywords, , http://msdn.microsoft.com/en-us/library/ms524672(v=vs.90).aspx
Creating Simple ASP Pages, , http://msdn.microsoft.com/en-us/library/ms524741(v=vs.90).aspx
Including Files in ASP Applications, , http://msdn.microsoft.com/en-us/library/ms524876(v=vs.90).aspx
ASP Overview, , http://msdn.microsoft.com/en-us/library/ms524929(v=vs.90).aspx
FileSystemObject Object, , http://msdn.microsoft.com/en-us/library/z9ty6h50(v=vs.84).aspx
http://msdn.microsoft.com/en-us/library/windows/desktop/ms675944(v=vs.85).aspx, , ADO Object Model
ADO Fundamentals, , http://msdn.microsoft.com/en-us/library/windows/desktop/ms680928(v=vs.85).aspx