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



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 as 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 from the source ot point (RM Relativity). Again I
checked
if the IIS 6.0 application working process is running as a user that has
also access to
those DSN's but I always get the same result.

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

Please any ideas on that error will save my day ;-).


Nick
npoulis@xxxxxx


.



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 visible by ASP.NET working process on IIS 6.0
    ... it's existence in System DSN and User DSN. ... The IIS 6.0 application working process is running as a user that has ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • 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: 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)