MDAC 2.7

From: Roy Lawson (roy_at_xeon.tv)
Date: 05/21/04 

Date: 21 May 2004 09:15:51 -0700

I recently upgraded from MDAC 2.6 to 2.7. I have an old VB6 dll that
uses the data environment in some of the classes. This dll is
instantiated in an ASP web application, and is unable to instantiate.
The error is in opening the connection to the SQL server. Everything
worked fine before upgrading to MDAC 2.7.

I know my connection string is fine.

What I did to test the problem is to copy the same code into a VB6
windows app, recreated the data environment, and created a new form
with a button; the button event simply instantiated the component and
ran one of the proceedures. It worked like a charm.

I believe this to be a security issue. My guess is that the DLL is
running as my machine user and doesn't have permissions to open the
database. When it is running as code in the IDE, it is running as my
user acccount and works fine.

Am I on the right track here, and if so how to I fix this?

Best Regards,

Roy