I have installed MAP 7 with local Database. Is it posible to access the MAP data with Microsoft Access. I can't find a local Instance or Service localdb to create a ODBC Connection? I have only one Service "SQL Server VSS Writer".
LocalDB doesn't install the necessary drivers to connect to it from an external application. The easiest way to get those drivers is to install
SQL Server Management Studio 2012. Once SSMS is installed, within Access, connect to the ODBC database, create a new machine data source and choose the SQL Server Native Client 11.0
driver. The SQL Server name is (localdb)\maptoolkit. I'll work on creating a TechNet Wiki article with step-by-step directions.
Please remember to click "Mark as Answer" on the post that helps you, and to click
"Unmark as Answer" if a marked post does not actually answer your question. Please
VOTE as HELPFUL if the post helps you. This can be beneficial to other community members reading the thread.
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.