ODBC .Net Data Provider not working on production web server

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Matt T - 29 Sep 2005 14:58 GMT

OK, I have a solution that works fine on my laptop and my desktop. When I
tried to move the solution to the production server, I keep getting the error
message

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

Although, we did download and install the driver from
http://www.microsoft.com/downloads/details.aspx?FamilyID=6ccd8427-1017-4f33-a062
-d165078e32b1&displaylang=en

The kicker is that it works fine from my laptop, which during testing, acts
as the web server.

The solutions is backend VB.Net, although I don't see that the code has much
to do with it.

Any suggestions?

Reply to this Message

Miha Markic [MVP C#] - 29 Sep 2005 22:43 GMT

I would say that it is a security issue. (asp.net is running under very
restricted account by default).
What OS is your product server running?

Signature

Miha Markic [MVP C#]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/

> OK, I have a solution that works fine on my laptop and my desktop. When I
> tried to move the solution to the production server, I keep getting the
[quoted text clipped - 16 lines]
>
> Any suggestions?

Reply to this Message

Matt T - 30 Sep 2005 13:39 GMT

Good morning, and thank your for responding.

The server is running Windows 2000 Server and IIS 5.0.

I will check out the asp.net account settings.

> I would say that it is a security issue. (asp.net is running under very
> restricted account by default).
[quoted text clipped - 20 lines]
> >
> > Any suggestions?

Reply to this Message

ODBC .Net Data Provider not working on production web server

Free Magazines