Welcome to MapForums!

Register, sign in, or use Facebook Connect above to join in and participate in the forum.

When you are signed in, this message, the ads in this row, and the red-underlined link ads all go away.

Subscribe to receive our newsletter.
Subscribe Unsubscribe
Results 1 to 3 of 3

Using VB6 to Link to SQL View

This is a discussion on Using VB6 to Link to SQL View within the MapPoint Desktop Discussion forums, part of the Map Forums category; What is the best way to do this? In the Help file examples, I do not see a syntax defined ...

  1. #1
    takk is offline Junior Member White Belt
    Join Date
    Dec 2004
    Posts
    6

    Using VB6 to Link to SQL View

    What is the best way to do this? In the Help file examples, I do not see a syntax defined for a Datasource Moniker using SQL. I do see a UDL file type, but there is no example syntax and I cannot get this to work.

  2. #2
    takk is offline Junior Member White Belt
    Join Date
    Dec 2004
    Posts
    6

    Answer

    Ok. I figured out my own problem. Of course I will share...


    For those of you trying to Import/Link directly to a SQL Table or View instead of using MS-Access as the "middleman". First create a UDL file that points to your SQL database (I use the ODBC DSN method). Here is the syntax for the code to link:

    LinkData("C:\My_Data.UDL!My_Table", "ID_Field")

    The part I was having a hard time with was the after the "!". You must specify the name of your SQL table or view here. Hope this helps.

  3. #3
    Eric Frost's Avatar
    Eric Frost is offline Administrator Black Belt
    Join Date
    Jul 1992
    Posts
    5,094
    Blog Entries
    4
    Thanks for the follow up.

    Eric
    ~ Order MapPoint MapPoint 2013 Here and Get Free Access to the MapForums Downloads ~
    ~~
    ~ Upgrade to Get Access to the MapForums Downloads ~

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. View by zip code
    By John Swanick in forum MapPoint Desktop Discussion
    Replies: 8
    Last Post: 07-12-2005, 09:05 AM
  2. Choosing what to view
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 12-04-2003, 04:46 AM
  3. 3D View
    By Anonymous in forum Wish List
    Replies: 0
    Last Post: 06-06-2003, 06:19 PM
  4. One country view only?
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 04-18-2003, 11:45 AM
  5. Print View
    By healthsouthgirl in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 08-14-2002, 10:03 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


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