Dear friends,
I'm a Web Services newbie and I have created a simple Web Service that given
3 parameters accesses a database and returns 1 value.
When run from Visual Studio 2005, the Webservice returns the correct
information from the database with no problems.
I have created a new Virtual Directory in my local IIS that points to the
VS2005 folder where the Web Service is.
When I run the Web Service from the browser like
http://localhost/wsfolder/webservice.asmx and then insert the 3 parameters,
after clicking INVOKE I always get the "Can't connect to database" that I
have created with a try/catch block for myConnection.Open();
I have my username and password for the SQL server in the code's connection
string.
Then I have created a simple c# Form application that consumes the Web
Service and get the same error of course.
What am I forgeting?
Thanks in advance,
Nelson