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

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

Date: Sun, 29 May 2005 02:55:28 -0700

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)
  • 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)
  • Re: REPOST - Please help.
    ... the error indicates that your dsn isn't configured correctly. ... > Data source name not found and no default driver specified ... > it's existence in System DSN and User DSN. ... > checked if the IIS 6.0 application working process is running as a user ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: REPOST - Please help.
    ... > the error indicates that your dsn isn't configured correctly. ... >> Data source name not found and no default driver specified ... >> it's existence in System DSN and User DSN. ... >> checked if the IIS 6.0 application working process is running as a user ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Beginner: How do I link via ODBC from a PC into an AS400?
    ... Options, Miscellaneous, How to keep Microsoft Office Documents Protected, ... The moment I select ODBC Databases from Files of Type, ... I have added a User DSN based on the Client Access Driver, ...
    (microsoft.public.access.externaldata)