Sign in
 
HomeLibraryWikiLearnGalleryDownloadsSupportForumsBlogs
Resources for IT Professionals >
> 
> 
> 
MAP 7, ODBC, SQL Server Express 2012

回答の候補 MAP 7, ODBC, SQL Server Express 2012

  • Wednesday, November 28, 2012 7:23 AM
     
     
    Sign In to Vote
    0

    hello all,

    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".

    Chris

     

All Replies

  • Wednesday, January 09, 2013 7:01 PM
    Moderator
     
     Proposed Answer
    Sign In to Vote
    1
    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.