Webservice - ODBC - sqlServer
- From: "TheMaxx" <themaxxREMOVE@xxxxxx>
- Date: Thu, 7 Dec 2006 09:52:08 +0100
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;
.
- Prev by Date: Permission problem with OPENROWSET
- Next by Date: Having trouble of Creating OLE DB Connection on Windows 2003 64bit with SQL 64bit using BI Studio 2003
- Previous by thread: Permission problem with OPENROWSET
- Next by thread: Having trouble of Creating OLE DB Connection on Windows 2003 64bit with SQL 64bit using BI Studio 2003
- Index(es):
Relevant Pages
|
Loading
