Hello,

I made custom webservice to do specific task. I need to access database to pull some data from product. I planned to use existing WSI for the task, rather then making my own logic to connect to database. But I have strange problem:

This is conecting method of my service:

Code:
ipx con = new ipx();
...
[WebMethod]
    public string Compare(string name) {

        StringBuilder RunQuery = new StringBuilder();
        RunQuery.Append("<AspDotNetStorefrontImport>");
        RunQuery.Append("<Query Name=" + "\"" + "string" + "\"" + " RowName=" + "\"" + "string" + "\"" + ">");
        RunQuery.Append("<SQL>");
        RunQuery.Append("<![CDATA[");

        RunQuery.Append("SELECT Summary FROM Product WHERE ProductID=" + "'" + "7290" + "'");

        RunQuery.Append("]]>");
        RunQuery.Append("</SQL>");
        RunQuery.Append("</Query>");
        RunQuery.Append("</AspDotNetStorefrontImport>");

        
        con.DoItUsernamePwd("hardcodeuser", "hardcorepass", RunQuery.ToString());

        return RunQuery.ToString();
    }

RunQuery string is 100% correctm and I have product with id 7290. All I am getting back is connection error.
Code:
{"Message":"Authentication Failed","StackTrace":"   at ipx.DoItUsernamePwd(String AuthenticationEMail, String AuthenticationPassword, String XmlInputRequestString) in c:\\inetpub\\wwwroot\\aspd\\App_Code\\ipx.cs:line 54\r\n   at wex.HelloWorld(String name) in c:\\inetpub\\wwwroot\\aspd\\App_Code\\wex.cs:line 42","ExceptionType":"System.ArgumentException"}
I am also using desktop application based on existing WSI, and when I get the same error, it means almost definitely I have wrong user or password entered. I am certain I have the right credentials entered.

Anotger things I notice I am missing Url property of WSI object.
To be more precise:
I instantiate this within my service:
ipx con = new ipx();

con.Url is missing... is that whats missing and preventing me to connect?



Thanks