Posted by Erland Sommarskog on 06/16/05 16:19

Axel (realraven2000@hotmail.com) writes:
> I had tried changing tro a client side cursor but it still produces the
> same result
>
> (from my global.asa)
> <SCRIPT LANGUAGE=VBScript RUNAT=Server>
> Sub Application_OnStart
>
> dim cnnDem
>
> Set cnnDem = Server.CreateObject("ADODB.Connection")
>
> cnnDem.CursorLocation=3 ' adUseClient=3 (Server=2)
> Call cnnDem.Open("DSN=TestDB;UID=sa;PWD=;DATABASE=TestDB")
>
> Application("cnn") = cnnDem
>
> End Sub
></SCRIPT>

Is adUseClient really 3? Does ASP not support the use of the constants
instead?

If you use client-side cursor, there is another solution which may be
more palatable: use the .RecordCount property on the recordset.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

[Back to original message]