MBR IT/.NET 247 : IIS 6.0 ASP.NET Process Identity and ODBC on microsoft.public.dotnet.framework.aspnet.webservices

IIS 6.0 ASP.NET Process Identity and ODBC

Messages

Related Types

This message was discovered on microsoft.public.dotnet.framework.aspnet.webservices.

Aras Kucinskas

Hi,

My WS ASP.NET application runs on IIS 6.0 and should connect to FoxPro DB on
file server over OLE DB ODBC connection. Special user is created on file
server for this application. I cannot find the right solution how to change
Process Identity.

App impersonates some user identity

<identity impersonate="true" userName="MyUser" password="MyPass" />

In this case application can read files with System.IO components on
specified file server directory, but System.Data.Odbc namespace components
not, because the try to connect with default IIS user identity - NETWORK
SERVICE. Maybe the problem is in MTS? Vfpodbc.dll starts in different
process with other identity?

How to find a solution?

Thanks

Aras

Reply to this message...

Paul Clement

On Fri, 3 Sep 2004 16:37:16 +0300, "Aras Kucinskas" <Click here to reveal e-mail address> wrote:

¤ Hi,
¤
¤ My WS ASP.NET application runs on IIS 6.0 and should connect to FoxPro DB on
¤ file server over OLE DB ODBC connection. Special user is created on file
¤ server for this application. I cannot find the right solution how to change
¤ Process Identity.
¤
¤ App impersonates some user identity
¤
¤ <identity impersonate="true" userName="MyUser" password="MyPass" />
¤
¤ In this case application can read files with System.IO components on
¤ specified file server directory, but System.Data.Odbc namespace components
¤ not, because the try to connect with default IIS user identity - NETWORK
¤ SERVICE. Maybe the problem is in MTS? Vfpodbc.dll starts in different
¤ process with other identity?
¤
¤ How to find a solution?

If you need to enable impersonation for a specific user then your web application should be
implementing Basic or integrated NT authentication. Your web site isn't set up for Anonymous access
is it?

Paul ~~~ Click here to reveal e-mail address
Microsoft MVP (Visual Basic)

Reply to this message...

Aras Kucinskas

Thanks. I change application pool's worker process identity in Application
Pools Properties - Identity Tab.

"Paul Clement" <Click here to reveal e-mail address> wrote in message
news:Click here to reveal e-mail address...
[Original message clipped]

Reply to this message...

MBR BootFX
Best-of-breed application framework for .NET projects, developed by Matthew Baxter-Reynolds and MBR IT

	Copyright © Matthew Baxter-Reynolds 2001-2008. '.NET 247 Software Development Services' is a trading style of MBR IT Solutions Ltd.
	Contact Us - Terms of Use - Privacy Policy - www.dotnet247.com