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

From: Nick Poulis (NickPoulis_at_discussions.microsoft.com)
Date: 05/29/05

  • Next message: Joe Kaplan \(MVP - ADSI\): "Re: find out if the user has enough rights to open a page" 
    Date: Sun, 29 May 2005 10:35:22 -0700

    Hi Joseph and thanks for your answer,

    I'm sure that the asp working process in IIS 6 Application Pool is defined
    to run impersonating the user that the DSN belongs to (even though it is also
    defined as system DSN). Anyway I'm also sure that the user has access to the
    database and have tested it to be true.

    I also tried that with the default NETWORK SERVICE account that should have
    access to the same DSN defined in System DSN. Still getting the same error.

    So people you are (please!! LOL) welcome to come with any more ideas and
    PLEASE anyone with any experience with Liant's Relativity for RM COBOL will be
    also very helpfull cause this devil's DSN is pointing to that kind of files.
    (Why in god's name people still use COBOL!!!!)

    Thanks in advance.
    -----------------------------------
    Nick Poulis
    npoulis@hol.gr
    -----------------------------------

    "Joseph Bittman MCAD" wrote:

    > 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
    > >
    >
    >
    >

  • Next message: Joe Kaplan \(MVP - ADSI\): "Re: find out if the user has enough rights to open a page"

    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
      ... when upgrading to IIS 6.0 the service account IIS runs under changes to ... Network Service from ASPNET. ... "Nick Poulis" wrote in message ... > it's existence in System DSN and User 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)