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

Connect to Oracle using UDL file

This is a discussion on Connect to Oracle using UDL file within the MapPoint Desktop Discussion forums, part of the Map Forums category; Hi, I find troubles linking MapPoint to my Oracle 8i DataBase. I've created the UDL file. Then, I double-click on ...

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

    Connect to Oracle using UDL file

    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.

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

  3. #3
    msotres is offline Junior Member White Belt
    Join Date
    Aug 2003
    Posts
    3
    Unfortunately, using MapPoint application, I don't have the possibility to write the data source in this manner : Filename.udl!TableName. Fisrt, after clicking on Data>DataLink (or CTRL+L) I have to choice the UDL file to connect to the DataBase. The connection with the DataBase works ok because a new window containing all the tables and views appears. Then, I have to choice the Table or View and the connection fails at this moment. The view which I want to link data from is a list of zip codes like the following :

    ID ZIP
    1 22563
    2 12120
    3
    4 22596

    What am I doing wrong?. What are the other alternatives? Would I have to install an Access DataBase and try with? Or would I try writing a VB app ?. Anyway, I would prefer to solve the problem using a UDL over Oracle without VB programming.

    Thanks for your help,

    Miguel.

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

    Mappoint connection to Oracle via UDL

    Has anyone managed to successfully do this? And how??!!

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

    UDL file Link

    Using MS MapPoint, (& Streets and Trips,) I found that *sometimes* you have to watch what you import with regard to blank records, or possibly in your case a blank field which is being used for geocoding, ie: zipcode.

    While this experience is not specific to .udl file types, you might try a test import range of data (query, view, range, table whatever) that does not have any blanks, at least in any fields that MapPoint looks at (Key, and geocoding fields like: zip, addr1, or any field that is not "Other data" etc.)

    If you find that solves the issue, you might edit your tables so that blanks are filled with something else that will not cause an error with MapPoint. If the error still appears, try removing all blanks in fields you assign to "other data" in MapPoint interface as well. Especially if these fields are used for grouping Multi-Symbol Maps, or any action for which MapPoint has to look at them.

    Hope this helps,
    JSAS

  6. #6
    Clueless is offline Junior Member White Belt
    Join Date
    Jan 2010
    Posts
    1

    Re: Connect to Oracle using UDL file

    Hi All,

    After 3 days of trying, I actually managed to connect my Mappoint 2009 to my Oracle 10g database using a UDL file:
    1. Under Control Panel -> Administrative Tools -> Data Sources (ODBC), in the File DSN tab, click Add.
    2. Highlight Oracle in OraDb10g_home1.
    3. Put a ; in the end of the existing line and add the foloowing lines:
    SERVER=your_server_name ;
    UID=your_login_to_the_database ; (don't use SYS)
    PWD=the_password_for_that_user ;
    4. Click Next and save under a name of your choice
    5. Confirm the database name and password again as required
    6. Create a UDL file and choose the provider to be MICROSOFT OLE DB provider for ODBC drivers. Click Next
    7. In the connection tab select the option of "use connection string" and click Build and navigate to the DNS File you've created before
    8. Repeat the database login user name and password and check the Allow saving password option
    9. Link via the created udl file in Mappoint as usual

    Good Luck!

  7. #7
    Wilfried is offline Senior Member Black Belt
    Join Date
    Nov 2004
    Location
    Belgium
    Posts
    2,433

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Using LinkData to connect over UDL-File to MSDE/SQL-Server
    By Boelling in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 11-15-2004, 10:49 AM
  2. Using MapPoint with Oracle web application
    By Anonymous in forum Bing Maps and MapPoint Web Service
    Replies: 1
    Last Post: 11-09-2004, 03:02 PM
  3. access Oracle db
    By Jade in forum MapPoint Desktop Discussion
    Replies: 3
    Last Post: 04-25-2003, 03:13 AM
  4. connect dots
    By misterb83 in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 02-13-2003, 10:57 AM
  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