Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
CursorLocation = adUseClient
202 views
Skip to first unread message
Ron
Sep 30, 2001, 9:20:50 PM9/30/01
to
A little help please. Everytime I put .CursorLocation =
adUseClient in my code it fails. I get this error on my
page "ADODB.Recordset error '800a0bb9'
Arguments are of the wrong type, are out of acceptable
range, or are in conflict with one another.
". Please provide some insight on how to fix this problem
adUseClient in my code it fails. I get this error on my
page "ADODB.Recordset error '800a0bb9'
Arguments are of the wrong type, are out of acceptable
range, or are in conflict with one another.
". Please provide some insight on how to fix this problem
A little snippet below:
Set rsContactList = Server.CreateObject("ADODB.Recordset")
With rsContactList
.PageSize = 2
.CacheSize = 2
.ActiveConnection = objDBConn
.CursorLocation = adUseClient
end with
Trevor Benedict R
Oct 1, 2001, 3:50:15 AM10/1/01
to
Hi Ron,
In this case the variable adUseClient was automatically created (as a variant) and used. When this value is passed to
the open method it was passed as a empty string. Hence this error. All these constants are declared inside the ADO
library, you may need to redeclare this again in your asp page. Another alternate to this would be to include the
adovb.inc file. But please refrain from doing this because it could slow down the processing of your page.
In this case the variable adUseClient was automatically created (as a variant) and used. When this value is passed to
the open method it was passed as a empty string. Hence this error. All these constants are declared inside the ADO
library, you may need to redeclare this again in your asp page. Another alternate to this would be to include the
adovb.inc file. But please refrain from doing this because it could slow down the processing of your page.
adUseServer = 2
aduseclient = 3
Set rsContactList = Server.CreateObject("ADODB.Recordset")
With rsContactList
.PageSize = 2
.CacheSize = 2
.ActiveConnection = objDBConn
.CursorLocation = adUseClient
..............
Trevor Benedict R
Software Engineer
Mastech Malaysia Sdn Bhd
"Ron" <ronk...@home.com> wrote in message news:010e01c14a17$4e7ca7a0$96e62ecf@tkmsftngxs03...
0 new messages