How to work Oracle with GeoMedia WebMap
I am trying to make GeoMedia WebMap access and display data stored in Oracle Spatial (8.1.7). I can successfully do it against the data stored in MS Access. Here are the steps I am taking and the questions that I need help with. Thanks.
1. I uploaded data stored in MapInfo TAB files to Oracle using MapInfo's EasyLoader.
2. I create a connection object in the ASP (active server page) file that will create and display the map using GeoMedia WebMap. I use the same user-id to login whose schema contains the tables created in step #1 above. I know the connection works because if I give wrong user-id, password or connection string, I get error message.
command used: obmMS.connect "OracleRRO.GDatabase","Oracle","u-id/password@ORCL","TestConn"
Question: GeoMedia allows for object model and relational connection. What does it mean. I am using the relational connection.
3. I try to read the data from Oracle using following command, and I get table not found error. The table is there! I tried both TABLENAME and SCHEMA.TABLENAME naming conventions, and none works.
set objQuery = objMS.AddQuery("qParcels","TestConn","TABLENAME")
As mentioned, the TABLENAME specified exists in the same schema and has spatial data in it.
Can someone please help me get pass this initial hurdle of successfully connecting to Oracle Spatial and displaying the map data usin GeoMedia WebMap. I can read and display the spatial data from Oracle using MapXtreme Java+JDBC no problem!
thanks for your help.
Nasir.
nnoor@mts.net