Autodesk Map 5.0 and Oracle Spatial

[infotech]

What is the procedure to connect to Oracle spatial from MAP 5.0?
When we invoke the "ORACONNECT" button we got the following
error. Please respond to our error message.

AcMapOrclUI.arx cannot find a procedure that it needs.
; error: ARXLOAD failed

[Anonymous]

see thread from 20/7/01

> Should I make some additional configuration
first?

Warren almost got it - you need the Oracle client (installed and
configured)
but this error comes from a lack of the "OO4O" component ("Oracle
OLEDB for
Objects"  I think).

This is also freely downloadable
from Oracle - I read it is needed somewhere
but now can't find the
reference.  The Map help should certainly make
it
clearer.

   Crispin


href="http://www.IME-GIS.co.uk">www.IME-GIS.co.uk

style="BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">

"infotech" <
href="mailto:gvchanti@rediffmail.com">gvchanti@rediffmail.com> wrote in
message
href="news:f071640.-1@WebX.maYIadrTaRb">news:f071640.-1@WebX.maYIadrTaRb...

What
is the procedure to connect to Oracle spatial from MAP 5.0?
When we invoke
the "ORACONNECT" button we got the following
error. Please respond to our
error message.

AcMapOrclUI.arx cannot find a procedure that it needs.
; error: ARXLOAD
failed

[Anonymous]

We got one step further but then it stopped again: what does one have to
do to create a spatial index?

After creating user/scheme I logged on to oracle from Map
After exporting some testdata, Map had created serveral tables
automatically:

ADMPALIASDEFINITION,
ADMPDRAWINGNAMES,
ADMPENTITIES,
ADMPLAYERDEFINITION,
ADMPLINKTEMPLATES,
ADMPODDEFINITIONS,
ADMPODTANSITABELL,
ADMPQUERIES,

But neither "index spatial files" or "import data" worked. We get error
messages when trying to compute extents: "unable to update metadata
table -table doesn't exist" We assume (no helptopic) that one has to
create its own spatial index file.
So we created manually a table called

SDO_GEOM_METADATA

but it didn't work either. Map was still not able to performe indexing
on the spatial data.
We guess that it might have to do something with different versions of
Oracle: we got the tablename from 8.1.5 but MAP required the 8.1.6
client
Am I right? Does somebody have the correct table-, columnnames for
spatial index table ?

/Hans-Jørg


"Crispin @ IME-GIS.co.uk" wrote:

> see thread from 20/7/01 > Should I make some additional configuration
> first?
>
> Warren almost got it - you need the Oracle client (installed and
> configured)
> but this error comes from a lack of the "OO4O" component ("Oracle
> OLEDB for
> Objects" I think).
>
> This is also freely downloadable from Oracle - I read it is needed
> somewhere
> but now can't find the reference. The Map help should certainly make
> it
> clearer.
>
> Crispin
>
> www.IME-GIS.co.uk
>
>
>
> "infotech" wrote in message
> news:f071640.-1@WebX.maYIadrTaRb...What is the procedure to
> connect to Oracle spatial from MAP 5.0?
> When we invoke the "ORACONNECT" button we got the following
> error. Please respond to our error message.
>
> AcMapOrclUI.arx cannot find a procedure that it needs.
> ; error: ARXLOAD failed
>

[Anonymous]

Map created index all OK for us (admittedly logging onto a system account on
test server) on an 8.1.6 DB. Two additional SDO tables were created (see
below).

Crispin



SQL> select * from all_tables where table_name like 'SDO%';

OWNER TABLE_NAME
TABLESPACE_NAME CLUSTER_NAME
------------------------------ ------------------------------ --------------
---------------- -------------
BUFFER_ ROW_MOVE GLO USE DURATION SKIP_COR MON
------- -------- --- --- --------------- -------- ---
MDSYS SDO_GEOM_METADATA_TABLE SYSTEM
DEFAULT DISABLED NO NO DISABLED NO

MDSYS SDO_INDEX_METADATA_TABLE SYSTEM
DEFAULT DISABLED NO NO DISABLED NO


"Hans-Jörg Schneidt" wrote in message
news:3B72A767.E06F4242@vianova.no...
> We got one step further but then it stopped again: what does one have to
> do to create a spatial index?
>
> After creating user/scheme I logged on to oracle from Map
> After exporting some testdata, Map had created serveral tables
> automatically:
>
> ADMPALIASDEFINITION,
> ADMPDRAWINGNAMES,
> ADMPENTITIES,
> ADMPLAYERDEFINITION,
> ADMPLINKTEMPLATES,
> ADMPODDEFINITIONS,
> ADMPODTANSITABELL,
> ADMPQUERIES,
>
> But neither "index spatial files" or "import data" worked. We get error
> messages when trying to compute extents: "unable to update metadata
> table -table doesn't exist" We assume (no helptopic) that one has to
> create its own spatial index file.
> So we created manually a table called
>
> SDO_GEOM_METADATA
>
> but it didn't work either. Map was still not able to performe indexing
> on the spatial data.
> We guess that it might have to do something with different versions of
> Oracle: we got the tablename from 8.1.5 but MAP required the 8.1.6
> client
> Am I right? Does somebody have the correct table-, columnnames for
> spatial index table ?
>
> /Hans-Jørg
>
>
> "Crispin @ IME-GIS.co.uk" wrote:
>
> > see thread from 20/7/01 > Should I make some additional configuration
> > first?
> >
> > Warren almost got it - you need the Oracle client (installed and
> > configured)
> > but this error comes from a lack of the "OO4O" component ("Oracle
> > OLEDB for
> > Objects" I think).
> >
> > This is also freely downloadable from Oracle - I read it is needed
> > somewhere
> > but now can't find the reference. The Map help should certainly make
> > it
> > clearer.
> >
> > Crispin
> >
> > www.IME-GIS.co.uk
> >
> >
> >
> > "infotech" wrote in message
> > news:f071640.-1@WebX.maYIadrTaRb...What is the procedure to
> > connect to Oracle spatial from MAP 5.0?
> > When we invoke the "ORACONNECT" button we got the following
> > error. Please respond to our error message.
> >
> > AcMapOrclUI.arx cannot find a procedure that it needs.
> > ; error: ARXLOAD failed
> >
>

[DWalsh]

Hans,

The Map command you need is ORAINDEX. You can also use the Oracle Spatial Index Advisor to generate an index.

Are you using 8.1.5? That might be the problem. We have only tested gainst 8.1.6.

Cheers,
David Walsh

[Anonymous]

Problem solved. I used a 8.1.6 client towards an 8.1.5 server -that
doesn't work
We installed 8.1.6 server and it works without problems.

Thanks!


DWalsh wrote:

> Hans,
>
> The Map command you need is ORAINDEX. You can also use the Oracle
> Spatial Index Advisor to generate an index.
>
> Are you using 8.1.5? That might be the problem. We have only tested
> gainst 8.1.6.
>
> Cheers,
> David Walsh