MapForums

msotres · #1 (**permalink**) 08-28-2003

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.

Anonymous · #2 (**permalink**) 09-10-2003

the correct syntax is LinkData "Filename.udl!TableName"

msotres · #3 (**permalink**) 09-17-2003

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.

Anonymous · #4 (**permalink**) 02-27-2004

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

Anonymous · #5 (**permalink**) 06-13-2004

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Using LinkData to connect over UDL-File to MSDE/SQL-Server	Boelling	MapPoint 2006/2009 Discussion	1	11-15-2004 09:49 AM
Using MapPoint with Oracle web application	Anonymous	MapPoint Web Service and Virtual Earth	1	11-09-2004 02:02 PM
access Oracle db	Jade	MapPoint 2006/2009 Discussion	3	04-25-2003 02:13 AM
connect dots	misterb83	MapPoint 2006/2009 Discussion	0	02-13-2003 09:57 AM
I'd like to connect my notebook with GPS through T....	Anonymous	MapPoint 2006/2009 Discussion	1	02-21-2002 11:51 PM

MapForums

Connect to Oracle using UDL file

Connect to Oracle using UDL file

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Similar Threads