Troubleshooting direct connections to an ArcSDE geodatabase
Troubleshooting direct connections to an ArcSDE geodatabase
|
| Release 9.3 |
   |
Most of the problems that occur with direct connections are a result of one of the following:
- The necessary ArcSDE direct connect drivers are not present in the connecting client application.
- The open database connectivity (ODBC) drivers are missing or incorrectly configured.
- The database is not configured to accept connections or connections have been blocked.
Required direct connect drivers not installed
The release version of the software is saved in a system table in the geodatabase. When a client connects to the geodatabase, the release number in the geodatabase is compared to the ArcSDE direct connect drivers available to the client application.
For most releases of ArcSDE, the ArcSDE geodatabase and the connecting client have to be at the same release level, often including the same service pack. When the release number in the geodatabase does not match the direct connect drivers in the client, one of the following errors is returned:
ArcSde Direct Connect driver release isn't compatible with ArcSde database instance release
or
SDE Server Release is not compatible with the current Release
Newer DC driver attempting to connect to older ArcSde instance
(This tells you that the connecting client is a newer release than the geodatabase.)
Older DC driver attempting to connect to later ArcSde instance
(Indicates the connecting client is an older release than the geodatabase.)
It is possible for 9.3 clients to make a direct connection to a 9.2, 9.1, or 9.0 ArcSDE geodatabase if the appropriate direct connect drivers are installed to the ArcGIS or ArcIMS client. These drivers can be obtained by running the pre-9.3 GDB direct connect setup, which is available on 9.3 client installation media.
It is also possible for an ArcGIS 9.2 service pack 5 (SP5) or later 9.2 service pack release client to make a direct connection to an ArcSDE 9.3 geodatabase if the 9.3 direct connect drivers are installed on the client. The setup to install these drivers can be downloaded from the ESRI support site download page. The setup is called the ArcGIS 9.3 GDB Direct Connect for 9.2 clients.
ODBC drivers not present or improperly configured
Each database management system (DBMS) has different requirements when it comes to setting up ODBC connections. See the following topics for instructions in setting up these connections:
Setting up a direct connection to DB2Setting up a direct connection to InformixSetting up a direct connection to OracleSetting up a direct connection to PostgreSQLSetting up a direct connection to SQL Server
Actual configuration of the ODBC connection is required for DB2, Informix, and Oracle databases. If these are not properly set up on the client machine, direct connections from that client will not work.
ArcGIS clients making a direct connection to an ArcSDE geodatabase in DB2 must have a local user account that has the same user name as specified for the ODBC connection to the server.
Database not configured to accept connections
Databases may require additional configuration to allow remote clients to connect. For example, to connect to a PostgreSQL database, the pg_hba.conf file must be altered to allow clients to make a connection. This configuration file resides in the PostgreSQL installation location. Consult the ArcSDE for PostgreSQL installation guide and the PostgreSQL documentation for information on altering the pg_hba.conf file to allow remote connections.
SQL Server databases need to have the network protocols set to accept connections over the network. To check the network protocols, open the Microsoft SQL Server Configuration Manager, expand SQL Server Network Configuration in the tree, click the Protocols for <your SQL Server instance>, right-click the TCP/IP protocol, and click Enable.
Connections have been blocked
There are several ways a database administrator (DBA) could prevent users from connecting to the geodatabase. This is typically done to allow the DBA to perform certain administration tasks, such as backups or compress operations, without any users connected to the database.
To prevent new users from logging in to the geodatabase, the DBA may pause the geodatabase. When a user tries to connect to a geodatabase that is paused, the following message is returned:
"Failed to connect to database.SDE not accepting connection requests"
If you receive this message when attempting to connect, contact your DBA to determine if the block was intentional and, if so, when you should expect the geodatabase will be available again.
NOTE: This applies to both direct connections and connections made through an ArcSDE service.
The DBA could also block connections through functionality provided in the database management system. For example, a SQL Server instance can be paused, preventing new connections from being made to the database. Most of the other supported DBMSs can be placed in a quiescent mode, which also prevents new connections from being made to the database.
