Sideway
output.to from Sideway
`-=[]โŸจโŸฉ\;',./~!@#$%^&*()_+{}|:"<>? ๐‘Ž๐‘๐‘๐‘‘๐‘’๐‘“๐‘”โ„Ž๐‘–๐‘—๐‘˜๐‘™๐‘š๐‘›๐‘œ๐‘๐‘ž๐‘Ÿ๐‘ ๐‘ก๐‘ข๐‘ฃ๐‘ค๐‘ฅ๐‘ฆ๐‘ง ร…โ€‰โˆ’โ€‚ร—โ€ƒโ‹…โˆ“ยฑโˆ˜๊žŠ๏นฆโˆ—โˆ™ โ„ฏ ๐”ธ๐”นโ„‚๐”ป๐”ผ๐”ฝ๐”พโ„๐•€๐•๐•‚๐•ƒ๐•„โ„•๐•†โ„™โ„šโ„๐•Š๐•‹๐•Œ๐•๐•Ž๐•๐•โ„ค๐ด๐ต๐ถ๐ท๐ธ๐น๐บ๐ป๐ผ๐ฝ๐พ๐ฟ๐‘€๐‘๐‘‚๐‘ƒ๐‘„๐‘…๐‘†๐‘‡๐‘ˆ๐‘‰๐‘Š๐‘‹๐‘Œ๐‘ โˆผโˆฝโˆพโ‰โ‰‚โ‰ƒโ‰„โ‰…โ‰†โ‰‡โ‰ˆโ‰‰โ‰Œโ‰โ‰ โ‰ก โ‰คโ‰ฅโ‰ฆโ‰งโ‰จโ‰ฉโ‰ชโ‰ซ โˆˆโˆ‰โˆŠโˆ‹โˆŒโˆ โŠ‚โŠƒโŠ„โŠ…โŠ†โŠ‡ ๐›ผ๐›ฝ๐›พ๐›ฟ๐œ€๐œ๐œ‚๐œƒ๐œ„๐œ…๐œ†๐œ‡๐œˆ๐œ‰๐œŠ๐œ‹๐œŒ๐œŽ๐œ๐œ๐œ‘๐œ’๐œ“๐œ” โˆ€โˆ‚โˆƒโˆ…โฆฐโˆ†โˆ‡โˆŽโˆžโˆโˆดโˆต โˆโˆโˆ‘โ‹€โ‹โ‹‚โ‹ƒ โˆงโˆจโˆฉโˆช โˆซโˆฌโˆญโˆฎโˆฏโˆฐโˆฑโˆฒโˆณ โˆฅโ‹ฎโ‹ฏโ‹ฐโ‹ฑ โ€– โ€ฒ โ€ณ โ€ด โ„ โ— สน สบ โ€ต โ€ถ โ€ท ๏น ๏น‚ ๏นƒ ๏น„ ๏ธน ๏ธบ ๏ธป ๏ธผ ๏ธ— ๏ธ˜ ๏ธฟ ๏น€ ๏ธฝ ๏ธพ ๏น‡ ๏นˆ ๏ธท ๏ธธ โœ   โ   โŽด  โŽต  โž   โŸ   โ    โก โ†โ†‘โ†’โ†“โ†คโ†ฆโ†ฅโ†งโ†”โ†•โ†–โ†—โ†˜โ†™โ–ฒโ–ผโ—€โ–ถโ†บโ†ปโŸฒโŸณ โ†ผโ†ฝโ†พโ†ฟโ‡€โ‡โ‡‚โ‡ƒโ‡„โ‡…โ‡†โ‡‡ โ‡โ‡‘โ‡’โ‡“โ‡”โ‡Œโ‡โ‡โ‡•โ‡–โ‡—โ‡˜โ‡™โ‡™โ‡ณโฅขโฅฃโฅคโฅฅโฅฆโฅงโฅจโฅฉโฅชโฅซโฅฌโฅญโฅฎโฅฏ
Draft for Information Only

Content

Connection Object
โ€ƒSyntax
โ€ƒโ€ƒโ€ƒ Parameters
โ€ƒMethods
โ€ƒProperties
โ€ƒEvents
โ€ƒRemarks

Connection Object

Connection object of ActiveX Data Object component is related to manipulate the connection session with a data source. The Connection Object should be created by a Server.CreateObject Method such that the Web server can make a connection with a data source.

Although an instance of the Connection object of the ADODB Library has higher hierarchical relationship with other ADO objects in the ADODB Library, ADO objects can also be created outside the scope of the ADO hierarchy. When a Recordset or Command object is created, it is not necessary to create a connection first, because the Recordset or Command object is just a place holder. When a Recordset or Command object is opened, it is also not necessary to create a connection first, because a Connection object is automatically created behind the scenes according to the specified ConnectionString in the line of code. 

Syntax

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

Parameters

ConnName

The parameter "ConnName" is the name assigned to the instance of the Connection object of the ADODB Library created by the call using the Server.CreateObject.

ADODB.Connection

The parameter "ADODB.Connection" is used to specified the name of the type of ADO DataBase object included in the ADODB Library to be created by the Server.CreateObject Method.

Methods

Method Description
BeginTrans to begin a new transaction
Cancel to cancel the execution of a pending asynchronous method call.
Close to close an open object and any dependent objects
CommitTrans to end the current transaction and save any changes. A new tracnsaction may be started also.
Execute to execute the specified command text of query, SQL statement, stored procedure or provider-specific text.
Open to open an connection instance to a data source
OpenSchema to obtain the database schema information from the provider
RollbackTrans to end the transaction and cancel any changes made during the current transaction. A new tracnsaction may be started also.

Properties

Property Description
Attributes to set or return the value of XactAttributeEnum attribute for a Connection object
CommandTimeout to set or return the waiting time for executing a command before terminating and generating an error.
ConnectionString to set or return the details used for creating a connection instance to a data source 
ConnectionTimeout to set or return the waiting time for establishing a connection before terminating and generating an error.
CursorLocation to set or return the location of the cursor service
DefaultDatabase to set or return the default database name for a connection object
Errors to contains all the error objects created in response to a single provider-related failure.
IsolationLevel to set or return the level of isolation for a connection object
Mode to set or return the available accessing permissions for modifying data in a connection
Properties to contains all the property objects for a specific instance of a connection object
Provider to set or return the provider name of a connection object
State to return a value to indicate the state of connection is open or closed
Version to return the ADO version number

Events

Event Description
   

Remarks

The methods and properties of Connection object can be grouped into

  •  Connection Information 
    • Connection Details: ConnectionString; DefaultDatabase; Errors; Properties; State
    • Connection Provider Information: OpenSchema; Provider; Version
  •  Connection Manipulation 
    • Connection Transaction: BeginTrans; CommitTrans; RollbackTrans; Attributes
    • Connection Object Manipulation: Cancel; Close; Execute; Open
    • Connection Control: CommandTimeout; ConnectionTimeout; CursorLocation; IsolationLevel; Mode
ยฉsideway

ID: 130500016 Last Updated: 9/28/2013 Revision: 1 Ref:

close

References

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

Home 5

Business

Management

HBR 3

Information

Recreation

Hobbies 9

Culture

Chinese 1097

English 339

Travel 38

Reference 79

Hardware 55

Computer

Hardware 259

Software

Application 213

Digitization 37

Latex 52

Manim 205

KB 1

Numeric 19

Programming

Web 290new

Unicode 504

HTML 66new

Common Color 1new

Html Entity (Unicode) 1new

Html 401 Special 1

CSS 65new

Selector 1

SVG 46

ASP.NET 270

OS 447new

MS Windows

Windows10 1new

.NET Framework 1

DeskTop 7

Python 72

Knowledge

Mathematics

Formulas 8

Set 1

Logic 1

Algebra 84

Number Theory 207new

Trigonometry 31

Geometry 34

Coordinate Geometry 2

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

Natural Sciences

Matter 1

Electric 27

Biology 1

Geography 1

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