Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: vbscript and oracle connection freezing.
That code was copy'ed and pasted so it came out wrong. The vbscript
that is failing is the section with the adoCon.open(); The connection
doesnt open because of something wrong with either odbc or my internet
setup.
Andy Hassall <andy_at_andyh.co.uk> wrote in message news:<grsacv8tnbune4s8mdehfm3uml9tdv2ts4_at_4ax.com>...
> On 16 May 2003 16:11:31 -0700, bigbinc_at_hotmail.com (bigbinc) wrote:
>
> > 'Create an ADO recordset object
> > Set rsDistance = Server.CreateObject("ADODB.Recordset")
> > strSQL = "SELECT * FROM DORSEY.REHABTAB ORDER BY OBJECTID"
> >
> > Do While not rsDistance.EOF
> >
> > Response.Write rsDistance(0).Value & "<br>"
> >
> > Loop
>
> You've created a recordset, set a variable to contain a bit of SQL, but not
> executed it, and you then go into an infinite loop waiting for an EOF that will
> never arrive. You at least need to:
>
> (a) Execute the SQL.
> (b) Have a rsDistance.MoveNext statement in the loop.
Received on Sat May 17 2003 - 09:19:49 CDT