By migrating to SQL Server you receive additional benefits such as support for stored procedures, triggers, an OLE-DB driver, and much more. Plus you'll save time by using tools such as Enterprise Manager or Visual InterDev to manipulate your database directly across the Internet instead of having to download it from your site, make the changes, and then upload again. If you think that SQL Server is overkill for your particular application, you should reconsider. ADO vs. OLE-DB vs. ODBC ODBC is a Microsoft standard for accessing databases. It was the first such standard, and dates back to Windows 3.x.
ADO provides a simplified mechanism for accessing OLE-DB databases.
All rights reserved.