web services

I just finished creating my first web service. It works fine on my development machine. But I ran into problems when I deployed it to my web site. I have three functions in this web service. There is one function which does not use database (access database) seems to run fine but the other two which need to access the database fail. The error message simply says that there is a problem in the page. I have checked and double checked path to my db, etc. I specify the path to the database using server.mappath function. I even wrote a traditional asp script to access the database and that worked fine. What could I be overlooking?

Appreciate you help.

Thanks,
Sanjeev

 

I know nothing about security, but I would guess that you might need to provide the properUserID and password to the database. In your local machine you might get away with it, since you can use Windows Authentication.
Please, check(and modify?) the web.config file in your directory on the server.