470,626 Members | 2,116 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,626 developers. It's quick & easy.

calling another dll from web service


Hi! I'm newish to writing web services and am trying to deploy a web
service on a hosted server on the internet.

My web service uses a mysql oledb data provider to get data from a
database hosted on the remote server. When I call the method that
uses this provider, i get an error back from the webservice like this:

"Server was unable to process your request. --Access is denied:
"MySql.Data'."

I have copied the mysql dll to the same place as my web service. I
have also commented out the code that calls this dll and my function
works out. The code also work when run locally on my development
machine. So this leads me to believe there is some reference or
config I have missed.

Any clues?

Thanks,
Steve

Apr 12 '07 #1
1 2457
<sa***@cazenda.comwrote in message
news:11********************@e65g2000hsc.googlegrou ps.com...
>
Hi! I'm newish to writing web services and am trying to deploy a web
service on a hosted server on the internet.

My web service uses a mysql oledb data provider to get data from a
database hosted on the remote server. When I call the method that
uses this provider, i get an error back from the webservice like this:

"Server was unable to process your request. --Access is denied:
"MySql.Data'."

I have copied the mysql dll to the same place as my web service. I
have also commented out the code that calls this dll and my function
works out. The code also work when run locally on my development
machine. So this leads me to believe there is some reference or
config I have missed.

Any clues?
Web Services, like ASP.NET Web Applications, run in a restricted security
context. Among other things, your service is probably running under a user
account that does not have access to your MySql.Data file. You'll need to
find out from your hosting provider what account the service is running
under, and you'll have to ask them how to make sure that account has the
necessary permissions to the MySql.Data file and any other such resources it
may require.

It may be working in your development environment because the account you're
using there happens to have the access it needs, or because the MySql.Data
file in your development environment permits that account to access it.
John Saunders [MVP]
Apr 12 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Cleo | last post: by
3 posts views Thread by Mike | last post: by
3 posts views Thread by Jerome Cohen | last post: by
2 posts views Thread by Johan | last post: by
7 posts views Thread by =?Utf-8?B?UVNJRGV2ZWxvcGVy?= | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.