When ASP was introduced, everyone used ODBC for their data connections because it was
the only real choice and that's how all the samples showed it being done. Well that was
then and this is now! OLE DB is faster, more stable, just as easy to use, and most
importantly works with almost all your previously written code!
To use OLE DB, all you need to do is change the connection string that you use to connect to your database.
In ODBC it would look something like this:
"DSN=dsn-name;"
or "DBQ=C:\data\database.mdb; DRIVER={Microsoft Access Driver (*.mdb)}"
To switch to OLE DB all you need to do is change it to something like this:
"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\data\database.mdb;"
or "Provider=SQLOLEDB; Data Source=sql_server; Initial Catalog=sql_database; " _
& "User Id=username; Password=password;"
