Latest Contributions by VinceAngelo

I run between three and eight ArcSDE instances on each machine under my control, usually different versions (and/or service packs), and almost always at least two different database products (my current laptop is running 10.0sp1 w/ Oracle 11g, 9.3.1sp2 w/ SQL-Server 2008, 10.0sp1 w/SQL-Server 2008. and 10.0sp1 w/ PostgresSQL 8.3.8), so yes they can live together. BUT: Doing so is not supported, so you won't find any instructions (this is probably the most relevant thread). SQL-Server 2008 isn't supported with ArcSDE 9.2, either (2008 support was introduced at 9.3sp1). - V ... View more

How many weeks are you willing to devote to this task? Coding this yourself from scratch can be expected to take 5-8 weeks, dependng on how thorough a job you need to do. The ArcSDE 'C' API does not have shapefile access routines. It can generate the '.shp' file features (SE_shape_as_binary), but you'd have to code all the rest, including the file headers, the '.shx' contents, and '.dbf' layout (and conversion for the attributes). The spatial index format for shapefiles used by ArcGIS is not documented anywhere. The 'sde2shp' command, combined with 'sdetable -o create_view', is the most robust (and supported) way to accomplish this goal. The 'sdequery' utility (found in se_toolkit) has native ability to define a multi-table join, alias the columns, and export as a shapefile; if you don't want to use 'sde2shp', then I'd recommend that instead. Shapefiles are very nearly archaic. They don't support NSTRING international characters, numeric nulls, or dates at finer than "day" resolution. When I need to copy data between instances in a format that allows coordinate reference change (e.g., not 'sdeexport'), I use ASCII files (also created by 'sdequery'). I'm working on using the File Geodatabase API to add FGDB creation to 'sdequery' on Windows and Linux platforms. - V ... View more

It would help if you give a *lot* more details on your configuration... + What is your ORACLE_HOME? + What is your ORACLE_SID? + What does listener.ora contain? + What does tnsnames.ora contain? + What is your SDEHOME? + What is in your PATH? + Are you using the post-install GUI?  If so, what values have you plugged in? + Have you tried using the manual post-install proceess? + Have you tried executing 'sdesetup -o prerequisite_check'? + What is in your dbinit.sde and services.sde files? + What is in your sde_setup.log? It generally takes me five minutes after Oracle install completes to have ArcSDE running. My process does have some quirks: + I *never* install software in a directory with spaces or special characters (e.g., D:\Esri) + I copy the install directory to an alternate directory, uniquely named for each instance (e.g., C:\Esri\sdeora10sp1_mysid) and manually set the SDEHOME, ORACLE_HOME, PATH and ORACLE_SID appropriately + I manually create the SDE tablespace and SDE user, edit the services table with Notepad, and use the command-line 'sdesetup' and 'sdeservice' utilities to configure ArcSDE in a command window. - V ... View more

There may be a few more milliseconds in the first prepare of a SQL query over that of a view, but the subsequent queries are likely to be cached by the optimizer.  Each draw creates a query in each representation.  You might find that numeric column return results are slightly different (more columns will map to 64-bit float).  In the end, spatial views exist to join SDELOB and SDEBINARY storage layers to other tables, while SDO_GEOMETRY and ST_GEOMETRY views should be exposed by registration or Query Layers. - V ... View more

Have you tried using the Beta-3 release?  These macros are all defined appropriately in FileGDBCore.h (which is included by FileGDBAPI.h). - V ... View more

Yes, GEOMETRY and GEOGRAPHY were introduced at SQL-Server 2008. You can still whip up a web service to do inserts using the 'C' or Java ArcSDE APIs, but this will not be as simple. - V ... View more

It's not optional, it's required (64-bit applications requre 64-bit libraries). - V ... View more

Yes, you can use 64-bit Oracle for a 64-bit ArcSDE application.  But ArcCatalog s only available as a 32-bit application (until 10.1 is released), so it requires a 32-bit Oracle client.  Catalog is only required to upgrade a geodatabase, not for initial install. - V ... View more

It's not Oracle-specific.  Esri has a ST_GEOMETRY type implementation for all supported database platforms *except* MS SQL-Server (the others support 'blade' creation). Microsoft's GEOMETRY/GEOGRAPHY operators are case-sensitive, so be sure to match case as you follow the documentation. - V ... View more

The intent was to allow the DLLs to be freely distributable with applications developed using the API. Distributing the full API as part of installs might distribute a less recent version than the one avaliable from Esri (which is a similar situation to why individual users must download the Java JDK, and not have it distributed elsewhere).  What particular language has you concerned? The current code is in beta, and subject to the Beta Agreement (no early distribution). -V ... View more

At initial install it's always wise to cancel the post-installer that starts after install, and apply one of the most recent service packs (N or N-1). Given the trouble others have been having with 10sp2 you might want to wait on sp2 deployment and just install 10sp1. You do not ever need to apply multiple service packs, since, by definition, they are always cumulative (spN always includes the fixes of sp1...sp[N-1]). At ArcSDE 10 and higher, the upgrade process is done through ArcCatalog (if you have any geodatabase functionality in use).  In this case, you would need a 32-bit Oracle client on the Catalog upgrade host for Direct Connect (which is required for upgrade). - V ... View more

The ASCII tools have fairly robust type conversion tools.  I'm working on a mathematical expression processor for math evaluation and a true "Con" operator to allow inline conditional operation (right now you'd need to reject to a named reject file, then use a different control file). - V ... View more

Oracle 10.2.0.1 isn't supported for either ArcSDE 9.3.1 or 10.0 (one of the primary problems was spurious permission errors during setup).  The minimum supported Oracle release is 10.2.0.3. - V ... View more

Are the user-set ids in fact unique? Even when the user-set IDs are not unique, it doesn't usually crash ArcMap (stuff just goes missing). Have you applied SQL-Server 2008 SP1 or SP2 or R2 SP1? Are any of the shapes west of -180W? Best practice is to give a buffer off the lower-left corner in the coordref X/Y origin (I use '-x -210,-120,1000000'), but even that shouldn't fatal the application (queries just terminate early with a "load buffer" error). Since you have ArcSDE installed, the 'asc2sde' utility is available for scheduled loading of ASCII flat files into layers (in lieu of SSIS).  Also in se_toolkit is the 'sdequery'  utility, which can be used to validate two-tier and three-tier spatial queries directly with the ArcSDE API. - V ... View more

All Esri service packs are cumulative (SP2 includes SP1).  This is also true of SQL-Server. The Esri-supported releases of SQL-Server 2005 are SP2 and SP3. - V ... View more