ADO is simply a wrapper around OLEDB to make it easy to use from COM -compliant progams. The only way to use OLE-DB without ADO is in C++.
>To be exact, SQL Server is deprecating OLEDB, which I suppose is pretty much the same thing, but existing OLEDB drivers for other databases will continue to work. In this case, I'm interested because the Excel ODBC driver assumes the first row contains column names, and I need to import a file where the first row contains data. There is a setting to override this behavior, but there is a bug in the driver and it doesn't work (
http://support.microsoft.com/kb/288343). This bug has been around for many years, and even though they added XLSX support to the ODBC driver, they still haven't fixed the bug! The setting in the OLEDB driver works, so I was hoping to use it without having to use ADO.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer