Re: Remove DB connections

From: CJM (cjmwork_at_yahoo.co.uk)
Date: 02/09/04 

Date: Mon, 9 Feb 2004 11:30:28 -0000

I think it would be easier for us to help if you posted some relevant code
snippets...

What drivers are you using? Proprietary, OLEDB or ODBC?

Are you use the same connection string each time?

Are you creating/closing your DB objects appropriately?

Chris

"DS" <danielso@sinaman.com> wrote in message
news:%236NHMRv7DHA.1504@TK2MSFTNGP12.phx.gbl...
> When I jump from Page 1 to Page 2, one more DB connections is built. When
I
> browsed 10 pages, then 10 connections are found in my DB. How can I remove
> previous connections when I open a new page?
>
> My environment:
> ASP + Sybase ASE 12.5
>
> Thanks,
> DS
>
>

Relevant Pages

  • Re: Diff type of data fetching
    ... ODBC and OLE DB are two different sets of commands and functions as drivers ... for connections to client/server SQL databases. ... ODBC is an industry standard supported by Microsoft; ... MS thought their OLEDB classes would make ODBC obsolete but they have had ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Diff type of data fetching
    ... drivers for connections to client/server SQL databases. ... ODBC is an industry standard supported by Microsoft; ... MS thought their OLEDB classes would make ODBC obsolete but they have had ... OLEDB permits calling ODBC drivers but this is now a deprecated usage as ...
    (microsoft.public.fox.programmer.exchange)
  • ODBC /OLEDB Connection
    ... The codes works fine with OLEDB to connect and run queries but with ODBC it ... What is wrong with the ODBC connection string? ... It creates a system error in the next ...
    (microsoft.public.dotnet.framework.adonet)
  • ODBC & OLEDB
    ... The codes works fine with OLEDB to connect and run queries but with ODBC it ... What is wrong with the ODBC connection string? ... Security Info=False ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Could this KB article explain my IIS hanging?
    ... ideally use oledb instead of the ODBC drivers for my connection strings. ... I thought I could just change my connection string and everything else would ... There is no support charge for hotfixes. ...
    (microsoft.public.inetserver.iis)