NI TestStand

cancel
Showing results for 
Search instead for 
Did you mean: 

Can not interface to MS Access 2010

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? 

0 Kudos
Message 1 of 3
(4,147 Views)

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

 

 

 

Libby B.
Applications Engineering Specialist - RF Wireless
National Instruments
0 Kudos
Message 2 of 3
(4,121 Views)

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.

Scott Richardson
https://testeract.com
0 Kudos
Message 3 of 3
(4,111 Views)