The call to the member open failed Provider returned the fol

subhadynamics

Dear All,

As part of customization of HR Module , the details of an employee's are pulling out using the Webservice and Stored in the Temporary table. In Employee card the details are pulled out from Temporary table using the Stored Procedure .But when i load the employee card the error (The call to the member open failed Provider returned the following message.Unspecified Error.)is throwing out .

The code for calling the SP is given as below:-

CREATE(myConnection);
CREATE(myRecordSet);
sSQL:= 'SpUpdateEmployee';
myConnection.ConnectionString :=
'Driver={SQL Server};Server=DynamicsServer;Database=Dynamics;Uid=sa;Pwd=sa;';
myConnection.Open();
myRecordSet := myConnection.Execute(sSQL);
myConnection.Close;
EmployeeDetails.RUN;

Thanks & Regards,

Subha