Last post Jun 16, 2006 02:22 PM by bungalay
Jun 16, 2006 02:22 PM|bungalay|LINK
I was charged with the task of adding new aspx(2.0) forms to an existing piece of web software that uses classic asp and COM objects all over the place.
I want to use the old COM objects instead of writing new ones. I add a reference to them in Visual Studio 2005 and it puts the interop.comObject.dll into my bin folder.
I am able to acces the classes and get them working somewhat.
The problems comes up when these classes make a database call. I get the error message:
"System.Runtime.InteropServices.COMException Login failed for user 'myDomain\myComputerName'
For my aspx forms, if I access the same DB, it works just fine. I
was getting the same error when my aspx applications called the db -- until I put the following into the web.config in my application folder:
Why don't the COM objects use the same authentication?? Why are they trying to authenticate using my computer name?
(I also tried adding UID & PWD into a query string, with no luck, seems to be overriding it.)