Solved! Go to Solution.
Enterprise geodatabases, which run in many different flavors of RDBMS software, require an
ArcGIS for Server Enterprise license. Desktop (formerly known as "Personal") and Workgroup
multiuser geodatabases (which only run in SQL-Server Express, and are subject to restrictions
in user count, storage, RAM, and CPU cores) are available at different licensing levels.
The Multiuser Geodatabase page breaks down the options.
- V
Some of you here said that if I do not install ArcSDE application on the server, and use only ArcGIS for Desktop, I'll need to install an Oracle Client (32bit ofcourse) on each desktop that will direct connect to the geodatabase via ArcCatalog/ArcMap.
However, I need to be able to connect to the geodatabase (direct connection or application connection) via a desktop without an Oracle client installed. For that, I'll need to install the ArcSDE application on the server, correct?
Also, will I need to use application connection or a direct connection?
Please note you need to add the following line to your Windows services file of your client PC running ArcGIS for Desktop per installation instructions for the ArcSDE Application Server. Please note this has to be done on each machine connecting to your Application Server!:
esri_sde 5151/tcp
The Windows services file is simply called "services" without a file extension and in Windows 7 located in:
C:\Windows\System32\drivers\etc
Ariel, if you need the full geodatabase functionality but can't install the Oracle Client, than yes, your only option is to install and run an ArcSDE Application Server (which isn't a bad thing or so ;)).
In this scenario, the connection is called an Application Server connection, so you won't be using Direct Connect.
Please note you need to add the following line to your Windows services file of your client PC running ArcGIS for Desktop per installation instructions for the ArcSDE Application Server. Please note this has to be done on each machine connecting to your Application Server!:
esri_sde 5151/tcp
The Windows services file is simply called "services" without a file extension and in Windows 7 located in:
C:\Windows\System32\drivers\etc
I have a question though - I've heared a rumor that ESRI will probably eventually stop supporting Application Server Connection, is that true?
What is the "recommended" method of connection by ESRI?