wiki:FdoArcSDEDirectConnect

Version 3 (modified by robertfortin, 16 years ago) ( diff )

--

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

RDBMSClient VersionRequired ArcSDE Dll
Oracle9igsrvrora9i92.dll
Oracle10ggsrvrora10g92.dll
SQL Servern/agsrvrsql92.dll

Using ArcSDE 9.3 client

RDBMSClient VersionRequired ArcSDE Dll
Oracle9igsrvrora9i93.dll
Oracle10ggsrvrora10g93.dll
Oracle11ggsrvrora11g93.dll
SQL Servern/agsrvrsql93.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.

ParameterValue
InstanceDepending 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>
Note: See TracWiki for help on using the wiki.