ADO對(duì)象模型的概要

1/1ADO對(duì)象模型的概要////////////////////////////////////////////////////////////ADO對(duì)象模型的概要下圖是ADO模型中的對(duì)象示意圖，白色的是Collection。

ADOObjectSummaryObjectDescriptionCommandDefinesaspecificcommandthatyouintendtoexecuteagainstadatasource.ConnectionRepresentsanopenconnectiontoadatasource.DataControl(RDS)BindsadataqueryRecordsettooneormorecontrols(forexample,atextbox,gridcontrol,orcombobox)todisplaytheRecordsetdataonaWebpage.DataFactory(RDSServer)Implementsmethodsthatprovideread/writedataaccesstospecifieddatasourcesforclient-sideapplications.DataSpace(RDS)Createsclient-sideproxiestocustombusinessobjectslocatedonthemiddletier.ErrorContainsdetailsaboutdataaccesserrorsthatpertaintoasingleoperationinvolvingtheprovider.FieldRepresentsacolumnofdatawithacommondatatype.ParameterRepresentsaparameterorargumentassociatedwithaCommandobjectbasedonaparameterizedqueryorstoredprocedure.PropertyRepresentsadynamiccharacteristicofanADOobjectthatisdefinedbytheprovider.RecordRepresentsarowofaRecordset,oradirectoryorfileinafilesystem.RecordsetRepresentstheentiresetofrecordsfromabasetableortheresultsofanexecutedcommand.Atanytime,theRecordsetobjectreferstoonlyasinglerecordwithinthesetasthecurrentrecord.StreamRepresentsabinarystreamofdata.ADOCollectionSummaryCollectionDescriptionErrorsContainsalltheErrorobjectscreatedinresponsetoasingleprovider-relatedfailure.FieldsContainsalltheFieldobjectsofaRecordsetobject.ParametersContainsalltheParameterobjectsofaCommandobject.PropertiesContainsallthePropertyobjectsforaspecificinstanceofanobject.ADOPropertySummaryPropertyDescriptionAbsolutePageIndicatesonwhichpagethecurrentrecordresides.AbsolutePositionIndicatestheordinalpositionofaRecordsetobject’scurrentrecord.ActiveCommandIndicatestheCommandobjectthatcreatedtheassociatedRecordsetobject.ActiveConnectionIndicatestowhichConnectionobjectthespecifiedCommand,Recordset,orRecordobjectcurrentlybelongs.ActualSizeIndicatestheactuallengthofafield’svalue.AttributesIndicatesoneormorecharacteristicsofanobject.BOFandEOFBOFindicatesthatthecurrentrecordpositionisbeforethefirstrecordinaRecordsetobject.EOFindicatesthatthecurrentrecordpositionisafterthelastrecordinaRecordsetobject.BookmarkIndicatesabookmarkthatuniquelyidentifiesthecurrentrecordinaRecordsetobjectorsetsthecurrentrecordinaRecordsetobjecttotherecordidentifiedbyavalidbookmark.CacheSizeIndicatesthenumberofrecordsfromaRecordsetobjectthatarecachedlocallyinmemory.CharSetIndicatesthecharactersetintowhichthecontentsofatextStreamshouldbetranslated.CommandTextIndicatesthetextofacommandtobeissuedagainstaprovider.CommandTimeoutIndicateshowlongtowaitwhileexecutingacommandbeforeterminatingtheattemptandgeneratinganerror.CommandTypeIndicatesthetypeofaCommandobject.Connect(RDS)Indicatesthedatabasenamefromwhichthequeryandupdateoperationsarerun.ConnectionStringPropertyIndicatestheinformationusedtoestablishaconnectiontoadatasource.ConnectionTimeoutIndicateshowlongtowaitwhileestablishingaconnectionbeforeterminatingtheattemptandgeneratinganerror.CountIndicatesthenumberofobjectsinacollection.CursorLocationIndicatesthelocationofthecursorservice.CursorTypeIndicatesthetypeofcursorusedinaRecordsetobject.DataMemberIndicatesthenameofthedatamemberthatwillberetrievedfromtheobjectreferencedbytheDataSourceproperty.DataSourceIndicatesanobjectthatcontainsdatatoberepresentedasaRecordsetobject.DefaultDatabaseIndicatesthedefaultdatabaseforaConnectionobject.DefinedSizeIndicatesthedatacapacityofaFieldobject.DescriptionDescribesanErrorobject.DirectionIndicateswhethertheParameterrepresentsaninputparameter,anoutputparameter,orboth,oriftheparameteristhereturnvaluefromastoredprocedure.EditModeIndicatestheeditingstatusofthecurrentrecord.EOSIndicateswhetherthecurrentpositionisattheendofthestream.ExecuteOptions(RDS)Indicateswhetherasynchronousexecutionisenabled.FetchOptions(RDS)Indicatesthetypeofasynchronousfetching.FilterIndicatesafilterfordatainaRecordset.FilterColumn(RDS)Indicatesthecolumnonwhichtoevaluatethefiltercriteria.FilterCriterion(RDS)Indicatestheevaluationoperatortouseinthefiltervalue.FilterValue(RDS)Indicatesthevaluetofilterrecords.Handler(RDS)Indicatesthenameofaserver-sidecustomizationprogram(handler)thatextendsthefunctionalityoftheRDSServer.DataFactory,andanyparametersusedbythehandler.HelpContextandHelpFileIndicatesthehelpfileandtopicassociatedwithanErrorobject.HelpContextIDreturnsacontextID,asaLongvalue,foratopicinaHelpfile.HelpFilereturnsaStringvaluethatevaluatestoafullyresolvedpathtoaHelpfile.IndexIndicatesthenameoftheindexcurrentlyineffectforaRecordsetobject.InternetTimeout(RDS)Indicatesthenumberofmillisecondstowaitbeforearequesttimesout.IsolationLevelIndicatesthelevelofisolationforaConnectionobject.ItemIndicatesaspecificmemberofacollection,bynameorordinalnumber.LineSeparatorIndicatesthebinarycharactertobeusedasthelineseparatorintextStreamobjects.LockTypeIndicatesthetypeoflocksplacedonrecordsduringediting.MarshalOptionsIndicateswhichrecordsaretobemarshaledbacktotheserver.MaxRecordsIndicatesthemaximumnumberofrecordstoreturntoaRecordsetfromaquery.ModeIndicatestheavailablepermissionsformodifyingdatainaConnection,Record,orStreamobject.NameIndicatesthenameofanobject.NativeErrorIndicatestheprovider-specificerrorcodeforagivenErrorobject.NumberIndicatesthenumberthatuniquelyidentifiesanErrorobject.NumericScaleIndicatesthescaleofnumericvaluesinaParameterorFieldobject.OriginalValueIndicatesthevalueofaFieldthatexistedintherecordbeforeanychangesweremade.PageCountIndicateshowmanypagesofdatatheRecordsetobjectcontains.PageSizeIndicateshowmanyrecordsconstituteonepageintheRecordset.ParentURLIndicatesanabsoluteURLstringthatpointstotheparentRecordofthecurrentRecordobject.PositionIndicatesthecurrentpositionwithinaStreamobject.PrecisionIndicatesthedegreeofprecisionfornumericvaluesinaParameterobjectorfornumericFieldobjects.PreparedIndicateswhethertosaveacompiledversionofacommandbeforeexecution.ProviderIndicatesthenameoftheproviderforaConnectionobject.ReadyState(RDS)IndicatestheprogressofaDataControlobjectasitfetchesdataintoitsRecordsetobject.RecordCountIndicatesthenumberofrecordsinaRecordsetobject.RecordsetandSourceRecordset(RDS)IndicatestheRecordsetobjectreturnedfromacustombusinessobject.RecordTypeIndicatesthetypeofRecordobject.Server(RDS)IndicatestheInternetInformationServices(IIS)nameandcommunicationprotocol.SizeIndicatesthemaximumsize,inbytesorcharacters,ofaParameterobject.Size(ADOStream)Indicatesthetotalsizeofthestreaminnumberofbytes.SortIndicatesoneormorefieldnamesonwhichtheRecordsetissorted,andwhethereachfieldissortedinascendingordescendingorder.SortColumn(RDS)Indicatesbywhichcolumntosorttherecords.SortDirection(RDS)Indicateswhetherasortorderisascendingordescending.Source(ADOError)Indicatesthenameoftheobjectorapplicationthatoriginallygeneratedanerror.Source(ADORecord)IndicatestheentityrepresentedbytheRecordobject.Source(ADORecordset)IndicatesthesourceforthedatainaRecordsetobjectSQL(RDS)IndicatesthequerystringusedtoretrievetheRecordset.SQLStateIndicatestheSQLstateforagivenErrorobject.StateIndicatesforallapplicableobjectswhetherthestateoftheobjectisopenorclosed.Indicatesforallapplicableobjectsexecutinganasynchronousmethod,whetherthecurrentstateoftheobjectisconnecting,executing,orretrievingStatus(ADOField)IndicatesthestatusofaFieldobject.Status(ADORecordset)Indicatesthestatusofthecurrentrecordwithrespecttobatchupdatesorotherbulkoperations.StayInSyncIndicates,inahierarchicalRecordsetobject,whetherthereferencetotheunderlyingchildrecords(thatis,thechapter)changeswhentheparentrowpositionchanges.TypeIndicatestheoperationaltypeordatatypeofaParameter,Field,orPropertyobject.Type(ADOStream)IndicatesthetypeofdatacontainedintheStream(binaryortext).UnderlyingValueIndicatesaFieldobject’scurrentvalueinthedatabase.URL(RDS)IndicatesastringthatcontainsarelativeorabsoluteURL.ValueIndicatesthevalueassignedtoaField,Parameter,orPropertyobject.VersionIndicatestheADOversionnumber.ADODynamicPropertySummaryDynamicpropertiescanbeaddedtothePropertiescollectionsoftheConnection,Command,orRecordsetobjects.Thesourceforthesepropertiesiseitheradataprovider,suchastheOLEDBProviderforSQLServer,oraserviceprovider,suchastheMicrosoftCursorServiceforOLEDB.Refertotheappropriatedataproviderorserviceproviderdocumentationformoreinformationaboutaspecificdynamicproperty.TheADODynamicPropertyIndexprovidesacross-referencebetweentheADOandOLEDBnamesforeachstandardOLEDBproviderdynamicproperty.Thefollowingdynamicpropertiesareofspecialinterest,andarealsodocumentedinthesourcesmentionedabove.SpecialfunctionalitywithADOisdocumentedintheADOhelptopicslistedbelow.PropertyDescriptionOptimizeSpecifieswhetheranindexshouldbecreatedonthisfield.PromptSpecifieswhethertheOLEDBprovidershouldprompttheuserforinitializationinformation.ReshapeNameSpecifiesanamefortheRecordsetobject.ResyncCommandSpecifiesauser-suppliedcommandstringthattheResyncmethodissuestorefreshthedatainthetablenamedintheUniqueTabledynamicproperty.UniqueTable,UniqueSchema,UniqueCatalogUniqueTablespecifiesthenameofthebasetableuponwhichupdates,insertions,anddeletionsareallowed.UniqueSchemaspecifiestheschema,ornameoftheownerofthetable.UniqueCatalogspecifiesthecatalog,ornameofthedatabasecontainingthetable.UpdateResyncSpecifieswhethertheUpdateBatchmethodisfollowedbyanimplicitResyncmethodoperation,andifso,thescopeofthatoperation.ADOMethodSummaryMethodDescriptionAddNewCreatesanewrecordforanupdatableRecordsetobject.AppendAppendsanobjecttoacollection.IfthecollectionisFields,anewFieldobjectmaybecreatedbeforeitisappendedtothecollection.AppendChunkAppendsdatatoalargetextorbinarydataField,ortoaParameterobject.BeginTrans,CommitTrans,andRollbackTransManagestransactionprocessingwithinaConnectionobjectasfollows:BeginTransBeginsanewtransaction.CommitTransSavesanychangesandendsthecurrenttransaction.Itmayalsostartanewtransaction.RollbackTransCancelsanychangesandendsthecurrenttransaction.Itmayalsostartanewtransaction.Cancel(ADO)Cancelsexecutionofapending,asynchronousmethodcall.Cancel(RDS)Cancelsexecutionofapending,asynchronousmethodcall.CancelBatchCancelsapendingbatchupdate.CancelUpdate(ADO)CancelsanychangesmadetothecurrentornewrowofaRecordsetobject,ortheFieldscollectionofaRecordobject,beforecallingtheUpdatemethod.CancelUpdate(RDS)CancelsanychangesmadetothecurrentornewrowofaRecordsetobject.ClearRemovesalltheErrorobjectsfromtheErrorscollection.CloneCreatesaduplicateRecordsetobjectfromanexistingRecordsetobject.Optionally,specifiesthatthecloneberead-only.CloseClosesanopenobjectandanydependentobjects.CompareBookmarksComparestwobookmarksandreturnsanindicationoftheirrelativevalues.ConvertToString(RDS)ConvertsaRecordsettoaMIMEstringthatrepresentstherecordsetdata.CopyRecordCopiesafileordirectory,anditscontents,toanotherlocation.CopyToCopiesthespecifiednumberofcharactersorbytes(dependingonType)intheStreamtoanotherStreamobject.CreateObject(RDS)Createstheproxyforthetargetbusinessobjectandreturnsapointertoit.CreateParameterCreatesanewParameterobjectwiththespecifiedproperties.CreateRecordset(RDS)Createsanempty,disconnectedRecordset.Delete(ADOParametersCollection)DeletesanobjectfromtheParameterscollection.Delete(ADOFieldsCollection)DeletesanobjectfromtheFieldscollection.Delete(ADORecordset)Deletesthecurrentrecordoragroupofrecords.DeleteRecordDeletesafileordirectory,andallitssubdirectories.Execute(ADOCommand)Executesthequery,SQLstatement,orstoredprocedurespecifiedintheCommandTextproperty.Execute(ADOConnection)Executesthespecifiedquery,SQLstatement,storedprocedure,orprovider-specifictext.FindSearchesaRecordsetfortherowthatsatisfiesthespecifiedcriteria.FlushForcesthecontentsoftheStreamremainingintheADObuffertotheunderlyingobjectwithwhichtheStreamisassociated.GetChildrenReturnsaRecordsetwhoserowsrepresentthefilesandsubdirectoriesinthedirectoryrepresentedbythisRecord.GetChunkReturnsall,oraportionof,thecontentsofalargetextorbinarydataFieldobject.GetRowsRetrievesmultiplerecordsofaRecordsetobjectintoanarray.GetStringReturnstheRecordsetasastring.LoadFromFileLoadsthecontentsofanexistingfileintoaStream.MoveMovesthepositionofthecurrentrecordinaRecordsetobject.MoveFirst,MoveLast,MoveNext,andMovePrevious(ADO)Movestothefirst,last,next,orpreviousrecordinaspecifiedRecordsetobjectandmakesthatrecordthecurrentrecord.MoveFirst,MoveLast,MoveNext,MovePrevious(RDS)Movestothefirst,last,next,orpreviousrecordinaspecifiedRecordsetobject.MoveRecordMovesafile,oradirectoryanditscontents,toanotherlocation.NextRecordsetClearsthecurrentRecordsetobjectandreturnsthenextRecordsetbyadvancingthroughaseriesofcommands.Open(ADOConnection)Opensaconnectiontoadatasource.Open(ADORecord)OpensanexistingRecordobject,orcreatesanewfileordirectory.Open(ADORecordset)Opensacursor.Open(ADOStream)OpensaStreamobjecttomanipulatestreamsofbinaryortextdata.OpenSchemaObtainsdatabaseschemainformationfromtheprovider.Query(RDS)UsesavalidSQLquerystringtoreturnaRecordset.ReadReadsaspecifiednumberofbytesfromaStreamobject.ReadTextReadsaspecifiednumberofcharactersfromatextStreamobject.Refresh(ADO)Updatestheobjectsinacollectiontoreflectobjectsavailablefrom,andspecificto,theprovider.Refresh(RDS)RequeriesthedatasourcespecifiedintheConnectpropertyandupdatesthequeryresults.RequeryUpdatesthedatainaRecordsetobjectbyre-executingthequeryonwhichtheobjectisbased.Reset(RDS)Executesthesortorfilteronaclient-sideRecordset,basedonthespecifiedsortandfilterproperties.ResyncRefreshesthedatainthecurrentRecordsetobject,orFieldscollectionofaRecordobject,fromtheunderlyingdatabase.SaveSavestheRecordsetinafileorStreamobject.SaveToFileSavesthebinarycontentsofaStreamtoafile.SeekSearchestheindexofaRecordsettoquicklylocatetherowthatmatchesthespecifiedvalues,andchangesthecurrentrowpositiontothatrow.SetEOSSetsthepositionthatistheendofthestream.SkipLineSkipsoneentirelinewhenreadingatextstream.SubmitChanges(RDS)SubmitspendingchangesofthelocallycachedandupdatableRecordsettothedatasourcespecifiedintheConnectproperty.SupportsDetermineswhetheraspecifiedRecordsetobjectsupportsaparticulartypeoffunctionality.UpdateSavesanychangesyoumaketothecurrentrowofaRecordsetobject,ortheFieldscollectionofaRecordobject.UpdateBatchWritesallpendingbatchupdatestodisk.WriteWritesbinarydatatoaStreamobject.WriteTextWritesaspecifiedtextstringtoaStreamobject.ADOEventSummaryEventDescriptionBeginTransCompleteCalledaftertheBeginTransoperation.CommitTransCompleteCalledaftertheCommitTransoperation.ConnectCompleteCalledafteraconnectionstarts.DisconnectCalledafteraconnectionends.EndOfRecordsetCalledwhenthereisanattempttomovetoarowpasttheendoftheRecordset.ExecuteCompleteCalledafteracommandhasfinishedexecuting.FetchCompleteCalledafteralltherecordsinalengthyasynchronousoperationhavebeenretrievedintotheRecordset.FetchProgressCalledperiodicallyduringalengthyasynchronousoperationtoreporthowmanyrowshavecurrentlybeenretrievedintotheRecordset.FieldChangeCompleteCalledafterthevalueofoneormoreFieldobjectshaschanged.InfoMessageCalledwheneverawarningoccursduringaConnectionEventoperation.MoveCompleteCalledafterthecurrentpositionintheRecordsetchanges.onError(RDS)Calledwheneveranerroroccursduringanoperation.onReadyStateChange(RDS)CalledwheneverthevalueoftheReadyStatepropertychanges.RecordChangeCompleteCalledafteroneormorerecordschange.RecordsetChangeCompleteCalledaftertheRecordsethaschanged.RollbackTransCompleteCalledaftertheRollbackTransoperation.WillChangeFieldCalledbeforeapendingoperationchangesthevalueofoneormoreFieldobjectsintheRecordset.WillChangeRecordCalledbeforeoneormorerecords(rows)intheRecordsetchange.WillChangeRecordsetCalledbeforeapendingoperationchangestheRecordset.WillConnectCalledbeforeaconnectionstarts.WillExecuteCalledjustbeforeapendingcommandexecutesonthisconnectionandaffordstheuseranopportunitytoexamineandmodifythependingexecutionparameters.WillMoveTheWillMoveeventiscalledbeforeapendingoperationchangesthecurrentpositionintheRecordset.ADOEnumeratedConstantSummaryEnumerationDescriptionADCPROP_ASYNCTHREADPRIORITY_ENUMForanRDSRecordsetobject,specifiestheexecutionpriorityoftheasynchronousthreadthatretrievesdata.ADCPROP_AUTORECALC_ENUMSpecifieswhentheMSDataShapeproviderre-calculatesaggregateandcalculatedcolumnsinahierarchicalRecordset.ADCPROP_UPDATECRITERIA_ENUMSpecifieswhichfieldscanbeusedtodetectconflictsduringanoptimisticupdateofarowofthedatasourcewithaRecordsetobject.ADCPROP_UPDATERESYNC_ENUMSpecifieswhethertheUpdateBatchmethodisfollowedbyanimplicitResyncmethodoperationandifso,thescopeofthatoperation.AffectEnumSpecifieswhichrecordsareaffectedbyanoperation.BookmarkEnumSpecifiesabookmarkindicatingwheretheoperationshouldbegin.CommandTypeEnumSpecifieshowacommandargumentshouldbeinterpreted.CompareEnumSpecifiestherelativepositionoftworecordsrepresentedbytheirbookmarks.ConnectModeEnumSpecifiestheavailablepermissionsformodifyingdatainaConnection,openingaRecord,orspecifyingvaluesfortheModepropertyoftheRecordandStreamobjects.ConnectOptionEnumSpecifieswhethertheOpenmethodofaConnectionobjectshouldreturnafter(synchronously)orbefore(asynchronously)theconnectionisestablished.ConnectPromptEnumSpecifieswhetheradialogboxshouldbedisplayedtopromptformissingparameterswhenopeningaconnectiontoanODBCdatasource.CopyRecordOptionsEnumSpecifiesthebehavioroftheCopyRecordmethod.CursorLocationEnumSpecifiesthelocationofthecursorengine.CursorOptionEnumSpecifieswhatfunctionalitytheSupportsmethodshouldtestfor.CursorTypeEnumSpecifiesthetypeofcursorusedinaRecordsetobject.DataTypeEnumSpecifiesthedatatypeofaField,Parameter,orProperty.EditModeEnumSpecifiestheeditingstatusofarecord.ErrorValueEnumSpecifiesthetypeofADOrun-timeerror.EventReasonEnumSpecifiesthereasonthatcausedaneventtooccur.EventStatusEnumSpecifiesthecurrentstatusoftheexecutionofanevent.ExecuteOptionEnumSpecifieshowaprovidershouldexecuteacommand.FieldEnumSpecifiesthespecialfieldsreferencedinaRecordobject’sFieldscollection.FieldAttributeEnumSpecifiesoneormoreattributesofaFieldobject.FilterGroupEnumSpecifiesthegroupofrecordstobefilteredfromaRecordset.GetRowsOptionEnumSpecifieshowmanyrecordstoretrievefromaRecordset.IsolationLevelEnumSpecifiestheleveloftransactionisolationforaConnectionobject.LineSeparatorsEnumSpecifiesthecharacterusedasalineseparatorintextStreamobjects.LockTypeEnumSpecifiesthetypeoflockplacedonrecordsduringediting.MarshalOptionsEnumSpecifieswhichrecordsshouldbereturnedtotheserver.MoveRecordOptionsEnumSpecifiesthebehavioroftheRecordobjectMoveRecordmethod.ObjectStateEnumSpecifieswhetheranobjectisopenorclosed,connectingtoadatasource,executingacommand,orfetchingdata.ParameterAttributesEnumSpecifiestheattributesofaParameterobject.ParameterDirectionEnumSpecifieswhethertheParameterrepresentsaninputparameter,anoutputparameter,orboth,oriftheparameteristhereturnvaluefromastoredprocedure.PersistFormatEnumSpecifiestheformatinwhichtosaveaRecordset.PositionEnumSpecifiesthecurrentpositionoftherecordpointerwithinaRecordset.PropertyAttributesEnumSpecifiestheattributesofaPropertyobject.RecordCreateOptionsEnumSpecifiesfortheRecordobjectOpenmethodwhetheranexistingRecordshouldbeopened,oranewRecordshouldbecreated.RecordOpenOptionsEnumSpecifiesoptionsforopeningaRecord.ThesevaluesmaybecombinedbyusinganORoperator.RecordStatusEnumSpecifiesthestatusofarecordwithregardtobatchupdatesandotherbulkoperations.RecordTypeEnumSpecifiesthetypeofRecordobject.ResyncEnumSpecifieswhetherunderlyingvaluesareoverwrittenbyacalltoResync.SaveOptionsEnumSpecifieswhetherafileshouldbecreatedoroverwrittenwhensavingfromaStreamobject.ThevaluescanbecombinedwithanANDoperator.SchemaEnumSpecifiesthetypeofschemaRecordsetthattheOpenSchemamethodretrieves.SearchDirectionEnumSpecifiesthedirectionofarecordsearchwithinaRecordset.SeekEnumSpecifiesthetypeofSeektoexecute.StreamOpenOptionsEnumSpecifiesoptionsforopeningaStreamobject.ThevaluescanbecombinedwithanANDoperator.StreamReadEnumSpecifieswhetherthewholestreamorthenextlineshouldbereadfromaStreamobject.StreamTypeEnumSpecifiesthetypeofdatastoredinaStreamobject.StreamWriteEnumSpecifieswhetheralineseparatorisappendedtothestringwrittentoaStreamobject.StringFormatEnumSpecifiestheformatwhenretrievingaRecordsetasastring.XactAttributeEnumSpecifiesthetransactionattributesofaConnectionobject.ADOErrorCodeListErrorValueEnumSpecifiesthetypeofADOrun-timeerror.Threeformsoftheerrornumberarelisted:Positivedecimalthelowtwobytesofthefullnumberindecimalformat.ThisnumberisdisplayedinthedefaultVisualBasicerrormessagedialogbox.Forexample,Run-timeerror‘3707’.NegativedecimalThedecimaltranslationofthefullerrornumber.HexadecimalThehexadecimalrepresentationofthefullerrornumber.TheWindowsfacilitycodeisinthefourthdigit.ThefacilitycodeforADOerrornumbersisA.Forexample:0x800A0E7B.NoteOLEDBerrorsmaybepassedtoyourADOapplication.Typically,thesecanbeidentifiedbyaWindowsfacilitycodeof4.Forexample,0x8004Formoreinformationaboutthesenumbers,seeChapter16oftheOLEDBProgrammer’sReference.ConstantValueDescriptionadErrBoundToCommand3707-21468245810x800A0E7BCannotchangetheActiveConnectionpropertyofaRecordsetobjectwhichhasaCommandobjectasitssource.adErrCannotComplete3732-21468245560x800A0E94Servercannotcompletetheoperation.adErrCantChangeConnection3748-21468245400x800A0EA4Connectionwasdenied.Newconnectionyourequestedhasdifferentcharacteristicsthantheonealreadyinuse.adErrCantChangeProvider3220-21468250680X800A0C94Suppliedproviderisdifferentfromtheonealreadyinuse.adErrCantConvertvalue3724-21468245640x800A0E8CDatavaluecannotbeconvertedforreasonsotherthansignmismatchordataoverflow.Forexample,conversionwouldhavetruncateddata.adErrCantCreate3725-21468245630x800A0E8DDatavaluecannotbesetorretrievedbecausethefielddatatypewasunknown,ortheproviderhadinsufficientresourcestoperformtheoperation.adErrCatalogNotSet3747-21468245410x800A0EA3OperationrequiresavalidParentCatalog.adErrColumnNotOnThisRow3726-21468245620x800A0E8ERecorddoesnotcontainthisfield.adErrDataConversion3421-21468248670x800A0D5DApplicationusesavalueofthewrongtypeforthecurrentoperation.adErrDataOverflow3721-21468245670x800A0E89Datavalueistoolargetoberepresentedbythefielddatatype.adErrDelResOutOfScope3738-21468245500x800A0E9AURLoftheobjecttobedeletedisoutsidethescopeofthecurrentrecord.adErrDenyNotSupported3750-21468245380x800A0EA6Providerdoesnotsupportsharingrestrictions.adErrDenyTypeNotSupported3751-21468245370x800A0EA7Providerdoesnotsupporttherequestedkindofsharingrestriction.adErrFeatureNotAvailable3251-21468250370x800A0CB3Objectorproviderisnotcapableofperformingrequestedoperation.adErrFieldsUpdateFailed3749-21468245390x800A0EA5Fieldsupdatefailed.Forfurtherinformation,examinetheStatuspropertyofindividualfieldobjects.adErrIllegalOperation3219-21468250690x800A0C93Operationisnotallowedinthiscontext.adErrIntegrityViolation3719-21468245690x800A0E87Datavalueconflictswiththeintegrityconstraintsofthefield.adErrInTransaction3246-21468250420x800A0CAEConnectionobjectcannotbeexplicitlyclosedwhileinatransaction.adErrInvalidArgument3001-21468252870x800A0BB9Argumentsareofthewrongtype,areoutofacceptablerange,orareinconflictwithoneanother.adErrInvalidConnection3709-21468245790x800A0E7DOperationisnotallowedonanobjectreferencingaclosedorinvalidconnection.adErrInvalidParamInfo3708-21468245800x800A0E7CParameterobjectisimproperlydefined.Inconsistentorincompleteinformati