Deprecated and obsolete components Microsoft Data Access Components

-



1 deprecated , obsolete components

1.1 microsoft jet database engine , jro
1.2 msdasql , oracle odbc
1.3 remote data services (rds)
1.4 sqlxml
1.5 obsolete components





deprecated , obsolete components

mdac continually evolving component framework. such, there have been several components part of have since been deprecated or removed entirely framework.


microsoft jet database engine , jro

jet stands joint engine technology , database engine used microsoft access, microsoft exchange server , visual basic. jet part of relational database management system (rdbms) , offered single interface other software use access microsoft databases. jet provided support security, referential integrity, transaction processing, indexing, record , page locking, , data replication. in later versions of jet, engine extended run sql queries, store character data in unicode format, create views, , allowed bi-directional replication microsoft sql server. has since been superseded msde.


there 3 modules jet. 1 native jet isam driver, jet dynamic link library (dll) directly manipulate microsoft access database files (mdb), modified form of indexed sequential access method (isam) database. 1 of modules isam drivers, dlls allowed access isam databases, among them being xbase, paradox, btrieve , foxpro files. final module data access objects (dao) dll, dao allowed programmers access jet engine. object-oriented data language used access basic , visual basic application developers access jet.


similarly, microsoft jet ole db provider , replication objects (jro) allowed replication between jet data sources removed mdac 2.6


msdasql , oracle odbc

the microsoft ole db provider odbc, or msdasql, ole db provider allowing activex data objects access databases via odbc driver. microsoft supplied several ole-db providers (for indexing service, active directory, jet, sql server, oracle (msdaora) , internet publishing), unless otherwise directed, ado defaulted using msdasql default provider. after mdac 2.5 both oracle odbc driver , msdasql supported oracle 7 , partially supported oracle 8i. features not supported were:



clob, blob, bfile, nchar, nclob, , nvarchar2 oracle datatypes
unicode support oracle 7.x , 8i
multiple client instances of oracle
nested outer joins

microsoft deprecated msdasql component 64-bit operating systems , microsoft oracle odbc driver later superseded .net managed oracle provider, supported oracle 9i. however, windows server 2008 , windows vista sp1 ship 64-bit version of msdasql.


remote data services (rds)

remote data services (rds) allowed retrieval of set of data server, client altered in way , sent server further processing. popular adoption of transact-sql, extends sql such programming constructs loops , conditional statements, became less necessary , deprecated in mdac 2.7. microsoft produced soap toolkit 2.0, allows clients via open xml-based standard.


sqlxml

sqlxml designed sql server 2000, deprecated mdac 2.6. allowed microsoft s relational database viewed xpath , allowed data viewable xml file. has not been deprecated has been removed later versions of mdac, though microsoft provide downloadable component , support on 64-bit operating systems.


obsolete components

several components have been removed mdac microsoft , no longer supported. are:



esql/c: embedded sql (also known e-sql or esql/c) way of using sql when programming in visual c. microsoft dropped support after sql server 6.5 released, though did license of esql/c run-time environment company called micro focus, develops cobol compilers , tools
dao: dao, or data access objects object oriented interface created microsoft allowed versions of microsoft access , visual basic access jet database engine. later (in version 3.5) able bypass jet engine altogether , directly access odbc data sources.
rdo: remote data objects, or rdo, microsoft technology allowed creation of interfaces directly called on odbc. rdo version 2.0 final version developed microsoft.
db-library: c-based api allowed application interact sql server. not supported on product after sql server 2000, , no features added after sql server 6.5.




^ microsoft, deprecated components (ole db), retrieved august 5, 2005.
^ hamilton, bill (2008). ado.net 3.5 cookbook. cookbook series (2 ed.). o reilly media, inc. p. 27. isbn 9780596101404. retrieved 2012-10-09. [...] use [...] oracle ole db provider (msdaora) access oracle data. 
^ microsoft, data access technologies road map , deprecated mdac components, microsoft ado programmer s guide appendix a: providers, microsoft ole db provider odbc archived 2001-10-05 @ wayback machine., retrieved july 30, 2005.
^ microsoft, ms kb article 244661: info: limitations of microsoft oracle odbc driver , oledb provider, last reviewed august 25, 2004, retrieved august 4, 2005.
^ microsoft, remote data service (rds) , retrieved august 11, 2005.
^ microsoft, data access technologies roadmap , deprecated mdac components
^ kalen delaney, inside microsoft sql server 2000 , microsoft press, p65.
^ christine solomon, microsoft office 97 developer s handbook , microsoft press. pp. 195–200.






Comments

Post a Comment

Popular posts from this blog

History Shake Shack

-
the original shake shack located in madison square park in 2000, new york city began rebuilding of madison square park, had fallen state of disrepair , misuse. part of redevelopment, restaurateur danny meyer helped spearhead creation of madison square park conservancy redevelop it. 1 of first things conservancy did in goal improve park host art exhibit called <3 taxi inside of park raise awareness of renewal effort. meyer s director of operations, randy garutti, established hot dog cart run out of kitchen of eleven madison, 1 of meyer s union square hospitality group (ushg) operations. on time cart became extremely successful, , remained in operation 3 years. in 2004, city began taking bids operate new kiosk-style restaurant within park; meyer outlined idea space, , opened first shake shack in july 2004. beginning restaurant not designed chain; intended single shop location designed new york city. however, original location s sales continued grow, group realized there market expan...
Read more

David Aceveda List of The Shield characters

-
1 david aceveda 1.1 personality 1.2 career 1.3 farmington 1.4 city council 1.5 relationship vic mackey 1.6 rape incident, alliance vic, , mayoral status david aceveda david segovia aceveda, played benito martinez, character on fx s television crime drama shield. originally, captain of barn , fictional lapd precinct in also-fictional farmington district of los angeles, california. however, in season three, elected los angeles city council , relinquished command in first episode of season 4. though no longer captain, responsibilities city council representative of farmington district keep him in forefront of show. according show creator shawn ryan s commentary on season 1 dvd, aceveda character heavily influenced former los angeles mayor antonio villaraigosa. personality aceveda born politician—extremely intelligent , ambitious. main reason taking captaincy in farmington raise profile in community enable him run seat on city council , eventually, mayor. prisoner ambition , place morals ...
Read more

Prehistory History of Utah

-
fremont petroglyph, dinosaur national monument the fremont culture, named sites near fremont river in utah, lived in north , western utah , parts of nevada, idaho , colorado approximately 600 1300 ad. these people lived in areas close water sources had been occupied desert archaic people, , may have had relationship them. however, use of new technologies define them distinct people. fremont technologies include: use of bow , arrow while hunting, building pithouse shelters, growing maize , beans , squash, building above ground granaries of adobe or stone, creating , decorating low-fired pottery ware, producing art, including jewelry , rock art such petroglyphs , pictographs. hovenweep castle, san juan river basin the ancient puebloan culture, known anasazi, occupied territory adjacent fremont. ancestral puebloan culture centered on present-day 4 corners area of southwest united states, including san juan river region of utah. archaeologists debate when distinct culture emerged, cultural...
Read more