MapPoint Forums

MapForums

Community of MapPoint and Virtual Earth Users and Developers




Mappoint, SQL, and Access

This is a discussion on Mappoint, SQL, and Access within the MapPoint 2006/2009 Discussion forums, part of the Map Forums category; I am using Mappoint with an application created in MS Access. All the data is kept in a MS SQL ...


Go Back   MapPoint Forums > Map Forums > MapPoint 2006/2009 Discussion

Today's Posts Twitter Feed Register Blogs FAQ Members List Calendar Search Today's Posts Mark Forums Read



Click here to register

Reply

 

LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 02-22-2005
Junior Member
White Belt
 
Join Date: Feb 2005
Posts: 1
Mappoint, SQL, and Access

I am using Mappoint with an application created in MS Access. All the data is kept in a MS SQL Server backend.

I am trying to pull zip code-based territory info out of an SQL table and map it.

Is there a way to connect to SQL Server other than using a UDL? I'd rather have the connection info stored in the code instead of having to create a UDL on the fly.

Also, can user-defined functions be used as a recordsource? I have only been able to get tables and views to work so far...


Thanks.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #2 (permalink)  
Old 03-11-2005
Junior Member
White Belt
 
Join Date: Mar 2005
Posts: 1
Don't use UDL

In Access, "Get External data - Linked" to an ODBC datasource that points to SQL Server. Then in Mappoint, just use the "Access" database you just created.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #3 (permalink)  
Old 03-11-2005
Senior Member
Black Belt
 
Join Date: Nov 2004
Posts: 2,177
Hi,

what is UDL ?
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
Reply

Tags
access, mappoint, sql


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads

Thread Thread Starter Forum Replies Last Post
mappoint in access nmilne MapPoint 2006/2009 Discussion 4 01-25-2006 10:00 AM
MS Access Mappoint ActiveX Anonymous MapPoint 2006/2009 Discussion 2 05-21-2005 05:31 PM
MapPoint with Access Anonymous MapPoint 2006/2009 Discussion 0 03-26-2005 11:25 AM
Problem with mappoint in Access Dazzer MapPoint 2006/2009 Discussion 0 12-04-2003 04:27 AM
MapPoint in MS Access Anonymous MapPoint 2006/2009 Discussion 0 01-21-2003 05:23 PM


All times are GMT -5. The time now is 02:48 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.3.0 RC2
MP2K Magazine
Visitor Map

Antalya Holiday
Check out the Antalya holiday options through UlookUbook and find amazing offers that suit your pocket...



1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59