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>