Call Oracle Stored Procedure using Sql server Database Link

 BEGIN
DECLARE @P_DATE DATETIME=GETDATE()
DECLARE @P_EMPNO VARCHAR(10)
SET @P_EMPNO='2268224413'
DECLARE @P_TRAN_TYPE INTEGER =1
DECLARE @P_LOCNO VARCHAR(10)
SET @P_LOCNO='IT2020'
DECLARE @P_EXCEPTION DECIMAL



EXECUTE ( 'begin PUNCH.INSERT_ATTEND00_FINGER(?,?,?,?,?); end;', @P_DATE, @P_EMPNO, @P_TRAN_TYPE,@P_LOCNO, @P_EXCEPTION OUTPUT) AT FP_ORA;

SELECT @P_EXCEPTION

END

System.UnauthorizedAccessException: Access is denied. - DTSConnection

Crystal Report Error when publish web site
Error Details:

System.Web.HttpUnhandledException (0x80004005): Exception of type 

'System.Web.HttpUnhandledException' was thrown. ---> 

CrystalDecisions.Shared.CrystalReportsException: Load report failed. ---> 

System.UnauthorizedAccessException: Access is denied. - DTSConnection

   at CrystalDecisions.ReportAppServer.ClientDoc.ReportClientDocumentClass.Open

(Object& DocumentPath, Int32 Options)

   at CrystalDecisions.ReportAppServer.ReportClientDocumentWrapper.

Open(Object& DocumentPath, Int32 Options)

   at CrystalDecisions.ReportAppServer.ReportClientDocumentWrapper.

EnsureDocumentIsOpened()

   --- End of inner exception stack trace ---

   at CrystalDecisions.ReportAppServer.ReportClientDocumentWrapper.

EnsureDocumentIsOpened()

   at CrystalDecisions.CrystalReports.Engine.ReportDocument.Load(String filename,

 OpenReportMethod openMethod, Int16 parentJob)

   at CrystalDecisions.CrystalReports.Engine.ReportDocument.Load(String filename)

   at Eservices.EmpAttendence.Draw_CVrystal(dsAttendence _ds) in 

D:\TFS\Eservice_TeamProjects\Eservices\Eservices\Employee\EmpAttendence.aspx.vb:line 324

   at Eservices.EmpAttendence.btnPrintResult_Click(Object sender, EventArgs e) in 

D:\TFS\Eservice_TeamProjects\Eservices\Eservices\Employee\EmpAttendence.aspx.vb:line 317

   at System.Web.UI.WebControls.Button.OnClick(EventArgs e)

   at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument)

   at System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler

.RaisePostBackEvent(String eventArgument)

   at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, 

String eventArgument)

   at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)

   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, 

Boolean includeStagesAfterAsyncPoint)

   at System.Web.UI.Page.HandleError(Exception e)

   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, 

Boolean includeStagesAfterAsyncPoint)

   at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, 

Boolean includeStagesAfterAsyncPoint)

   at System.Web.UI.Page.ProcessRequest()

   at System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context)

   at System.Web.UI.Page.ProcessRequest(HttpContext context)

   at ASP.employee_empattendence_aspx.ProcessRequest(HttpContext context)

   at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.

IExecutionStep.Execute()

   at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& 

completedSynchronously)

Solution

the solution for this problem was convert application pool to integrated 

instead of classic mode.

the temp folder which save generated pdf report file should have write 

access for iis_IUser or application pool User also

----------------------------------

THE PROBLEM with windows 2012 didn't solved untill set application pool

 identity to administrator user.