This leaves you the ability to not have to create an ODBC connection on each target machine and point the program to a new server on the fly.

I am running an ASP page that opens an ADO connection to an MS SQL database. It starts up a transaction and then executes a series of statements (no SELECTs, only DELETEs and INSERTs). It seems ...

With VB6, you can call ADODB objects to open an SQL database connection, send a query and then store the results in a Recordset data object.

DataDirect Connect for ADO.NET now supports Oracle 11g R2, SQL Server 2008, and DB2 iSeries V6R1. A complete list of database provider features is available online.

Some of the popular data providers include: SQL Server Data Provider, Oracle Data Provider, and OLEDB Data Provider. ADO.Net can work in both connected and disconnected modes.