Microsoft KB Archive/256603

From BetaArchive Wiki
Knowledge Base

MapPoint: How to Dynamically Link SQL Data to a Map

Article ID: 256603

Article Last Modified on 1/27/2007


  • Microsoft MapPoint 2002 Standard Edition
  • Microsoft MapPoint 2001 Standard Edition
  • Microsoft MapPoint 2000 Standard Edition

This article was previously published under Q256603


This article describes how to dynamically link data from an SQL database to a map that you create in Microsoft MapPoint 2000 or Microsoft MapPoint 2001.


To dynamically link data from an SQL database to a map that you create in MapPoint 2000 or MapPoint 2001:

  1. Right-click your desktop, click New, and then click Microsoft Data Link.

NOTE: If Microsoft Data Link does not appear in the list, create a file with a .udl extension on your desktop.

For information about how to create a file with a specific extension, double-click My Computer, click Help Topics on the Help menu, click the Search tab, type create a file type, and then click To create a file type.

  1. Right-click the data link file on the desktop, and then click Properties.
  2. On the Provider tab, click to select Microsoft OLE DB Provider for SQL Server, and then click Next.
  3. In the Select or enter a server name box, click the SQL server to which you want to connect.
  4. If you want to test the connection to the server, click Test Connection.
  5. Click OK.
  6. Start MapPoint 2000 or MapPoint 2001.
  7. On the File menu, click Link Data.
  8. In the Files of type box, click Microsoft Data Link (*.udl).
  9. In the Look in box, click Desktop.
  10. Click the data link file that you created in step 2, and then click Open.
  11. In the Data Link Wizard dialog box, click the table to which you want to link, and then click Next.
  12. Make sure that an appropriate column heading is selected for each column, and then click Next.
  13. Select a primary key for your data, and then click Finish.

Additional query words: mp2000 mp2001 map point mp2k sequel

Keywords: kbfaq kbhowto kbinterop kbui KB256603