sql server - How to add new connection provider to Visual Studio? -


i'm using visual studio 2010 development in business intelligence (bi). in window connection manager, there're 9 native providers :

  • microsoft jet 4.0 ole db provider
  • microsoft ole db provider analysis services 11.0
  • micorsoft ole db provider oracle
  • ...

the provider needed microsoft office 12.0 access database engine ole db provider (microsoft.ace.oledb.12.0), not included in list. however, provider exist in computer : i've used in excel 2016, microsoft access connection provider.

so how can "link" / "add" provider vs2010 , make recognized ?

this happening because may have installed 64-bit version of microsoft access database engine 2010 redistributable.

visual studio / bids 32-bit application, , hence cannot "see" of 64-bit providers, including microsoft office 12.0 access database engine ole db provider installed.

to fix this,

  1. uninstall 64-bit redistributable installed.
  2. download , install 32-bit redistributable from here. note link shows both 32-bit , 64-bit versions, make sure select 1st 1 (marked below) enter image description here
  3. now should able see list of available connection managers.

Comments

Popular posts from this blog

Ansible - ERROR! the field 'hosts' is required but was not set -

customize file_field button ruby on rails -

SoapUI on windows 10 - high DPI/4K scaling issue -