Login fails for COM+

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi,

I am working on an old asp application which uses a com+ application
to access a SQL server. I have two development machines. on one there
is no ODBC connection and the application is working fine. On the
second machine which has the same set of DLLs and application files, I
have to add a system DSN for the same application to work and it fails
when I tries connection to the database with a "Login Failed" message.
if I delete the System DSN the com object fails with with a data
source name not found message.

My question is that how many different ways does a DLL in a COM+
object can use to connect to a database? Is there a setting I am
missing to replicate on the second machine when I set the components?
Any ideas on how to go about trouble shooting this problem is greatly
appreciated.

Thanks

.

Relevant Pages

  • Re: FrontPage Server Error
    ... At this point I can't provide you with any additional help, because I always use a System DSN to ... FrontPage Resources, WebCircle, MS KB Quick Links, etc. ... > application root setting off the subweb which FP ... >>> Access database in the parent web from a sub web (the ...
    (microsoft.public.frontpage.client)
  • Re: Transfer Excel file from a Web Server to Local Server
    ... You don't create a File Data Source, you have to connect to the System DSN that your webmaster ... Microsoft Jet or ISAM database table to your database" ... I was trying to create a new database connection through Form Properties. ...
    (microsoft.public.frontpage.programming)
  • Re: Opening an Access database in Delphi
    ... DLLs or other files that need to be installed with my Delphi 6 app in order to open and work with a Microsoft Access 2000 database, or are all the necessary files included with Windows? ... The Jet redistributable can be found on ... installs this stuff. ...
    (comp.lang.pascal.delphi.misc)
  • Re: Issue with SQL Server 2005 Mobile and SD Cards?
    ... Reduce the number of DLLs you have in your application. ... doesn't initialize the card fast enough. ... the database should be pretty safe. ... We also are having major problems with SQL Server 2005 Mobile. ...
    (microsoft.public.sqlserver.ce)
  • Re: A good asp.net architecture for a large project (sort of newbie)
    ... What would be the best programming architecture for a large project ... > as main database? ... go with a web service. ... dlls should be just fine. ...
    (microsoft.public.dotnet.framework.aspnet)