SQL server Exception

Discussion in '.NET' started by mishfaqk2002@yahoo.com, Feb 28, 2011.

  1. mishfaqk2002@yahoo.com

    mishfaqk2002@yahoo.com

    Joined:
    Feb 28, 2011
    Messages:
    1
    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.
     
    mishfaqk2002@yahoo.com, Feb 28, 2011
    #1
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. =?Utf-8?B?UmV6YQ==?=
    Replies:
    3
    Views:
    17,952
    Carlos Barini
    Jun 7, 2004
  2. Daves
    Replies:
    1
    Views:
    381
    tom.pesterDeLeTeTHISSS@pandora.be
    Jun 13, 2005
  3. Geoff
    Replies:
    3
    Views:
    451
    Patrick.O.Ige
    Jan 16, 2006
  4. farseer

    SQL Server 2005 + SQL Server Express

    farseer, Aug 7, 2006, in forum: ASP .Net
    Replies:
    3
    Views:
    350
    farseer
    Aug 8, 2006
  5. Grey Alien

    SQL Server 2000 vs SQL Server Express

    Grey Alien, Jul 8, 2007, in forum: ASP .Net
    Replies:
    6
    Views:
    497
    Grey Alien
    Jul 9, 2007
Loading...

Share This Page