I'm quite new to the wonderful world of ADO and I'm trying to get my head around providers. I'm connecting to SQL Server 7 and I've tried using MSDASQL and SQLOLEDB - which one is the best one to use?
It seems that whichever one I use I get a trade off between speed and compatibility. When I use SQLOLEDB I get errors about transactions, when I use MSDASQL I get crap performance.
Does anyone have the definitive answer as to which provider is best? I've tried Microsoft and, not suprisingly, they don't have the answer.