anjalipunjabb (1/28/2015)
You can also use oledb to connect to Sql Server but the performance is lower as compared to a adodb connection which is optimized to work with Sql Server and MS Access.
Any resources to back this claim?
I have used OLE DB and ADO.NET for years and I haven't noticed any performance difference.
In fact, OLE DB with fast load is usually the fastest.
ADO.NET can also work with other sources than SQL Server or MS Access. It can use ODBC to connect to any possible source for example.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP