files / 421_гис-2 / arcview 3.2a / DbAccess

More information about ArcView Database Access 2.1a for ArcView GIS 3.2a

This release allows you to use Database Access to connect to
ArcSDE 8 servers. There have been no changes to functionality
since Database Access 2.1 was released. This release includes
some bug fixes that improve support for External Oracle Spatial
Geometry data.

Contents

1.0 Database Access Support Matrix for SDE
2.0 Database Access documentation
3.0 Sample extensions and scripts for SDE and ODBC
4.0 Setting Up Your Machine
5.0 Known Issues for Database Access 2.1a


----------------------------------------------------------------------------------

1.0 Database Access Support Matrix for SDE

Database Access 2.1a allows you to use SDE and ArcSDE data in
ArcView GIS 3.2a. Because ArcView GIS, Database Access, and ArcSDE are
developed on different schedules, it is important to maintain a record of
which ArcView GIS release Database Access works with, and which SDE servers
are supported. The matrix below illustrates which versions of these products
you can use together.


======================================================================================
| |ArcSDE | | | | |
Database| |Client | | | |ArcSDE8 |
Access |ArcView|Library| SDE 3.0 |SDE 3.0.1 | SDE 3.0.2 |Servers |
Version |Version|Version| Servers |Servers | Servers | |
=======================================================================|==============|
| | | | | | |
2.1a | 3.2 |8.0 |Oracle |Oracle |Oracle |Oracle |
| | | |SQL Server |DB2 Extender |ArcSDE 8 |
| | | |Sybase |DB2 Universal | for Coverages|
| | | | | Database (pre-rel) |SQL Server |
| | | | |SDE for Coverages | |
| | | | |SQL Server | |
| | | | |Informix Dynamic | |
| | | | |Sybase | |
======================================================================================|



2.0 Database Access documentation

The on-line documentation for Database Access 2.1a contains the most
up to date information. Whether you are new to the Database Access extension
or have used previous versions of the extension, please review the
following on-line help topics which can be accessed from the ArcView GIS 3.2a
online Help. Click on the Contents tab, double click the Extensions book, then double
click Database Access to find the following topics:

What's new in Database Access?
What is a database table?

The topic, changes to classes and requests, can be found by typing Database Access
in the Arcview GIS 3.2a online Help index.

These topics outline the new functionality and how the extension
has changed.

The Database Access manual is in a Portable Document Format(PDF) file.
After the Database Access Extension has been installed, the
documentation file, dbaccess.pdf, will be located in the av_gis30\avdocs
installation directory.

NOTE: There is a Database Access extension object model diagram in the on-line
help which can be used to access help on the various Database Access classes.
The help system may fatal if you use this object model diagram topic
extensively to get class help.


3.0 Sample extensions and scripts for SDE and ODBC

This extension includes several sample extensions and scripts for SDE and
ODBC. For more information on these samples, double-click the Extensions
book in the Help Contents page, then the Database Access book and refer to
the Sample scripts and extensions book. Additional scripts, referenced by
the Avenue request help, can be located by typing "database access" in the
on-line help's Index. Select Avenue examples under the Database Access
extension heading, then click Display.

Scripts that have "SDEODBC" in the title will work with either ODBC,
SDE or ArcSDE data. If the script or extension deals with spatial features,
then it is SDE specific.


4.0 Setting Up Your Machine

If you are new to using SDE/ODBC data in ArcView GIS, you can find out
how to set up your computer by referring to the online help for the
Database Access extension. Double-click the Extensions book in the contents
page, then the Database Access book. The Spatial Database Engine (SDE) and
Using Open Database Connectivity (ODBC) books contain topics for setting up
your computer.


5.0 Known Issues for Database Access 2.1a

The ArcView GIS 3.2a online Help includes Known Issues for Database Access.
To review these issues, double-click the Extensions book in the contents page,
then the Database Access book. The "Known issues" help topic is located under the
Troubleshooting book. The following Known Issues are additional items not found
in the online Help.


Known Issues with SDE and ArcSDE


1) ArcSDE for SQL Server will return an error if you try to lock records by executing
a sql statement that includes either the TABLOCKX or UPDLOCK locking hints. These
locking hints are unsupported in select statements at ArcSDE 8.0.2.

2) When using ArcSDE 8 for SQL Server and counting the number of features
in a selection log from a one to many joined database theme, you may not
get the expected results. For example, if you select a polygon that has
10 records joined to it use the count request on the selection log, it will
report that only one record is selected. The status bar, however, will indicate
that 10 records have been selected.

3) When creating a database table with External Oracle Spatial Geometry Type data,
you will get the following error if the query includes the spatial column: "DBMS Object types cannot be fetched from the API". This is because you can't display
the data from an External Oracle Table's spatial column in a database table. The
workaround is to exclude the spatial column from the query.

4) When creating an SDETable with ArcSDE Spatial Geometry type data, you
will get an "Underlying DBMS error" message if you try to truncate the spatial column of
the layer.