Sideway
output.to from Sideway



Draft for Information Only

Content

  ADO Connection
 ConnectionString of a Connection
  Formating Rules of ConnectionString
  Microsoft JET OLE DB Provider on 64 bit systems
  Microsoft OLE DB Provider on both 32/64 bit systems
  Downloads of Microsoft Data Access Components

ADO Connection

In ASP, the connection of an application to a database or a data file is bridged by the ActiveX Data Objects Component (ADO) throught utilizing a provider to do the job. When creating a connection instance to a data source, parameter "ConnectionString" is used to specify the string value of the connection information.

image

ConnectionString of a Connection

The parameter "ConnectionString" is also defined as the property of a connection object which can be used to set and return the value of ConnectionString. The optional parameter "ConnectionString" is a series of argument = value statements separated by semicolons. Although ADO only supports five types of arguments, any other arguments will also be passed to the provider directly by the ADO without carrying out any process. The five valid arguments of parameter "ConnectionString" or the "ConnectionString Property" can be

Argument Description
Provider= To specify the name of a provider to use for the connection
File Name= To specify the name of a provider-specific file, e.g. a persisted data source object, containing preset connection information.
Remote Provider= To specify the name of a provider to use for the connection when opening a client-side connection for Remote Data Service only.
Remote Server= To specify the path name of the server to use for the connection when opening a client-side connection for Remote Data Service only.
URL= To specify an absolute URL as the connection string to identify a resource, such as a file or directory, for the connection.e

Formating Rules of ConnectionString

