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 2 of 2

Using LinkData to connect over UDL-File to MSDE/SQL-Server

This is a discussion on Using LinkData to connect over UDL-File to MSDE/SQL-Server within the MapPoint Desktop Discussion forums, part of the Map Forums category; Hi, I want to link geographic data with the DataSets.LinkData-Method. My Data is stored in a MSDE/SQL-Server-Database. I want to ...

  1. #1
    Boelling is offline Junior Member White Belt
    Join Date
    Nov 2004
    Posts
    3

    Using LinkData to connect over UDL-File to MSDE/SQL-Server

    Hi,

    I want to link geographic data with the DataSets.LinkData-Method. My Data is stored in a MSDE/SQL-Server-Database. I want to connect to the database over an UDL-File. I have longitude an latitude-values (data-type floating) in the database for faster linking to the data.

    The manual connection over the UDL-File to the MSDE/SQL-Server-Database with the DataSets.ShowLinkWizard-Method works fine. But the Link-Data-method fails.

    Does anybody have a working example for using the LinkData-method to connect over an UDL-File to an MSDE/SQL-Server Database with Lat/Lon-values?

    My (not working) example:

    Dim aArrayOfFields(1 To 2, 1 To 2) As Variant
    aArrayOfFields(1, 2) = "Longitude"
    aArrayOfFields(2, 1) = geoFieldLongitude
    aArrayOfFields(1, 2) = "Latitude"
    aArrayOfFields(2, 1) = geoFieldLatitude

    Dim strPrimaryKey As Variant
    strPrimaryKey = "ID"

    Dim oDataSet As MapPointCtl.DataSet
    Set oDataSet = Me.MappointControl1.ActiveMap.DataSets.LinkData(Ap p.Path & "\Data\Datalink.udl!geodata", strPrimaryKey, aArrayOfFields)

    Thank you,

    Sebastian Bölling

  2. #2
    Anonymous is offline Senior Member Black Belt
    Join Date
    Jul 2002
    Posts
    5,137
    Hi,

    I've found a good solution and example at:

    http://www.mp2kmag.com/a48--sqlserve....mappoint.html

    Sebastian Boelling

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Connect to Oracle using UDL file
    By msotres in forum MapPoint Desktop Discussion
    Replies: 6
    Last Post: 02-01-2010, 03:28 AM
  2. LinkData with UDL file in VB 6 App
    By Wim in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 04-03-2003, 07:04 AM
  3. connect dots
    By misterb83 in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 02-13-2003, 10:57 AM
  4. Connect Route Stops?
    By swberman in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 01-11-2003, 10:29 PM
  5. I'd like to connect my notebook with GPS through T....
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 02-22-2002, 12:51 AM

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 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96