English

FAQ: Can I use Direct Connect and the ESRI OLE DB provider to connect to an ArcSDE geodatabase?

Question

Can I use Direct Connect and the ESRI OLE DB provider to connect to an ArcSDE geodatabase?

Answer

Yes. The following ADO connection string examples illustrate how to use Direct Connect with the ESRI OLE DB provider:

SQL SERVER:
sConstr = "Provider=ESRI.GeoDB.OleDB.1;Location=;
Data Source=<my database>;User Id=<my username>;Password=<my password>;Version=sde.DEFAULT;Extended Properties=workspacetype=esriCore.SdeWorkspaceFactory;Instance=sde:sqlserver:<my server>;Geometry=WKB"

ORACLE:
sConstr = "Provider=ESRI.GeoDB.OleDB.1;
Location=;Data Source=;User Id=<my username>;Password=<my password>@<my oracle service name>;Version=sde.DEFAULT;Extended Properties=workspacetype=esriCore.SdeWorkspaceFactory;Instance=sde:oracle;Geometry=WKB"

Related Information