Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
Free Newsletters:

News Via RSS Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles


Posted Jun 26, 1998

APIs... - Page 14

By Sharon Dooley

25 Jan 98

ADO: routine access to data. Seen as vehicle of choice for VB developers.

OLE DB: lower level COM-based access to data. Used by provider developers. Performance comparable to ODBC. Adds an OPENROWSET function to be used in FROM clause. This is supported in views and most users will create views so that the SELECT statements dont get littered with OPENROWSET.

ODBC: Not going away. "Going to be around for a long time". Has new 7.0 data types. There is a DSN wizard and password encryption. ODBC round-trips are minimized for Internet access.

DBLIB: not improving. No access to 7.0 features.

DMO: The new DMO is not backward compatible with the old DMO. It is a different OLE Object. It accesses the database through ODBC, not through DBLIB as the 6.x version does.


Many thanks to Sharon for providing these notes - drop her a note at sharond@compuserve.com and tell her thanks!


MS SQL Archives

Latest Forum Threads
MS SQL Forum
Topic By Replies Updated
SQL 2005: SSIS: Error using SQL Server credentials poverty 3 August 17th, 07:43 AM
Need help changing table contents nkawtg 1 August 17th, 03:02 AM
SQL Server Memory confifuration bhosalenarayan 2 August 14th, 05:33 AM
SQL Server Primary Key and a Unique Key katty.jonh 2 July 25th, 10:36 AM