adovbs.inc 全文
- <%
- '--------------------------------------------------------------------
- 'MicrosoftADO
- '
- 'Copyright(c)1996-1998MicrosoftCorporation.
- '
- '
- '
- 'ADOconstantsincludefileforVBScript
- '
- '--------------------------------------------------------------------
- '----CursorTypeEnumValues----
- ConstadOpenForwardOnly=0
- ConstadOpenKeyset=1
- ConstadOpenDynamic=2
- ConstadOpenStatic=3
- '----CursorOptionEnumValues----
- ConstadHoldRecords=
- ConstadMovePrevious=
- ConstadAddNew=
- ConstadDelete=
- ConstadUpdate=
- ConstadBookmark=
- ConstadApproxPosition=
- ConstadUpdateBatch=
- ConstadResync=
- ConstadNotify=
- ConstadFind=
- ConstadSeek=
- ConstadIndex=
- '----LockTypeEnumValues----
- ConstadLockReadOnly=1
- ConstadLockPessimistic=2
- ConstadLockOptimistic=3
- ConstadLockBatchOptimistic=4
- '----ExecuteOptionEnumValues----
- ConstadAsyncExecute=
- ConstadAsyncFetch=
- ConstadAsyncFetchNonBlocking=
- ConstadExecuteNoRecords=
- ConstadExecuteStream=
- '----ConnectOptionEnumValues----
- ConstadAsyncConnect=
- '----ObjectStateEnumValues----
- ConstadStateClosed=
- ConstadStateOpen=
- ConstadStateConnecting=
- ConstadStateExecuting=
- ConstadStateFetching=
- '----CursorLocationEnumValues----
- ConstadUseServer=2
- ConstadUseClient=3
- '----DataTypeEnumValues----
- ConstadEmpty=0
- ConstadTinyInt=16
- ConstadSmallInt=2
- ConstadInteger=3
- ConstadBigInt=20
- ConstadUnsignedTinyInt=17
- ConstadUnsignedSmallInt=18
- ConstadUnsignedInt=19
- ConstadUnsignedBigInt=21
- ConstadSingle=4
- ConstadDouble=5
- ConstadCurrency=6
- ConstadDecimal=14
- ConstadNumeric=131
- ConstadBoolean=11
- ConstadError=10
- ConstadUserDefined=132
- ConstadVariant=12
- ConstadIDispatch=9
- ConstadIUnknown=13
- ConstadGUID=72
- ConstadDate=7
- ConstadDBDate=133
- ConstadDBTime=134
- ConstadDBTimeStamp=135
- ConstadBSTR=8
- ConstadChar=129
- ConstadVarChar=200
- ConstadLongVarChar=201
- ConstadWChar=130
- ConstadVarWChar=202
- ConstadLongVarWChar=203
- ConstadBinary=128
- ConstadVarBinary=204
- ConstadLongVarBinary=205
- ConstadChapter=136
- ConstadFileTime=64
- ConstadPropVariant=138
- ConstadVarNumeric=139
- ConstadArray=
- '----FieldAttributeEnumValues----
- ConstadFldMayDefer=
- ConstadFldUpdatable=
- ConstadFldUnknownUpdatable=
- ConstadFldFixed=
- ConstadFldIsNullable=
- ConstadFldMayBeNull=
- ConstadFldLong=
- ConstadFldRowID=
- ConstadFldRowVersion=
- ConstadFldCacheDeferred=
- ConstadFldIsChapter=
- ConstadFldNegativeScale=
- ConstadFldKeyColumn=
- ConstadFldIsRowURL=
- ConstadFldIsDefaultStream=
- ConstadFldIsCollection=
- '----EditModeEnumValues----
- ConstadEditNone=
- ConstadEditInProgress=
- ConstadEditAdd=
- ConstadEditDelete=
- '----RecordStatusEnumValues----
- ConstadRecOK=
- ConstadRecNew=
- ConstadRecModified=
- ConstadRecDeleted=
- ConstadRecUnmodified=
- ConstadRecInvalid=
- ConstadRecMultipleChanges=
- ConstadRecPendingChanges=
- ConstadRecCanceled=
- ConstadRecCantRelease=
- ConstadRecConcurrencyViolation=
- ConstadRecIntegrityViolation=
- ConstadRecMaxChangesExceeded=
- ConstadRecObjectOpen=
- ConstadRecOutOfMemory=
- ConstadRecPermissionDenied=
- ConstadRecSchemaViolation=
- ConstadRecDBDeleted=
- '----GetRowsOptionEnumValues----
- ConstadGetRowsRest=-1
- '----PositionEnumValues----
- ConstadPosUnknown=-1
- ConstadPosBOF=-2
- ConstadPosEOF=-3
- '----BookmarkEnumValues----
- ConstadBookmarkCurrent=0
- ConstadBookmarkFirst=1
- ConstadBookmarkLast=2
- '----MarshalOptionsEnumValues----
- ConstadMarshalAll=0
- ConstadMarshalModifiedOnly=1
- '----AffectEnumValues----
- ConstadAffectCurrent=1
- ConstadAffectGroup=2
- ConstadAffectAllChapters=4
- '----ResyncEnumValues----
- ConstadResyncUnderlyingValues=1
- ConstadResyncAllValues=2
- '----CompareEnumValues----
- ConstadCompareLessThan=0
- ConstadCompareEqual=1
- ConstadCompareGreaterThan=2
- ConstadCompareNotEqual=3
- ConstadCompareNotComparable=4
- '----FilterGroupEnumValues----
- ConstadFilterNone=0
- ConstadFilterPendingRecords=1
- ConstadFilterAffectedRecords=2
- ConstadFilterFetchedRecords=3
- ConstadFilterConflictingRecords=5
- '----SearchDirectionEnumValues----
- ConstadSearchForward=1
- ConstadSearchBackward=-1
- '----PersistFormatEnumValues----
- ConstadPersistADTG=0
- ConstadPersistXML=1
- '----StringFormatEnumValues----
- ConstadClipString=2
- '----ConnectPromptEnumValues----
- ConstadPromptAlways=1
- ConstadPromptComplete=2
- ConstadPromptCompleteRequired=3
- ConstadPromptNever=4
- '----ConnectModeEnumValues----
- ConstadModeUnknown=0
- ConstadModeRead=1
- ConstadModeWrite=2
- ConstadModeReadWrite=3
- ConstadModeShareDenyRead=4
- ConstadModeShareDenyWrite=8
- ConstadModeShareExclusive=
- ConstadModeShareDenyNone=
- ConstadModeRecursive=
- '----RecordCreateOptionsEnumValues----
- ConstadCreateCollection=
- ConstadCreateStructDoc=
- ConstadCreateNonCollection=
- ConstadOpenIfExists=
- ConstadCreateOverwrite=
- ConstadFailIfNotExists=-1
- '----RecordOpenOptionsEnumValues----
- ConstadOpenRecordUnspecified=-1
- ConstadOpenOutput=
- ConstadOpenAsync=
- ConstadDelayFetchStream=
- ConstadDelayFetchFields=
- ConstadOpenExecuteCommand=
- '----IsolationLevelEnumValues----
- ConstadXactUnspecified=
- ConstadXactChaos=
- ConstadXactReadUncommitted=
- ConstadXactBrowse=
- ConstadXactCursorStability=
- ConstadXactReadCommitted=
- ConstadXactRepeatableRead=
- ConstadXactSerializable=
- ConstadXactIsolated=
- '----XactAttributeEnumValues----
- ConstadXactCommitRetaining=
- ConstadXactAbortRetaining=
- '----PropertyAttributesEnumValues----
- ConstadPropNotSupported=
- ConstadPropRequired=
- ConstadPropOptional=
- ConstadPropRead=
- ConstadPropWrite=
- '----ErrorValueEnumValues----
- ConstadErrProviderFailed=
- ConstadErrInvalidArgument=
- ConstadErrOpeningFile=
- ConstadErrReadFile=
- ConstadErrWriteFile=
- ConstadErrNoCurrentRecord=
- ConstadErrIllegalOperation=
- ConstadErrCantChangeProvider=
- ConstadErrInTransaction=
- ConstadErrFeatureNotAvailable=
- ConstadErrItemNotFound=
- ConstadErrObjectInCollection=
- ConstadErrObjectNotSet=
- ConstadErrDataConversion=
- ConstadErrObjectClosed=
- ConstadErrObjectOpen=
- ConstadErrProviderNotFound=
- ConstadErrBoundToCommand=
- ConstadErrInvalidParamInfo=
- ConstadErrInvalidConnection=
- ConstadErrNotReentrant=
- ConstadErrStillExecuting=
- ConstadErrOperationCancelled=
- ConstadErrStillConnecting=
- ConstadErrInvalidTransaction=
- ConstadErrUnsafeOperation=
- ConstadwrnSecurityDialog=
- ConstadwrnSecurityDialogHeader=
- ConstadErrIntegrityViolation=
- ConstadErrPermissionDenied=
- ConstadErrDataOverflow=
- ConstadErrSchemaViolation=
- ConstadErrSignMismatch=
- ConstadErrCantConvertvalue=
- ConstadErrCantCreate=
- ConstadErrColumnNotOnThisRow=
- ConstadErrURLIntegrViolSetColumns=
- ConstadErrURLDoesNotExist=
- ConstadErrTreePermissionDenied=
- ConstadErrInvalidURL=
- ConstadErrResourceLocked=
- ConstadErrResourceExists=
- ConstadErrCannotComplete=
- ConstadErrVolumeNotFound=
- ConstadErrOutOfSpace=
- ConstadErrResourceOutOfScope=
- ConstadErrUnavailable=
- ConstadErrURLNamedRowDoesNotExist=
- ConstadErrDelResOutOfScope=
- ConstadErrPropInvalidColumn=
- ConstadErrPropInvalidOption=
- ConstadErrPropInvalidValue=
- ConstadErrPropConflicting=
- ConstadErrPropNotAllSettable=
- ConstadErrPropNotSet=
- ConstadErrPropNotSettable=
- ConstadErrPropNotSupported=
- ConstadErrCatalogNotSet=
- ConstadErrCantChangeConnection=
- ConstadErrFieldsUpdateFailed=
- ConstadErrDenyNotSupported=
- ConstadErrDenyTypeNotSupported=
- '----ParameterAttributesEnumValues----
- ConstadParamSigned=
- ConstadParamNullable=
- ConstadParamLong=
- '----ParameterDirectionEnumValues----
- ConstadParamUnknown=
- ConstadParamInput=
- ConstadParamOutput=
- ConstadParamInputOutput=
- ConstadParamReturnValue=
- '----CommandTypeEnumValues----
- ConstadCmdUnknown=
- ConstadCmdText=
- ConstadCmdTable=
- ConstadCmdStoredProc=
- ConstadCmdFile=
- ConstadCmdTableDirect=
- '----EventStatusEnumValues----
- ConstadStatusOK=
- ConstadStatusErrorsOccurred=
- ConstadStatusCantDeny=
- ConstadStatusCancel=
- ConstadStatusUnwantedEvent=
- '----EventReasonEnumValues----
- ConstadRsnAddNew=1
- ConstadRsnDelete=2
- ConstadRsnUpdate=3
- ConstadRsnUndoUpdate=4
- ConstadRsnUndoAddNew=5
- ConstadRsnUndoDelete=6
- ConstadRsnRequery=7
- ConstadRsnResynch=8
- ConstadRsnClose=9
- ConstadRsnMove=10
- ConstadRsnFirstChange=11
- ConstadRsnMoveFirst=12
- ConstadRsnMoveNext=13
- ConstadRsnMovePrevious=14
- ConstadRsnMoveLast=15
- '----SchemaEnumValues----
- ConstadSchemaProviderSpecific=-1
- ConstadSchemaAsserts=0
- ConstadSchemaCatalogs=1
- ConstadSchemaCharacterSets=2
- ConstadSchemaCollations=3
- ConstadSchemaColumns=4
- ConstadSchemaCheckConstraints=5
- ConstadSchemaConstraintColumnUsage=6
- ConstadSchemaConstraintTableUsage=7
- ConstadSchemaKeyColumnUsage=8
- ConstadSchemaReferentialConstraints=9
- ConstadSchemaTableConstraints=10
- ConstadSchemaColumnsDomainUsage=11
- ConstadSchemaIndexes=12
- ConstadSchemaColumnPrivileges=13
- ConstadSchemaTablePrivileges=14
- ConstadSchemaUsagePrivileges=15
- ConstadSchemaProcedures=16
- ConstadSchemaSchemata=17
- ConstadSchemaSQLLanguages=18
- ConstadSchemaStatistics=19
- ConstadSchemaTables=20
- ConstadSchemaTranslations=21
- ConstadSchemaProviderTypes=22
- ConstadSchemaViews=23
- ConstadSchemaViewColumnUsage=24
- ConstadSchemaViewTableUsage=25
- ConstadSchemaProcedureParameters=26
- ConstadSchemaForeignKeys=27
- ConstadSchemaPrimaryKeys=28
- ConstadSchemaProcedureColumns=29
- ConstadSchemaDBInfoKeywords=30
- ConstadSchemaDBInfoLiterals=31
- ConstadSchemaCubes=32
- ConstadSchemaDimensions=33
- ConstadSchemaHierarchies=34
- ConstadSchemaLevels=35
- ConstadSchemaMeasures=36
- ConstadSchemaProperties=37
- ConstadSchemaMembers=38
- ConstadSchemaTrustees=39
- ConstadSchemaFunctions=40
- ConstadSchemaActions=41
- ConstadSchemaCommands=42
- ConstadSchemaSets=43
- '----FieldStatusEnumValues----
- ConstadFieldOK=0
- ConstadFieldCantConvertValue=2
- ConstadFieldIsNull=3
- ConstadFieldTruncated=4
- ConstadFieldSignMismatch=5
- ConstadFieldDataOverflow=6
- ConstadFieldCantCreate=7
- ConstadFieldUnavailable=8
- ConstadFieldPermissionDenied=9
- ConstadFieldIntegrityViolation=10
- ConstadFieldSchemaViolation=11
- ConstadFieldBadStatus=12
- ConstadFieldDefault=13
- ConstadFieldIgnore=15
- ConstadFieldDoesNotExist=16
- ConstadFieldInvalidURL=17
- ConstadFieldResourceLocked=18
- ConstadFieldResourceExists=19
- ConstadFieldCannotComplete=20
- ConstadFieldVolumeNotFound=21
- ConstadFieldOutOfSpace=22
- ConstadFieldCannotDeleteSource=23
- ConstadFieldReadOnly=24
- ConstadFieldResourceOutOfScope=25
- ConstadFieldAlreadyExists=26
- ConstadFieldPendingInsert=
- ConstadFieldPendingDelete=
- ConstadFieldPendingChange=
- ConstadFieldPendingUnknown=
- ConstadFieldPendingUnknownDelete=
- '----SeekEnumValues----
- ConstadSeekFirstEQ=
- ConstadSeekLastEQ=
- ConstadSeekAfterEQ=
- ConstadSeekAfter=
- ConstadSeekBeforeEQ=
- ConstadSeekBefore=
- '----ADCPROP_UPDATECRITERIA_ENUMValues----
- ConstadCriteriaKey=0
- ConstadCriteriaAllCols=1
- ConstadCriteriaUpdCols=2
- ConstadCriteriaTimeStamp=3
- '----ADCPROP_ASYNCTHREADPRIORITY_ENUMValues----
- ConstadPriorityLowest=1
- ConstadPriorityBelowNormal=2
- ConstadPriorityNormal=3
- ConstadPriorityAboveNormal=4
- ConstadPriorityHighest=5
- '----ADCPROP_AUTORECALC_ENUMValues----
- ConstadRecalcUpFront=0
- ConstadRecalcAlways=1
- '----ADCPROP_UPDATERESYNC_ENUMValues----
- '----ADCPROP_UPDATERESYNC_ENUMValues----
- '----MoveRecordOptionsEnumValues----
- ConstadMoveUnspecified=-1
- ConstadMoveOverWrite=1
- ConstadMoveDontUpdateLinks=2
- ConstadMoveAllowEmulation=4
- '----CopyRecordOptionsEnumValues----
- ConstadCopyUnspecified=-1
- ConstadCopyOverWrite=1
- ConstadCopyAllowEmulation=4
- ConstadCopyNonRecursive=2
- '----StreamTypeEnumValues----
- ConstadTypeBinary=1
- ConstadTypeText=2
- '----LineSeparatorEnumValues----
- ConstadLF=10
- ConstadCR=13
- ConstadCRLF=-1
- '----StreamOpenOptionsEnumValues----
- ConstadOpenStreamUnspecified=-1
- ConstadOpenStreamAsync=1
- ConstadOpenStreamFromRecord=4
- '----StreamWriteEnumValues----
- ConstadWriteChar=0
- ConstadWriteLine=1
- '----SaveOptionsEnumValues----
- ConstadSaveCreateNotExist=1
- ConstadSaveCreateOverWrite=2
- '----FieldEnumValues----
- ConstadDefaultStream=-1
- ConstadRecordURL=-2
- '----StreamReadEnumValues----
- ConstadReadAll=-1
- ConstadReadLine=-2
- '----RecordTypeEnumValues----
- ConstadSimpleRecord=0
- ConstadCollectionRecord=1
- ConstadStructDoc=2
- %>
相关推荐
--#include virtual="/inc/comm/adovbs.inc"-->`这行指令,即可将`.INC` 文件中的内容插入到当前页面中。这里的`virtual`关键字表示引用的是主机的虚拟目录,`/inc/comm/adovbs.inc`即为`.INC` 文件的实际路径。值得...
`adovbs.inc`通常包含了对诸如Connection、Command、Recordset等关键ADO对象的定义,使得开发者无需在每个ASP页面中重复导入这些对象,提高了代码的可读性和维护性。 **ADO对象** 1. **Connection对象**:用于建立...
在描述中提到的"adovbs.inc"文件,是ASP中常用的包含文件,它包含了ADO(ActiveX Data Objects)对象的声明和常用数据库操作的函数或过程。ADO是Microsoft提供的一种用于访问数据的接口,通过它,开发者可以方便地与...
”包含ADO常量表文件adovbs.inc,可从”\Program Files\Common Files\System\ADO”目录下拷贝%> <!–#Include File=”adovbs.inc”–> <%”*建立数据库连接,这里是Oracle8.05数据库 Set conn=Server...
下面我们就通过一个实例来说明这种技术的使用方法(NorthWind.mdb是Microsoft Access97自带的一个数据库,文件adovbs.inc可在C:\Program Files\Common Files\System\ADO下找到): 代码如下: <% @LANGUAGE = ...
首先,我们需要创建ASP页面(如`demo.asp`),并在其中引入ADO(ActiveX Data Objects)的VBScript版本,这可以通过包含`adovbs.inc`文件来实现。`adovbs.inc`包含了ADO的基本组件,如Connection、Command和...
– #include file=”adovbs.inc” –> <% ‘ Constants file included above. ‘ 如果文件存在则删除 Dim objFSO Set objFSO = Server.CreateObject(“Scripting.FileSystemObject”) If objFSO...
--#IncludeFile=”adovbs.inc”-->)来引入adovbs.inc文件,确保可以使用这些常量。这种方法对于ASP初学者来说是一种基本且易于掌握的分页技术,但在数据量大的情况下,使用服务器端的分页技术会更加高效。
经过摸索和实践,我把自己的解决方法,写在下面: 说明: 我的Oracle客户端的版本是 oracle 9i, 安装client...– #include file=”../adovbs.inc” –> <% Dim cnOra Function Connect2OracleServer Dim conSt
`adStateClosed`和`adStateOpen`等常量定义在`adovbs.inc`文件中。 总的来说,这个PPT教学材料覆盖了使用ADO对象与数据库进行交互的基础知识,适合初学者理解ADO的工作原理和使用方式。通过这些步骤,开发者可以...
5. **adovbs.inc**:这通常是一个包含数据库连接和操作相关函数的ASP包含文件。开发者为了代码复用和管理,会将常用的ADO(ActiveX Data Objects)对象和方法封装在这里,如建立数据库连接、执行SQL语句等。 6. **...
4. **adovbs.inc**:这可能是一个包含ADO(ActiveX Data Objects)组件的代码文件,用于在ASP中与数据库进行交互。ADO是微软提供的一套数据库访问接口,可以方便地读写数据库。 5. **MessBook.mdb**:这是一个...
`adovbs.inc`则是一个包含ADO常量和类型定义的VBScript(Visual Basic Scripting Edition)文件,通常用于编写基于脚本的数据库应用程序,它可以帮助开发者在VBScript中更方便地使用ADO。 综上所述,ADO修复脚本是...
`adovbs.inc`文件通常包含了ADO(ActiveX Data Objects)的相关引用,使得ASP可以使用ADO库来访问数据库。在这里,它可能包含了对ADO对象模型的定义,比如`ADODB.Connection`, `ADODB.Recordset`, 和 `ADODB.Command...
此外,还需要一个`adovbs.inc`文件,包含ADO(ActiveX Data Objects)的常量,如`adOpenStatic`,用于数据库连接和操作。 每个ASP文件中的代码会涉及到数据库连接、SQL查询以及HTML和CSS的输出,以呈现论坛界面。...
6. **adovbs.inc**:这很可能是一个包含ADO(ActiveX Data Objects)对象的代码文件。ADO是微软提供的用于访问数据库的标准库,开发者可能在这里定义了连接字符串、记录集对象等,以便在其他ASP文件中方便地进行...
另外,还需要一个包含常量的文件`adovbs.inc`,它定义了诸如`adopenstatic`之类的ADO连接模式常量,用于数据库操作。在ASP代码中,通过`Server.CreateObject`创建ADO对象,如`Connection`和`Recordset`,以执行SQL...