Re: REPOST - Please help.

Hi Alvin and thanks for your answer,

Haven't tried that ;) since it returned data using it from access....

Anyway I will try that too (sometimes simplest things do the job right?)

But please stay tuned to the thread cause I'm not so optimistic LOL!

-------------------
Nick Poulis
npoulis@xxxxxx
-------------------

"Alvin Bruney [MVP - ASP.NET]" wrote:

> the error indicates that your dsn isn't configured correctly. i would start
> there from scratch by removing and setting up the dsn again to see if that
> helps
>
> --
> Regards,
> Alvin Bruney - ASP.NET MVP
>
> [Shameless Author Plug]
> The Microsoft Office Web Components Black Book with .NET
> Now available @ www.lulu.com/owc, Amazon.com etc
> "Nick Poulis" <NickPoulis@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:511C1881-1392-4DAD-937B-EFD00D5BABBE@xxxxxxxxxxxxxxxx
> > 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 from the source it points (Liant Relativity). Again
> > I
> > checked if the IIS 6.0 application working process is running as a user
> > that
> > has
> > has access to 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.
> >
> > What is the difference between IIS 5 and IIS 6 on this matter?
> >
> > Please any ideas on that error will save my day ;-).
> >
> >
> > Nick
> > npoulis@xxxxxx
> >
> >
>
>
>
.

Relevant Pages

  • Re: IIS permissions while accessing a database from a CGI applicat
    ... you'll likely need to examine more closely the "Dsn" ... Dsn when called by the credential used by IIS to run your CGI. ... defined on your IIS server's ODBC Data Source Administrator. ... I have a VC++ CGI application that shall work with a database (for now a MS ...
    (microsoft.public.inetserver.iis.security)
  • 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: 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)