Source: https://www.connectionstrings.com/formating-rules-for-connection-strings/

  • All blank characters, except those placed within a value or within quotation marks, are ignored
  • Blank characters will though affect connection pooling mechanism, pooled connections must have the exact same connection string
  • If a semicolon (;) is part of a value it must be delimited by quotation marks (")
  • Use a single-quote (') if the value begins with a double-quote (")
  • Conversely, use the double quote (") if the value begins with a single quote (')
  • No escape sequences are supported
  • The value type is not relevant
  • Names are case iNsEnSiTiVe
  • If a KEYWORD=VALUE pair occurs more than once in the connection string, the value associated with the last occurrence is used
  • However, if the provider keyword occurs multiple times in the string, the first occurrence is used.
  • If a keyword contains an equal sign (=), it must be preceded by an additional equal sign to indicate that it is part of the keyword.
  • If a value has preceding or trailing spaces it must be enclosed in single- or double quotes, ie Keyword=" value ", else the spaces are removed.

Microsoft JET OLE DB Provider on 64 bit systems

The Microsoft OLE DB Provider for JET and the JET ODBC driver are available in 32-bit versions only. Althogh web pages can be run on 32/64 bit systems, an application with JET driver can't be run on 64 bit systems because there is no corresponding JET driver on 64 bit systems.

Ways to resolve the problems are

  • Run the application using JET driver (in 32-bit only) in WoW64 subsystem to emulate 32-bit mode on 64 bit systems.
  • Configure the web sites application pool of IIS (e.g. IIS 7)  to run application in 32-bit mode.
  • Change the driver of Microsoft OLE DB Provider of the application from JET driver to ACE driver, which are available in both 32-bit and 64-bit versions. The suggested solution is to use the drivers of SQL Server Express Edition as a general replacement for JET driver.

Microsoft OLE DB Provider on both 32/64 bit systems

The Microsoft JET OLEDB Provider with only 32-bit driver is depricated by the Microsoft ACE OLEDB Providers with both 32-bit and 64-bit drivers.

Downloads of Microsoft Data Access Components


©sideway
close

References

  1. Active Server Pages, http://msdn.microsoft.com/en-us/library/aa286483.aspx, updated 20Dec2012
  2. ASP Overview, http://msdn.microsoft.com/en-us/library/ms524929%28v=vs.90%29.aspx, updated 21Dec2012
  3. ASP Best Practices, http://technet.microsoft.com/en-us/library/cc939157.aspx, updated 15Apr2013
  4. ASP Built-in Objects, http://msdn.microsoft.com/en-us/library/ie/ms524716(v=vs.90).aspx, updated 20Dec2012
  5. Response Object, http://msdn.microsoft.com/en-us/library/ms525405(v=vs.90).aspx, updated 20Dec2012
  6. Request Object, http://msdn.microsoft.com/en-us/library/ms524948(v=vs.90).aspx, updated 20Dec2012
  7. Server Object (IIS), http://msdn.microsoft.com/en-us/library/ms525541(v=vs.90).aspx, updated 20Dec2012
  8. Application Object (IIS), http://msdn.microsoft.com/en-us/library/ms525360(v=vs.90).aspx, updated 20Dec2012
  9. Session Object (IIS), http://msdn.microsoft.com/en-us/library/ms524319(8v=vs.90).aspx, updated 20Dec2012
  10. ASPError Object, http://msdn.microsoft.com/en-us/library/ms524942(v=vs.90).aspx, updated 20Dec2012
  11. ObjectContext Object (IIS), http://msdn.microsoft.com/en-us/library/ms525667(v=vs.90).aspx, updated 20Dec2012
  12. Debugging Global.asa Files, http://msdn.microsoft.com/en-us/library/aa291249(v=vs.71).aspx, updated 15Apr2013
  13. How to: Debug Global.asa files, http://msdn.microsoft.com/en-us/library/ms241868(v=vs.80).aspx, updated 15Apr2013
  14. Calling COM Components from ASP Pages, http://msdn.microsoft.com/en-us/library/ms524620(v=VS.90).aspx, updated 15Apr2013
  15. IIS ASP Scripting Reference, http://msdn.microsoft.com/en-us/library/ms524664(v=vs.90).aspx, updated 15Apr2013
  16. ASP Keywords, http://msdn.microsoft.com/en-us/library/ms524672(v=vs.90).aspx, updated 15Apr2013
  17. Creating Simple ASP Pages, http://msdn.microsoft.com/en-us/library/ms524741(v=vs.90).aspx, updated 15Apr2013
  18. Including Files in ASP Applications, http://msdn.microsoft.com/en-us/library/ms524876(v=vs.90).aspx, updated 15Apr2013
  19. ASP Overview, http://msdn.microsoft.com/en-us/library/ms524929(v=vs.90).aspx, updated 15Apr2013
  20. FileSystemObject Object, http://msdn.microsoft.com/en-us/library/z9ty6h50(v=vs.84).aspx, updated 14Mayr2013
  21. http://msdn.microsoft.com/en-us/library/windows/desktop/ms675944(v=vs.85).aspx, ADO Object Model, updated 15Apr2013
  22. ADO Fundamentals, http://msdn.microsoft.com/en-us/library/windows/desktop/ms680928(v=vs.85).aspx, updated 14Mayr2013
close

ID: 180200015 Last Updated: 2018/2/11 Revision: Ref:

IMAGE

Home (5)

Business

Management

HBR (3)

Information

Recreation

Hobbies (7)

Culture

Chinese (1097)

English (336)

Reference (66)

Computer

Hardware (149)

Software

Application (187)

Digitization (24)

Numeric (19)

Programming

Web (644)new

CSS (SC)

ASP.NET (SC)

Regular Expression (SC)

HTML

Knowledge Base

Common Color (SC)

Html Entity (Unicode) (SC)

Html 401 Special (SC)

OS (389)new

MS Windows

Windows10 (SC)

.NET Framework (SC)

DeskTop (7)

Knowledge

Mathematics

Formulas (8)

Number Theory (206)

Algebra (20)

Trigonometry (18)

Geometry (18)

Calculus (67)

Complex Analysis (21)

Engineering

Tables (8)

Mechanical

Mechanics (1)

Rigid Bodies

Statics (92)

Dynamics (37)

Fluid (5)

Fluid Kinematics (5)

Control

Process Control (1)

Acoustics (19)

FiniteElement (2)

Biology (1)

Geography (1)

Latest Updated Links

Copyright © 2000-2019 Sideway . All rights reserved Disclaimers last modified on 10 Feb 2019