Why should we use oledb?

Question

We have separate data providers for Oracle, SQLServer.
Say we are working on Oracle. Tomorrow, we might have to migrate it to Sqlserver. Should we use OLeDB then?
I am confused when should we use oledb, sqlclient,oracleclient, ODBC etc. Please guide.

Pedro Barbas · Answer

Hi Also you should be aware of the limitations for the OLE DB driver and ODBC providers: For ex the Microsoft OLE DB provider for AS/400 and VSAM does not support sql statements that DTS Import and DTS Export wizards use to create or truncate a table. And please don't forget to Check Do You Like This answer if this has helped you. Thanks!

Kirtan Patel · Answer

Hi  Friend Odbc can be used to access all the Database which provide ODbc Drivers Oledb  SqlClientOracle Client etc are derived From Odbc dont forget to mark  Do you like Answer  if answer helped you .it will give me some credits :) So you can use Odbc to Connect to Every type of Database That Provide ODbc Drivers Oledb  Oracle Client SQL Client are developed from Odbc that are only used for Specific type of Database