Oracle Connection With SharePoint List.

%3CLINGO-SUB%20id%3D%22lingo-sub-872083%22%20slang%3D%22en-US%22%3EOracle%20Connection%20With%20SharePoint%20List.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-872083%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EI%20want%20to%20create%20Oracle%20connection%20with%20the%20sharepoint%20List%2C%3C%2FP%3E%3CP%3Ei%20am%20using%20the%20event%20receiver%20on%20an%20list%20item%20to%20make%20CRUD%20Operations%2C%3C%2FP%3E%3CP%3E%3CBR%20%2F%3Eusing%20(OracleConnection%20conn%20%3D%20new%20OracleConnection(connstring))%3CBR%20%2F%3E%7B%3CBR%20%2F%3Eusing%20(OracleCommand%20cmd%20%3D%20new%20OracleCommand(command%2C%20conn))%3CBR%20%2F%3E%7B%3C%2FP%3E%3CP%3Ebut%20when%20i%20am%20adding%20the%20above%20code%20to%20create%20oracle%20connection%2C%20event%20not%20get%20executed%2C%2C%3C%2FP%3E%3CP%3Eplease%20let%20me%20know%20if%20any%20other%20way%2C%3C%2FP%3E%3CP%3Esolution%20for%20the%20above%20code%20is%20really%20appreciate.%3C%2FP%3E%3CP%3EThanks%2C%3C%2FP%3E%3CP%3ENikhil%20C.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-872083%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3E2016%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPermissions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESites%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-873938%22%20slang%3D%22en-US%22%3ERe%3A%20Oracle%20Connection%20With%20SharePoint%20List.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-873938%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F281465%22%20target%3D%22_blank%22%3E%40Nikhil1992%3C%2FA%3E%26nbsp%3Bdo%20you%20want%20to%20make%20oracle%20connection%20in%20Event%20receiver%20code%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-873992%22%20slang%3D%22en-US%22%3ERe%3A%20Oracle%20Connection%20With%20SharePoint%20List.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-873992%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F410289%22%20target%3D%22_blank%22%3E%40SinhaKislay%3C%2FA%3EYes%2C%20I%20am%20creating%20Oracle%20connection%20in%20Sharepoint%20in%20Event%20receiver%20code%2Cfor%20to%20sync%20SharePoint%20List%20with%20Oracle%20Database.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-873994%22%20slang%3D%22en-US%22%3ERe%3A%20Oracle%20Connection%20With%20SharePoint%20List.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-873994%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F281465%22%20target%3D%22_blank%22%3E%40Nikhil1992%3C%2FA%3E%26nbsp%3BI%20hope%20you%20are%20using%26nbsp%3B%3CSPAN%3Eusing%20Oracle.DataAccess.Client%3B%26nbsp%3B%20in%20the%20beginning%20and%20also%20you%20have%20added%20a%20reference%20to%20Oracle.DataAccess%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fdeveloper.oracle.com%2Fdotnet%2Fvs2010-oracle-dev.html%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdeveloper.oracle.com%2Fdotnet%2Fvs2010-oracle-dev.html%3C%2FA%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-874169%22%20slang%3D%22en-US%22%3ERe%3A%20Oracle%20Connection%20With%20SharePoint%20List.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-874169%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F410289%22%20target%3D%22_blank%22%3E%40SinhaKislay%3C%2FA%3EYes%2CReference%20added%20for%20the%20DLL%20and%20NameSpace.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-874173%22%20slang%3D%22en-US%22%3ERe%3A%20Oracle%20Connection%20With%20SharePoint%20List.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-874173%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F281465%22%20target%3D%22_blank%22%3E%40Nikhil1992%3C%2FA%3E%26nbsp%3Bok%2C%20then%20I%20am%20thinking%20on%20these%20lines%2C%20since%20server%20code%20is%20executed%20on%20SharePoint%20servers%20please%20check%20if%20you%20are%20able%20to%20reach%20Oracle%20servers%20from%20SP%20servers%20%2C%20there%20can%20be%20firewall%20etc%3C%2FP%3E%3CP%3EAlso%20if%20there%20is%20some%20kind%20of%20log%20please%20share%20it%20as%20well.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-874226%22%20slang%3D%22en-US%22%3ERe%3A%20Oracle%20Connection%20With%20SharePoint%20List.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-874226%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F410289%22%20target%3D%22_blank%22%3E%40SinhaKislay%3C%2FA%3EYes%20I%20will%20try.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hi,

I want to create Oracle connection with the sharepoint List,

i am using the event receiver on an list item to make CRUD Operations,


using (OracleConnection conn = new OracleConnection(connstring))
{
using (OracleCommand cmd = new OracleCommand(command, conn))
{

but when i am adding the above code to create oracle connection, event not get executed,,

please let me know if any other way,

solution for the above code is really appreciate.

Thanks,

Nikhil C.

6 Replies
Highlighted

@Nikhil1992 do you want to make oracle connection in Event receiver code?

Highlighted

@SinhaKislayYes, I am creating Oracle connection in Sharepoint in Event receiver code,for to sync SharePoint List with Oracle Database.

Highlighted

@Nikhil1992 I hope you are using using Oracle.DataAccess.Client;  in the beginning and also you have added a reference to Oracle.DataAccess

https://developer.oracle.com/dotnet/vs2010-oracle-dev.html

 

Highlighted

@SinhaKislayYes,Reference added for the DLL and NameSpace.

Highlighted

@Nikhil1992 ok, then I am thinking on these lines, since server code is executed on SharePoint servers please check if you are able to reach Oracle servers from SP servers , there can be firewall etc

Also if there is some kind of log please share it as well.

Highlighted

@SinhaKislayYes I will try.