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%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%3CLINGO-SUB%20id%3D%22lingo-sub-2015241%22%20slang%3D%22en-US%22%3ERe%3A%20Oracle%20Connection%20With%20SharePoint%20List.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2015241%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%3B%20can%20you%20tell%20me%20if%20you%20achieve%20a%20solution%20to%20this%20situation%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
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.

7 Replies

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

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

@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

 

@SinhaKislayYes,Reference added for the DLL and NameSpace.

@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.

@SinhaKislayYes I will try.

@Nikhil1992  can you tell me if you achieve a solution to this situation?