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>
Regards,
LelandJ
Andy Davies wrote:
Stephen Russell said "You would also want to avoid ODBC and upgrade to
OLEDB."
but then; he would say that, wouldn't he?
Andrew Davies MBCS CITP
- AndyD 8-)#
**********************************************************************
This email and any files transmitted with it are confidential and intended
solely for the use of the individual or entity to whom they are addressed. If
you have received this email in error please notify the system manager.
This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.
Please contact [EMAIL PROTECTED] with any queries.
**********************************************************************
[excessive quoting removed by server]
_______________________________________________
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.
