Re: Data source not visible by ASP.NET working process on IIS 6.0

From: Joseph Bittman MCAD (RyanBittman_at_msn.com)
Date: 05/29/05 

Date: Sun, 29 May 2005 08:55:48 -0700

May 29, 2005

   At least you aren't in safe mode with a BSOD right now! LOL :-) Anyway,
when upgrading to IIS 6.0 the service account IIS runs under changes to
Network Service from ASPNET. Therefore, you will have to change the access
in the DB to reflect Network Service. This is if you have no other settings
in your application's web.config that might change the settings such as
<identity> ? Hope this helps and have a great weekend! 

-- 
                 Joseph Bittman
Microsoft Certified Application Developer
Web Site: http://67.40.28.162
"Nick Poulis" <Nick Poulis@discussions.microsoft.com> wrote in message 
news:F27A92A3-A295-4D78-8A3D-195FCFC3160D@microsoft.com...
> Hi to all
>
> I face the following problem,
>
> the following code (very simple) is contained in
> a referenced class method
>
>
> Dim cn As New OdbcConnection("DSN=BOC;UID=Admin;PWD=;")
> cn.Open()
>
> When aspx page reaches the method containing those lines
> I get the following server error:
> ERROR [IM002] [Microsoft][ODBC Driver Manager]
> Data source name not found and no default driver specified
>
>
> Of course I have checked most possible reasons like DSN name and
> it's existence in System DSN and User DSN.
>
> Also checked that this DSN works for example with Access 2000 and
> it does retrieve data using it from the source it points.
> The IIS 6.0 application working process is running as a user that has
> access and owns this DSN but I always get the same error.
>
> It's strange cause there is no problem with IIS 5 and this came up when
> the web app was transferred to an Win Server 2003 with IIS 6. Could
> it be some security tuning that I have overlooked?
>
> Please any ideas on that error will save my day ;-).
>
>
> Nick
> npoulis@hol.gr
>

Relevant Pages

  • REPOST - Please help.
    ... it's existence in System DSN and User DSN. ... It's strange cause there is no problem with IIS 5 and this came up when ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: IIS permissions while accessing a database from a CGI application
    ... When you're executing the CGI thru IIS, remember that the code is being executed under different credential than when you run code interactively. ... That connection string must both be a valid Dsn when executed on the IIS server, and be a valid Dsn when called by the credential used by IIS to run your CGI. ...
    (microsoft.public.inetserver.iis.security)
  • Re: Data source not visible by ASP.NET working process on IIS 6.0
    ... I'm sure that the asp working process in IIS 6 Application Pool is defined ... defined as system DSN). ... I also tried that with the default NETWORK SERVICE account that should have ... access to the same DSN defined in System DSN. ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Data source not found by ASP.NET working process on IIS 6.0
    ... it's existence in System DSN and User DSN. ... if the IIS 6.0 application working process is running as a user that has ...
    (microsoft.public.dotnet.framework.aspnet)
  • Weird permissions issue
    ... I have an ASP application (IIS 5.0 on Win XP Pro) that talks to an Access ... 2003 database via an ODBC DSN. ... I have recreated the DSN, checked for 'read only', ...
    (microsoft.public.inetserver.asp.db)