Sep 24 2019 06:23 AM
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.
Sep 25 2019 01:19 AM
@Nikhil1992 do you want to make oracle connection in Event receiver code?
Sep 25 2019 02:06 AM
@SinhaKislayYes, I am creating Oracle connection in Sharepoint in Event receiver code,for to sync SharePoint List with Oracle Database.
Sep 25 2019 02:11 AM
@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
Sep 25 2019 03:52 AM
@SinhaKislayYes,Reference added for the DLL and NameSpace.
Sep 25 2019 03:55 AM
@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.
Dec 25 2020 09:13 AM
@Nikhil1992 can you tell me if you achieve a solution to this situation?