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.
Loading
Pedro BarbasPosted Aug 19, 2009, 6:49 AM
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 PatelPosted Aug 19, 2009, 2:56 AM
Odbc can be used to access all the Database which provide ODbc Drivers
Oledb , SqlClient,Oracle 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