REPOST - Please help.

[Guest]

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
(e-mail address removed)

 

[Alvin Bruney [MVP - ASP.NET]]

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

 

[Guest]

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
(e-mail address removed)
-------------------

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

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
(e-mail address removed)