Re: OleDBpermission

Sept. 23, 2006

The problem is web sites have limited Code Access Security permissions (CAS)... you need to get your web service granted the OleDB permission through CAS.

You can do this in the web.config of the web service, by adjusting the <trust> element (do a quick search on MSDN).

The intranet does have the OleDB permission, which is the reason why calling it from the Internet zone doesn't work..... because the "zone" of your service gets different permissions.

Hope this helps!
--

Joseph Bittman
Microsoft Certified Solution Developer
Microsoft Most Valuable Professional -- DPM

Blog/Web Site: http://CactiDevelopers.ResDev.Net/
"Frank" <rfranchi@xxxxxxxxxx> wrote in message news:OlY2RU82GHA.696@xxxxxxxxxxxxxxxxxxxxxxx
Hello to all,
We have the following problem:

using: Framework 2, VB.NET, Visual Studio 2005, SQL Server 2005 or MSAccess, Win XP professional service pack 2.
We developed a WebService that is now installed in a machine. The database is located in the same machine where web service is installed.
When we call a method of the web service from a remote web page (internet) the exception given is the following:

Error loading [....table] dataRequest for the permission of type 'System.Data.OleDb.OleDbPermission, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.

web service and page have <authentication mode="None"/>

Calling the we service fron Intranet it works.

In the machine is installed Framework1.1 also.
We get the same error using SQL server and access with OleDB and Odbc. (with ODBC the error is ....permission of type 'System.Data.OleDb.ODBCPermission......)


Any idea? please!!!!



.

Relevant Pages

  • Re: Smart clients
    ... >> a connection) to the machine that the client was downloaded from. ... First, you can connect to a web service, but you cannot open any arbitrary ... If you evaluate the permission set granted to an executable ...
    (microsoft.public.dotnet.languages.csharp)
  • RE: UpdateListItems web service does not update field
    ... I think there is nothing wrong with the configurations. ... \par The permission is correct, and the soap message looks good. ... \par url: Web Service URL, ... \par As web service issues requires extensive programming skills, it is suggested to get further help in microsoft.public.sharepoint.portalserver.development newsgroup. ...
    (microsoft.public.sharepoint.portalserver)
  • RPC over HTTPS Question (2 rpcproxydlll files)
    ... Right at the bottom of the page is ... Only one of which was given permission to execute in the web service ...
    (microsoft.public.exchange.admin)
  • Problem accessing Windows 2003 DC Registry Keys
    ... Hi, I'm trying to read some Registry Keys I've created with a Web Service, ... Request for the permission of type ... String POSPassword, String IdInstalacion) ...
    (microsoft.public.dotnet.security)
  • xslt file with c# script.
    ... I meant it seems like the web service does NOT have the ... permission to execute the c# code. ... >I got the following error message ... >It seems like the web service does have the permission to ...
    (microsoft.public.dotnet.security)
Loading