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

ADO Recordset Import?

This is a discussion on ADO Recordset Import? within the MapPoint Desktop Discussion forums, part of the Map Forums category; I've been reading the posts and articles and I believe I have the answer to my question but I'm having ...

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

    ADO Recordset Import?

    I've been reading the posts and articles and I believe I have the answer to my question but I'm having a hard time swallowing it! I am evaluating the trial version of MP for possible use with our app (VB6 app with an Oracle 8i DB).

    Is it correct that I cannot import an ADO recordset directly into MP?

    I saw an article about creating pushpins from a recordset but that seems like a lot of effort and has some significant limitations. I suppose the recordset could be exported to an acceptable file format and then imported but that seems like a crazy way to do it. Am I missing the obvious? Are there known workarounds or other solutions?

    Thanks,

    Chad

  2. #2
    John Meyer's Avatar
    John Meyer is offline Senior Member Blue Belt
    Join Date
    Jul 2002
    Posts
    478
    Chad,

    Look in the help file for "ImportData method"

    Also on that page of the help there is a link to:"DataSourceMoniker syntax" Notice one of the file types is UDL.

    Create a UDL file and use the MS OLE DB Provider for Oracle.

  3. #3
    msotres is offline Junior Member White Belt
    Join Date
    Aug 2003
    Posts
    3

    Oracle UDL Linking Problem

    Hi,

    I find troubles linking MapPoint to my Oracle 8i DataBase. I've created the UDL file. Then, I double-click on it, I set the DataSource attributes and the connection test is OK. I return to MapPoint, I select Data > Link Data, I choose the UDL file created before, a new window ask me for the table to import data from. When I click on the table, an error window tells me something like : "An error has been generated opening : C\mydirectory\mydatasource.udl, MYTABLE". Not very explicit!.

    Anybody has any idea?

    Thanks a lot in advance.

    Miguel.

  4. #4
    Anonymous is offline Senior Member Black Belt
    Join Date
    Jul 2002
    Posts
    5,137
    The correct syntax for the LinkData method is LinkData "Filename.udl!TableName"

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Order a recordset?
    By Shecky in forum MapPoint Desktop Discussion
    Replies: 3
    Last Post: 10-15-2004, 08:52 PM
  2. moving through recordset is slow
    By stephenmillington in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 07-07-2004, 06:28 AM
  3. ordering recordset
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 11-11-2003, 04:05 AM
  4. Deriving a recordset from a mappoint recordset
    By RichardHayes in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 09-06-2002, 03:44 AM
  5. ADO recordset
    By Monique in forum Wish List
    Replies: 0
    Last Post: 08-14-2002, 10:35 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