ODBC vs OLE DB
-
Hi I am looking to write a small VC++ utility which inserts possibly a few thousand records at a time into an Access database. The primary criteria here is efficiency. Which is the more suitable candidate? ODBC or OLE DB? Any input is appreciated. thanks Satheesh Man Learns from History that he never learns from History
-
Hi I am looking to write a small VC++ utility which inserts possibly a few thousand records at a time into an Access database. The primary criteria here is efficiency. Which is the more suitable candidate? ODBC or OLE DB? Any input is appreciated. thanks Satheesh Man Learns from History that he never learns from History
You wont see much of a performance difference between the OLE DB ODBC provider and using the ODBC API directly. OLE DB is based on COM and it doesnt introduce any overhead. OLE DB is basically to use COM so that we can have a plug-and-play architecture for application components.
-
Hi I am looking to write a small VC++ utility which inserts possibly a few thousand records at a time into an Access database. The primary criteria here is efficiency. Which is the more suitable candidate? ODBC or OLE DB? Any input is appreciated. thanks Satheesh Man Learns from History that he never learns from History
You can choose OLEDB. because ODBC is a generailised interface it will take some more time than OLEDB. all the best