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

» Database Journal Home
» Database Articles
» Database Tutorials
MS SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
Database Tools
SQL Scripts & Samples
Links
» Database Forum
» Sitemap
Free Newsletters:
DatabaseDaily  
News Via RSS Feed


follow us on Twitter
Database Journal |DBA Support |SQLCourse |SQLCourse2
 

Featured Database Articles

MS SQL

Posted Jun 25, 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

Comment and Contribute

 


(Maximum characters: 1200). You have characters left.

 

 




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


















Thanks for your registration, follow us on our social networks to keep up-to-date