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:
- 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.
- Right-click the data link file on the desktop, and then click Properties.
- On the Provider tab, click to select Microsoft OLE DB Provider for SQL Server, and then click Next.
- In the Select or enter a server name box, click the SQL server to which you want to connect.
- If you want to test the connection to the server, click Test Connection.
- Click OK.
- Start MapPoint 2000 or MapPoint 2001.
- On the File menu, click Link Data.
- In the Files of type box, click Microsoft Data Link (*.udl).
- In the Look in box, click Desktop.
- Click the data link file that you created in step 2, and then click Open.
- In the Data Link Wizard dialog box, click the table to which you want to link, and then click Next.
- Make sure that an appropriate column heading is selected for each column, and then click Next.
- 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
