Microsoft KB Archive/256603

= MapPoint: How to Dynamically Link SQL Data to a Map =

Article ID: 256603

Article Last Modified on 1/27/2007

-

APPLIES TO


 * Microsoft MapPoint 2002 Standard Edition
 * Microsoft MapPoint 2001 Standard Edition
 * Microsoft MapPoint 2000 Standard Edition

-



This article was previously published under Q256603



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



MORE INFORMATION
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

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.