SQL server Exception

[[email protected]]

I have used Linked server to get data from other server using SQL Function OPENROWSET(). It works fine when i executer Storedprocedure in SQL Server Manager. But give following error
"Ad hoc access to OLE DB provider 'MSDASQL' has been denied. You must access this provider through a linked server. "


When i call stored procedure though my application.