Leland Jackson <> wrote: > What are the advantages of using OLE-DB other than windows lock in? > LOL. Everyone except Microsoft still standardize on ODBC. OLE-DB is > slower than ODBC, and can require rewriting of applications should > you decide to move to the Window world. OLE-DB uses a first, next, > previous, last method to walk through record sets, which is not well > suited to web based application that do not have local network > speeds; although, it fine for desktop application. > > All the major vendors, except Microsoft, provide their own ODBC > drivers for windows, and most now also provide OLE-DB as well as a > connection layer that can be used by .NET. So far as I can see, > there was no valid reason for Microsoft to go to a new > non-standardized OLE-DB provider, other than Microsoft desire to try > and monopolize the database server market to go along with its > monopoly of the windows desktop market. In the Microsoft world, > there is only one database name MS SQL and only one OS named Windows. > Outside of them, nothing else exits. <g>
AutoInc in a dbc just as a start. Oh how about dbc triggers or long names for fields. Stephen Russell DBA / Operations Developer Memphis TN 38115 901.246-0159 http://spaces.msn.com/members/srussell/ -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.394 / Virus Database: 268.10.1/389 - Release Date: 7/14/2006 _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
