Using Direct Connect with FDO Provider for ArcSDE
FDO Provider for ArcSDE will allow to use direct connect mode on Windows if you have version 3.3.2 and above.
Important: Some clients might not enable the connection using direct connect mode because of the order of connection parameters input. This will require client to be changed to support it.
Installation
Note: Although it is currently not necessary to establish a connection in direct mode, sde.dll is still required to be present in order for the provider to work. Other dlls required for normal connection are not necessary.
One of the following dlls must in the path. The dll that is needed depends on the following:
- which type of database is used as the ArcSDE backend (Oracle or SQL Server)
- which version of Oracle client is used (9i, 10g, 11g)
- which version of ArcSDE server is used (9.2 or 9.3)
Using ArcSDE 9.2 client
| RDBMS | Client Version | Required ArcSDE Dll |
| Oracle | 9i | gsrvrora9i92.dll |
| Oracle | 10g | gsrvrora10g92.dll |
| SQL Server | n/a | gsrvrsql92.dll |
Using ArcSDE 9.3 client
| RDBMS | Client Version | Required ArcSDE Dll |
| Oracle | 9i | gsrvrora9i93.dll |
| Oracle | 10g | gsrvrora10g93.dll |
| Oracle | 11g | gsrvrora11g93.dll |
| SQL Server | n/a | gsrvrsql93.dll |
Connection Parameters
The connection parameters depend on the type of RDBMS used. Since the connection is not established in pending mode, the datastore parameter is required to be set in order to establish the connection.
| Parameter | Value |
| Instance | Depending on the type and version of the RDBMS client sde:oracle9i sde:oracle10g sde:oracle11g sde:sqlserver :<server> |
| username | <username> |
| password | <password> For oracle, add the service name <password>@<oracle service> |
| Datastore | <datastore> |
