I want to connect Oracle11g via ArcObjects. Currently I am using the connection string as given below which connect SDE schema GDB by default. But now I want to access a particular Oracle user Schema geodatabase. Could anyone please provide me that connection string syntax which access/specifying a particular Oracle user Schema geodatabase? Thanks in Advance
string connString = "DB_CONNECTION_PROPERTIES=server:port/service;DBCLIENT=oracle;USER=user;password=pass";
Normally for user-schema GDBs the 'Instance' property should be used. The formatting would look like this:
sde.oracle11g:server/sid:schema