I'm developing an application for our sales reps that replicates customer information to a local Oracle Lite (10.2.0.1 WIN32) database.
We're planning to use MapPoint to map some of this data for the reps.
Since MapPoint only opens a UDL file or Access database, I created a simple UDL file on my desktop that uses the stock Micorosft OLEDB to ODBC driver to connect to Oracle Lite. The "Test Connection" succeeds without error.
When I open MapPoint 2004 and attempt to link data to the UDL file, I get a list of tables in my replicated data set. I choose a table, click next, and then get an error (within about 2 seconds) "There was a problem opening [the_olite_udl_file.udl], MY_TABLE_NAME".
I can create an empty Access database and link to the same exact data just fine, then use MapPoint to link to the access database successfully.
In summary, Excel and Access can successfully link and query data from the Lite database. msql connects to Lite and can query as well. MapPoint can successfully link and query an Access database. MapPoint can successfully connect to a full Oracle 10g database through the Oracle OLEDB provider. MapPoint fails to connect to the Lite ODBC driver with the above non-descript error message.
I posted this same request on the Oracle Lite forum
at article 37629 in case this winds up being and Oracle Lite issue.