Latest Contributions by VinceAngelo

What version of Oracle are you using? (A.B.C.D notation) What version of ArcSDE are you using?  What service pack has been applied? What version of ArcGIS are you using?  What service pack has been applied?  Is your license ArcInfo, ArcEditor, or ArcView? What is the default version for the connection?  Is this version protected? - V ... View more

You can only perform SQL operations with ST_GEOMETRY or native geometry storage (PostGIS/SDO_GEOMETRY/GEOMETRY/GEOGRAPHY). There are utilities to convert an entire table to a new storage format, but it is not possible to convert SDEBINARY/SDELOB to ST_GEOMETRY/native on the fly in via SQL. - V ... View more

The ArcSDE 'C'/Java APIs and command-line utilities are only supported with Enterprise ArcSDE, which is part of ArcGIS Server. Query Layers are the means to access native SQL tables from Desktop without registration. - V ... View more

I run multiple ArcSDE instances all the time. On Windows hosts you just have to correctly configure the services so that they use the appropriate SDEHOME ('sdemon' just starts the service, so if your service is misconfigured, a '-H' flag won't help). The easiest way to do this is to: 1) Open a new CMD window 2) Set the SDEHOME variable (preferably to a path without any spaces) 3) Set the PATH variable to prepend %SDEHOME%\bin 4) Use 'sdeservice -o create' to create the service 5) [For non-Oracle installs] Use 'sdeservice -o modify' to set the Admin_database variable to the database name 6) [For remote installs] You may need to edit the dbinit.sde to use the appropriate connection variables (e.g., LOCAL instead ot ORACLE_SID) Given that you want services to start after reboot, you should *always* use Windows services to start and stop ArcSDE on Windows hosts. If it doesn't work for you, contact Tech Support to have them work you though the steps. - V ... View more

There is a 64-bit Java SDK installer in the media kit, but I haven't looked for it on the distribution site.  In the copy to which I have access, it's in an "ArcSDE_SDK" folder, which contains both 64-bit and 32-bit folders for Linux and Windows (64-bit only for Sun/IBM/HP). - V ... View more

You don't really need more than a 32-bit unique integer column and a GEOMETRY to register a table with ArcSDE. When I use SQL to create databases, I use SQL, with only a few registers at the end.  I mostly use the ArcSDE API to load the data, but only because I've got a very powerful ASCII loader -- there's no reason SQL can't be used for that as well (provided you validate your geometries to be sure they honor ArcSDE topology rules -- lines vs. simple lines, polygon boundaries which are non-intersecting,...).  There is no inherent geodatabase complexity when working with "simple feature classes", you just don't get the full monty in terms of object behaviors, complex topology, et. al. - V ... View more

Direct Connect requires that the word size environments be identical -- 32-bit app with ArcSDE 32-bit DLL and  32-bit Oracle library *or* a 64-bit app with an ArcSDE 64-bit DLL and a 64-bit Oracle client install.  Your error message indicates you're attempting to mix-n-match architectures, which cannot work.  You'll need to use a 64-bit ArcSDE install to make 64-bit Java and 64-bit Oracle work. - V ... View more

You don't need convert between geodatabase and SQL tables because ArcSDE geodatabases *are* SQL tables. If you chose to store the geometries of your geodatabase in a native SQL format, then you won't need to do any further conversion (beyond the one-time storage method change Brent suggested). If you don't want to utilize the benefits of versioning, there's no reason to do so, but there's also no reason to incur the cost of storing your tables twice (and keeping them synchronized). - V ... View more

If you have ArcSDE 9.2sp3 and ArcGIS 9.2sp6 on the same host, they will both have a DLL named "SDE.DLL", but one will be SP3 and one will be SP6.  The LoadLibraryEx() function is used to load dynamic libraries, and it searches directories in the order specified by the PATH variable.  If your SP3 bin directory is before the SP6 directory, then the 92sp6 ArcGIS will use the outdated DLL, making it unreliable. There are a multitude of reasons to install ArcSDE 9.2 SP6 and the post-SP6 patches; eliminating search order conflicts as a possible problem is one of the less pressing ones, but if it works, then the other issues won't give you trouble either. - V ... View more

If you enable tracing (with SDETRACELOC/SDETRACEMODE variables), you'll know what's wrong for sure, but 92sp3 != 92sp6, so your PATH order in resolving SDE.DLL could be the deciding factor. - V ... View more

It looks like you have an extra space in the ENVS path ("\ LIB", not "\LIB"). - V ... View more

You should contact Tech Support to find why the app is failing (this is the other side of a Network I/O (-10) error, so you'll need to tell them what you were doing when the gsrvr failed). - V ... View more

Are you running the supported SQL-Server 2005 build?  SP2 and SP3 are certified. - V ... View more

User schema geodatabases do not create another SDE schema.  They create parallel ArcSDE tables in a different schema, which work in concert with (but apart from) the existing SDE schema's tables. - V ... View more

The SRID model does not support a delete operation. I can't imagine how deleting unused entries could hurt (if they are truly unused, of course), but I can't imagine how leaving them in place would hurt either. - V ... View more