ADO : msado15.dll for 64 bit platform

[JackDel]

Hello,

I have to port a 32 bits software suite to 64 bits

Os : windows 10 64 bits, C++ MFC

"Visual C++ Enterprise 2017".

I have a pb with ADO
to isolate the pb, I use a small program just for connecting a database :
For example, this compiles in 32 bits and works with a 64 bits computer :


#import "c:\Program Files\Fichiers communs\System\ado\msado15.dll" no_namespace rename("EOF", "EndOfFile")

_bstr_t strCnn("Provider='Microsoft.Jet.OLEDB.4.0'; Data Source='example.mdb'");
TESTHR(pConnection.CreateInstance(__uuidof(Connection)));
hr = pConnection->Open(strCnn, "", "", adConnectUnspecified);
This compiles for 64 bits platform. But, when execute, the method hr = pConnection->Open(strCnn, "", "", adConnectUnspecified);
returns "Cant find a provider"

I conclude that:
- I have to install a 64 bits ADO "drivers" but wich one?
- find the good provider ?

I add that I what to keep the possibility to compile with 32 bits also.
Do you already meet this pb? thanks a lot

Continue reading...