I'm looking for some advice/information from people far more familiar with database connectivity technology than I am.
Currently our app allows the user to select any ODBC dsn on their machine, choose a table and optionally specific columns from the table and import them into our app using ODBC. In our new version we are creating a 64 bit version as well as a 32 bit version, so our ODBC import has to change as it's not supported for 64 bit.
I've been given just a few of days to specifically compare OLEDB with ODBC to decide which we should use in this next version, but the functionality must appear the same to the end user (or very close). Unfortunately I know nothing about OLEDB and little about ODBC.
My tasks are:
1. Verify ODBC drivers will work with OLEDB (2 days research)
2. For us to implement, what are the coding differences between ODBC and OleDB. Create 2 test apps in VS 2010. (3 days research)
3. Speed difference between the two (2 days)
My biggest problem is that I can't seem to find any good useful noncontradictory information on the web, especially for unmanaged C++ which i believe is all i will be allowed to use. I have tried to use the MSDASQL but i get the error:
"The .Net Framework Data Provider for OLEDB (System.Data.OleDb) does not support the Microsoft OLE DB Provider for ODBC Drivers (MSDASQL). Use the .Net Framework Data Provider for ODBC (System.Data.Odbc)."
Any help or insights, links to good information would be greatly appreciated.
Thanks