10-14-2015 03:59 PM
I am trying to connect to a MS Access 2010 Database via a connection string. The example provided with NI Teststand called "database step types" does not even work and it gives me an error message
Native error code -2146824582 0x800a0e7a
ADODB.Connection:
Provider cannot be found. It may not be properly installed.
I am running Win 7 64 bit mode. I have seen there is something odd about the Win 7 64 bit running with Access 2010 but I need to know the workaround for teststand. Anybody know the answer?
10-15-2015 06:36 PM
Hi id,
This may be occuring because MS Access 2010 Database is a 32-bit database provider, while your OS is 64-bit. This final Note in this KB has instructions about how to enable 32-bit providers:
http://ae.natinst.com/public.nsf/web/searchinternal/1D5EB4DCBD13106486256B9D005E11B0
10-16-2015 10:44 AM
1) What version of TestStand are you using, and if TestStand 2014 or later, what bitness (32- or 64-bit) are you running?
2) Are you running this from the Sequence Editor, a default UI, or a custom UI?
3) Please paste the connection string expression that is being used and is failing.