| TheMaxx 2006-12-07, 5:17 am |
|
I need to access ODBC from remote computer, if there's a better way other
than WebService please let me know.
So, i am doing web service which connects on ODBC, which connects to
SqlServer 2000 (Windows auth.)
First error was:
Login failed for user 'MyComputerNmae\ASPN
ET'.
Then i unchecked "Anonymous acces" from IIS for this webservice
I added to web.config of webService:
<identity impersonate="true"
userName="DOMAIN\username"
password="pwd"/>
When i call method from browser directly to web service i get expected
results.
When trying from application that uses WebServices i get an error:
"The request failed with HTTP status 401: Access Denied."
What can cause this error?
p.s. call from webservice looks like this:
OdbcDataAdapter adapter = new OdbcDataAdapter(quer
y, odbcConnectionString
);
DataSet ds = new DataSet();
adapter.Fill(ds);
return ds;
|