|
马上注册,结交更多好友,享用更多功能,让你轻松玩转社区。
您需要 登录 才可以下载或查看,没有帐号?立即注册
x
在实现ERP等高端的ASP应用时,用户需要提供核心的经营资料,需要ASP商有很高的信用度。楼上说交互性不好,太牵强了吧。在微软提供的一套框架中,利用asp做网站,开发效率高,使用人数少,减少不必要的开销。交互性是互动方式,是有开发人员决定的。下载最新版的MDAC(MicrosoftDataAccessComponents)下载。
==========================================
MicrosoftDataAccessComponents(MDAC)
Purpose
TheMicrosoftDataAccessComponents(MDAC)SDKdocumentsthekeytechnologiesthatenableUniversalDataAccess,Microsoftsstrategyforprovidingaccesstoinformationacrosstheenterprise.
MicrosoftDataAccessComponentsincludeActiveXDataObjects(ADO),OLEDB,andOpenDatabaseConnectivity(ODBC).Data-drivenclient/serverapplicationsdeployedovertheWeboraLANcanusethesecomponentstoeasilyintegrateinformationfromavarietyofsources,bothrelational(SQL)andnonrelational.
IfyouhavequestionsorneeddetailedinformationaboutproperlyredistributingMDAC,seeRedistributingMDACforadescriptionofthedistributionrequirementsforMDAC.
ActiveXDataObjects(ADO)
MicrosoftActiveXDataObjects(ADO)providesconsistent,high-performanceaccesstodataandsupportsavarietyofdevelopmentneeds,includingthecreationoffront-enddatabaseclientsandmiddle-tierbusinessobjectsthatuseapplications,tools,languages,orInternetbrowsers.TheprimarybenefitsofADOareeaseofuse,highspeed,lowmemoryoverhead,andasmalldiskfootprint.
ADOprovidesaneasy-to-useinterfacetoOLEDB,whichprovidestheunderlyingaccesstodata.Itusesafamiliarmetaphor―theCOMAutomationinterface―availablefromallleadingRapidApplicationDevelopment(RAD)tools,databasetools,andlanguages.
OLEDB
MicrosoftOLEDBisasetofinterfacesthatexposedatafromavarietyofrelationalandnonrelationalsourcesbyusingtheComponentObjectModel(COM).OLEDBinterfacesprovideapplicationswithuniformaccesstodatastoredindiverseinformationsources.TheseinterfacessupporttheamountofDBMSfunctionalityappropriatetothedatastore,enablingthedatastoretoshareitsdata.
OLEDBcomprisesaprogrammaticmodelconsistingofdataproviders,whichcontainandexposedata;dataconsumers,whichusedata;andservicecomponents,whichprocessandtransportdata(suchasqueryprocessorsandcursorengines).Inaddition,OLEDBincludesabridgetoODBCtoenablecontinuedsupportforthebroadrangeofODBCrelationaldatabasedrivers.
OpenDatabaseConnectivity(ODBC)
TheMicrosoftOpenDatabaseConnectivity(ODBC)interfacemakesitpossibleforapplicationstoaccessdatafromavarietyofDBMSs.ODBCpermitsmaximuminteroperability―anapplicationcanaccessdataindiverseDBMSsthroughasingleinterface.Furthermore,thatapplicationwillbeindependentofanyDBMSfromwhichitaccessesdata.Usersoftheapplicationcanaddsoftwarecomponentscalleddrivers,whichcreateaninterfacebetweenanapplicationandaspecificDBMS.
ComponentsoftheMDACSDK
MicrosoftActiveXDataObjects(ADO)
ThissectioncontainsProgrammersReferencesforADO,ADOX,ADOMD,andRDS,aswellassamplesdocumentation.
MicrosoftOLEDB
ThissectiondocumentstheOLEDBandOLEDBforOLAPinterfaces,includingaProgrammersReference,documentationforvariousOLEDBproviders,andsamples.
MicrosoftOpenDatabaseConnectivity(ODBC)
ThissectiondocumentstheODBCinterface,includingaProgrammersReference,documentationforvariousODBCdrivers,andsamples.
SQLServer是基于服务器端的中型的数据库,可以适合大容量数据的应用,在功能上管理上也要比Access要强得多。在处理海量数据的效率,后台开发的灵活性,可扩展性等方面强大。 |
|