ODBC not working in aspx page

[Guest]

I'm trying to write a page in vb.net/asp.net using an ODBC connection. Using
server explorer I can get to my connection. When I attempt to connect
through my code in a web browser I get the following error:

ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found
and no default driver specified

The catch is to test, I created a windows application, using the same
connection string & info, and it works just fine. Appearantly it has
something to do with it being a web app. Any help with this would be greatly
appreciated.

 

[Sahil Malik [MVP]]

What is the connection string you are using?

 

[Cor Ligthert [MVP]]

Matt,

Be forever aware that a webpage uses the inbuild ASPNET user.

I hope this helps,

Cor

 

[Paul Clement]

¤ I'm trying to write a page in vb.net/asp.net using an ODBC connection. Using
¤ server explorer I can get to my connection. When I attempt to connect
¤ through my code in a web browser I get the following error:
¤
¤ ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found
¤ and no default driver specified
¤
¤ The catch is to test, I created a windows application, using the same
¤ connection string & info, and it works just fine. Appearantly it has
¤ something to do with it being a web app. Any help with this would be greatly
¤ appreciated.

Yes it would really help to know what type of database you are working with, and as Sahil mentioned,
what your connection string looks like.


Paul
~~~~
Microsoft MVP (Visual Basic)

 

[Guest]

I'm sorry I did not post sooner, but I did get the problem fixed. I needed
to not use a DSN, just a connection string. I'm connecting to an Oracle
Database.

Thanks guys.