Re: connection suddenly fails: mdac? pooling?

From: Hernán Castelo (hhh_at_hotmail.com)
Date: 03/17/04 

Date: Wed, 17 Mar 2004 13:42:46 -0300

yes
in the actual web pages is "exception error" in "cmd.execute"
then get the same error in "cmd.activeconnection=cnx"

...but listen please (this is going me mad)
i cant describe exactlye the error now
because everything works OK now: believe me
but im not happy because
earlier this morning was ok too:
i execute the web site pages now and works well....

i dont know how much time
the sql go to be stable
.... perhaps, after a while, a will

"Bob Barrows" <reb01501@NOyahoo.SPAMcom> escribió en el mensaje news:O3oeDjDDEHA.1128@TK2MSFTNGP11.phx.gbl...
> Hernán Castelo wrote:
> > hi
> >
> > just for test, i wrote this asp code
> > if i include the line of "activeConnection"
> > i get the 800a01fb error : "exception"
>
> That's all it says? "exception"?
>
>
> > i reinstalled MDAC again and again
> > i close all objects
> > see the example ONLY open and close a connection
> >
> > connections seems be POOLED ok
> > but executing the asp code several times
> > i get the error again... then that connection pool stay open for ever
> > (in sql console)
> >
> > <%
> > dim cnx, cmd
> > Set cnx = server.createObject( "ADODB.Connection")
> > cnx.ConnectionString = "provider=sqloledb;Data Source=...;Initial
> > Catalog=...;User ID=...;Password=..."
> > cnx.Open
> > set cmd= server.createObject( "ADODB.command")
> >
> > ' cmd.activeConnection= cnx
>
> This should be:
> set cmd.activeConnection= cnx
>
> Without the "set" keyword, another connection is opened using the cnx
> object's connectionstring property.
>
>
> --
> Microsoft MVP - ASP/ASP.NET
> Please reply to the newsgroup. This email account is my spam trap so I
> don't check it very often. If you must reply off-line, then remove the
> "NO SPAM"
>
>

Relevant Pages

  • Re: Web Applicaiton using Trusted Connections to SQL on different machine?
    ... > if I use ASP.NET code to make the connection, or if i just use ASP ... > My ASP code looks like this: ... > I get the Error on the .Execute ... Please reply to the newsgroup. ...
    (microsoft.public.sqlserver.security)
  • Re: Web Applicaiton using Trusted Connections to SQL on different machine?
    ... > if I use ASP.NET code to make the connection, or if i just use ASP ... > My ASP code looks like this: ... > I get the Error on the .Execute ... Please reply to the newsgroup. ...
    (microsoft.public.inetserver.iis.security)
  • [Full-Disclosure] Advanced usage of system() function.
    ... and call its arguments as a command for shell. ... as we can see we still didnt get what we want (typing exit ... Connection closed by foreign host. ... think what we want to execute. ...
    (Full-Disclosure)
  • Advanced usage of system() function.
    ... and call its arguments as a command for shell. ... as we can see we still didnt get what we want (typing exit we are ... Connection closed by foreign host. ... think what we want to execute. ...
    (Bugtraq)
  • Re: ADODB Command memory leak
    ... _ConnectionPtr conn = NULL; ... // Execute statement. ... > My logic is such that the connection to the database is not maintained ... Create/Append command parameters ...
    (microsoft.public.data.ado)