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,
- uninstall 64-bit redistributable installed.
- download , install 32-bit redistributable from here. note link shows both 32-bit , 64-bit versions, make sure select 1st 1 (marked below)
- now should able see list of available connection managers.
Comments
Post a Comment