Webservice - ODBC - sqlServer (2)

T

TheMaxx

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\ASPNET'.

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(query, odbcConnectionString);
DataSet ds = new DataSet();
adapter.Fill(ds);
return ds;
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
474,044
Messages
2,570,388
Members
47,052
Latest member
ketan

Latest Threads

Top