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

Stored Procedure in DataSourceMoniker of ImportData medthod

This is a discussion on Stored Procedure in DataSourceMoniker of ImportData medthod within the MapPoint Desktop Discussion forums, part of the Map Forums category; I'm using MapPoint 2004, VB.Net and SQLServer and I wonder if and how it is possible to use a stored ...

  1. #1
    webjagger is offline Junior Member White Belt
    Join Date
    Mar 2004
    Posts
    10

    Stored Procedure in DataSourceMoniker of ImportData medthod

    I'm using MapPoint 2004, VB.Net and SQLServer and I wonder if and how it is possible to use a stored procedure inside the DataSourceMoniker of the ImportData method.
    What I've allready done is
    Code:
    ImportData("db.udl!q_MyQuery", ...)
    Another way might be to add the where clause to the DataSourceMoniker. Is that possible?

    My problem is that I can't use different queries.
    So anybody has an idea?

    Thanks in advance.

    Alex

  2. #2
    Anonymous is offline Senior Member Black Belt
    Join Date
    Jul 2002
    Posts
    5,137
    ....afaik, you can't import from SQL server, just from MS Access. Hope Iím wrong!

    You are on the right track with the moniker other than that. In Access you can definitely import from a query. Just use geoImportAccessQuery in the import flags. Note, I have found that is fails with very long path names...or of course if you have a ! in the path somewhere.

    I assume you know where the docs are, but just in case:

    http://msdn.microsoft.com/library/en...asp?frame=true

    Hope this helps.

  3. #3
    webjagger is offline Junior Member White Belt
    Join Date
    Mar 2004
    Posts
    10
    Yes, ChrisA, you are wrong.
    Inside that udl-file you can also specify a connection to a SQLServer.
    I tried it and it works fine.

    So I'm still hoping, that I get the problem solved to use a sp or get the where clause integrated somehow?!

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. I have tried for some time to link to data stored ....
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 3
    Last Post: 06-24-2006, 10:00 AM
  2. Remote procedure call failed: Location. StreetAddress
    By Vinay in forum MapPoint Desktop Discussion
    Replies: 3
    Last Post: 02-16-2006, 02:34 PM
  3. ImportData method ?
    By mgorgone in forum MapPoint Desktop Discussion
    Replies: 2
    Last Post: 06-02-2005, 02:31 PM
  4. ImportData
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 11-04-2004, 04:05 AM
  5. Implementing ImportData in C/C++
    By moojit in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 09-01-2002, 11:58 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 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