12-31-2005 10:49 AM
ADO is part of the MDAC (Microsoft Data Access Components) package from Microsoft. It's not installed with versions of Windows earlier than ME. That's what supports UDL files and other related ADO features. I recommend going to Microsoft's download page and installing the latest MDAC version on your machine. They also have some utilities for checking what version, if any, is currently installed. The Database Connectivity Toolkit requires at least MDAC 2.5.
What you heard from other forums is true - OLE DB is a much better way to communicate with databases than ODBC. Also, I want to add that Oracle's OLE DB provider is far superior to the one written by Microsoft.
I hope this helps,
Crystal
12-31-2005 11:50 PM
05-27-2006 02:00 PM
05-30-2006 01:36 PM
05-30-2006 01:53 PM