Re: VB COM+ hangs

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

More questions: What "Application protection" is set to in your web site
properties, Home Directory tab?


"Adeel Ahmad" <adeelahmad2@xxxxxxxxx> wrote in message
news:1126883299.734394.50340@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> Hi,
> I have an application running in production on Windows 2003 Server and
> SQL Server 2000 (clustered). The app server is hosting my COM+ dll
> which is being called by ASP 3 pages. Its an Intranet application.
> What happens is: suddenly users get themselves out of the system and
> unable to get back because it throws the error:
> "Connection cannot be used to perform this operation. It is either
> closed or Invalid in this context".
>
> Now this error occurs when you try to use the database connection which
> is closed. And if the connection is closed, even then it should not be
> closed for all the users and even for new requests it should issue open
> a connection if its closed.
>
> Its not frequent error and happens twice this month in 15 days. The
> only solution to this problem is going to COM+ Applications and
> shutdown then Restart the dll. As its a production server so its not
> easy to repeat the process.
>
> I have reviewed the event logs and nothing suspisous has been found
> except everytime first Secli Surity Policy applied event is found and
> after that application stops bahaving in this fashion.
>
> My dll is set as "Unattended Execution" and "Retained in Memory".
> Any help would be highly appreciated.
> Thanks,
> adeel
>


.

Relevant Pages

  • Re: REWARD: Fix our SQL Server connection for $150 (CAPA)
    ... Are you able to set up an ODBC DSN using the OLEDB driver to the production ... The DSN setup applet does have a test connection utilitly, ... production server? ... > Development environment: ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Connection timeout - Sleeping Processes - Connection Pools? Wh
    ... Then, for our go-live, we replaced it with the production version. ... The dot net server seems to cache old code. ... SQL connections and close/dispose the connection in the Finally step. ... timeouts on getting a connection from the connection pool... ...
    (microsoft.public.dotnet.framework.adonet)
  • Business Intelligencia and the Authentication mountain
    ... analysis services on the production server? ... Just in case the server is ... What do I use as the connection in my ETL process at the point ... I am currently using the "Analysis Services ...
    (microsoft.public.sqlserver.datawarehouse)
  • Re: Connection Failure
    ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... > I built a package on my development server. ... I copied the backup to my production server & transfered ... > I opened the package an selected each Connection. ...
    (microsoft.public.sqlserver.dts)
  • Re: Outgoing POP3 email missing/lost/not received
    ... Funny thing is that I have had this ISP for 8 years and it has always been ... It looks like when you last ran CEICW, you set the ISP's mail server to: ... Internet Connection Wizard. ... After the wizard completes, the following network connection ...
    (microsoft.public.windows.server.sbs)