#1 ( dbms2sde ) in ArcSDE 8.2 environment

[Anonymous]

Mark Ohrenschall,

I have recently downloaded your tool ( dbms2sde )
and look forward to utilizing it to spatially
enable a point based business table in Oracle
which has a Lat and Long. We like the prospect
that this tool has the potential of not only
loading our data into SDE but is also capable
deriving the spatial column needed for future
analysis with our ESRI suite of GIS tools.

I have installed the tool on a server which is
running ArcSDE 8.2 and Oracle 8i. But when I run
the executable the program seems to be looking for
the libraries from ArcSDE 8.1x. I have taken a
look at the C code which has some comments in the
header which seem to indicate that the Makefile is
creating pointers to the ArcSDE 8.1x libraries.

Do you have an updated version of ( dbms2sde )
which will execute in an ArcSDE 8.2 environment.
This would be very helpfull for us as we cannot
utilize the tool in our current environment in it's
current state.

If you do not have an updated version of
( dbms2sde ) could you please let me know if I am
correct in summizing that the ArcSDE 8.1 pointers
are being defined in the makefile and let me know
if and how I might modify the compiled code.

This is a much needed utility that we would like
to enable and we would appreciate any help that you
can give us in reaching this end.

Thank you,
Roxanna Roberts
Sr. GIS Analyst
Fannie Mae
(202)752-1064
( Roxanna_L_Roberts@fanniemae.com )

[Mark Ohrenschall]

Logged In: YES
user_id=586167

Hi Roxanna,

You should be able to build dbms2sde with the 8.2 ArcSDE
libraries without modifying any source code. Simply edit the
makefile to refer to the 8.2 libraries instead of the 8.1 libraries.

Incidentally, I am able to use the 8.1 version of dbms2sde
against an 8.2 ArcSDE server, so if you have the 8.1 client
libraries you could probably use dbms2sde as distributed.

I haven't release an 8.2 build of dbms2sde because right now
we only have the Windows and Linux 8.2 client libraries, and
I'm waiting to see if we're going to do a Solaris install. I'm
presently distributing PC and Solaris dbms2sde binaries, and
I may end up discontinuing Solaris support in favor of Linux
support.

Let me know if you have any further problems or comments.

Thanks,

Mark

[Nobody/Anonymous]

Logged In: NO

I have changed the variables in the Makefile to point to the
ArcSDE 8.2 libraries but the ( dbms2sde ) program is still
looking for a ( libsg80.so ). Is this an ArcSDE 8.0 library.
And is this library being called someplace other than the
Makefile.

Thanx for your help :o)

[Mark Ohrenschall]

Logged In: YES
user_id=586167

Hi Roxanna,

I apologize for asking the obvious, but have you removed the
distributed version of dbms2sde, and you are running the
dbms2sde binary that you created by running make? (Odd it's
complaining about libsg80.so and not libsg81.so...)

Here is the makefile I used to create an 8.2 version of
dbms2sde on release 2.4.18-10smp of Linux:

SDEINCDIR = /usr/local/esri/sdeexe82/include
SDELIBDIR = /usr/local/esri/sdeexe82/lib

SDEFLAGS = -I$(SDEINCDIR)
SDELIBS = -ldl -lnsl -lrt -lsg82 -lpe82 -lsde82

LDFLAGS = -lm $(CFLAGS)
LINKER = $(CC)

CC = gcc $(CFLAGS) $(SDEFLAGS) -DFF_ALPHA

dbms2sde: dbms2sde.c dbms2sde.o
@$(LINKER) -L$(SDELIBDIR) $(LDFLAGS)
dbms2sde.o $(SDELIBS) -o $@

Mark

[Nobody/Anonymous]

Logged In: NO

are there any special considerations if I am attempting to run
this utility in the Win2k environment?

[Mark Ohrenschall]

Logged In: YES
user_id=586167

As for the Win2k environment -- I don't think so. I routinely (well, used to...) run dbms2sde on Solaris, Linux, and
DOS.