Hi All,
Jonathan is correct. The user name is the database name so I can use it to log
in via sql developer or sqlplus.
I can connect directly via ArcGIS and via FME. The string I use in the instance
section for ArcGIS and for FME is sde:oracle11g:TESTDB.COM.AU, which is a
little different to the way the Geoserver manual suggests as there is the extra
":/". I have tried to use the same instance in Geoserver that I use in ArcGIS
and FME but still no luck.
Jonathan, have you managed to do a direct connect to ArcSDE in Geoserver? If
you have could you send me an example of the credentials you used and maybe an
example of what you used in ArcGIS so I can see what you do differently between
the two applications? (Same goes for any of you that may have successfully
connected via a direct connect)
Cheers
Pete
From: Jonathan Moules [mailto:[email protected]]
Sent: Monday, 30 September 2013 8:23 PM
To: Andrea Aime
Cc: von Minden, Peter A (DPIPWE); [email protected]
Subject: Re: [Geoserver-users] I need help with an ArcSDE direct Connect in
Geoserver 2.4.0
> * Are the username/password are the same for sde and the database? In direct
> connect the guide says to use the username/password of the geodatabase
I'd be surprised if the passwords are different. SDE just transparently passes
the credentials straight through to the database; the username/password are
actually the database ones.
Peter - Can you direct connect from ArcGIS to Oracle?
Jonathan
On 30 September 2013 07:13, Andrea Aime
<[email protected]<mailto:[email protected]>> wrote:
On Mon, Sep 30, 2013 at 4:31 AM, von Minden, Peter A (DPIPWE)
<[email protected]<mailto:[email protected]>>
wrote:
But a direct connect using the following details does not work:
Server name or IP address * = none, Port * =
sde:oracle11g:/:TESTDB.COM.AU<http://TESTDB.COM.AU>, Instance name = none,
User * = test_user, Password = testPassw0rd
Hi,
know nothing of direct connect and never tried it but there are a couple of
things that seem odd/out of place:
* Are the username/password are the same for sde and the database? In direct
connect the guide says to use the username/password of the geodatabase
* The syntax reported by ESRI for direct connect provides a few options
http://webhelp.esri.com/arcgisserver/9.3/java/index.htm#geodatabases/arcsde-2034353163.htm,
you seem to be going with the schema name one, however, can schema name
contain dots?
Cheers
Andrea
--
==
Our support, Your Success! Visit http://opensdi.geo-solutions.it for more
information.
==
Ing. Andrea Aime
@geowolf
Technical Lead
GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054 Massarosa (LU)
Italy
phone: +39 0584 962313<tel:%2B39%200584%20962313>
fax: +39 0584 1660272<tel:%2B39%200584%201660272>
mob: +39 339 8844549<tel:%2B39%20%C2%A0339%208844549>
http://www.geo-solutions.it
http://twitter.com/geosolutions_it
-------------------------------------------------------
------------------------------------------------------------------------------
October Webinars: Code for Performance
Free Intel webinars can help you accelerate application performance.
Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from
the latest Intel processors and coprocessors. See abstracts and register >
http://pubads.g.doubleclick.net/gampad/clk?id=60133471&iu=/4140/ostg.clktrk
_______________________________________________
Geoserver-users mailing list
[email protected]<mailto:[email protected]>
https://lists.sourceforge.net/lists/listinfo/geoserver-users
This transmission is intended for the named addressee(s) only and may contain
sensitive or protectively marked material up to RESTRICTED and should be
handled accordingly. Unless you are the named addressee (or authorised to
receive it for the addressee) you may not copy or use it, or disclose it to
anyone else. If you have received this transmission in error please notify the
sender immediately. All email traffic sent to or from us, including without
limitation all GCSX traffic, may be subject to recording and/or monitoring in
accordance with relevant legislation.
________________________________
CONFIDENTIALITY NOTICE AND DISCLAIMER
The information in this transmission may be confidential and/or protected by
legal professional privilege, and is intended only for the person or persons to
whom it is addressed. If you are not such a person, you are warned that any
disclosure, copying or dissemination of the information is unauthorised. If you
have received the transmission in error, please immediately contact this office
by telephone, fax or email, to inform us of the error and to enable
arrangements to be made for the destruction of the transmission, or its return
at our cost. No liability is accepted for any unauthorised use of the
information contained in this transmission.
------------------------------------------------------------------------------
October Webinars: Code for Performance
Free Intel webinars can help you accelerate application performance.
Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from
the latest Intel processors and coprocessors. See abstracts and register >
http://pubads.g.doubleclick.net/gampad/clk?id=60134791&iu=/4140/ostg.clktrk
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
