|
 |
asp_ado_rds thread: where is the ADO Cursor Engine ??? And which maintain it??
Message #1 by "tinweimin" <steven_tin@e...> on Sun, 13 May 2001 16:32:08
|
|
if i have two pc~
1.
WEB Server(I design the ASP program here.)
2.
Sql Server
1.
set conn = server.CreateObject ("ADODB.Connection")
conn.cursorlocation = aduseclient
conn.Open "DSN=ADO;uid=sa;pwd=;"
set rs = server.createobject("adodb.recordset")
rs.open sql,conn,3,3
where is the ADO Cursor Engine ??
it's on WEB server or Sql server...
(and which maintain it.. O.S or Sql Server?? )
2.
set conn = server.CreateObject ("ADODB.Connection")
conn.cursorlocation = adUseServer
conn.Open "DSN=ADO;uid=sa;pwd=;"
set rs = server.createobject("adodb.recordset")
rs.open sql,conn,3,3
where is the ADO Cursor Engine ??
it's on WEB server or Sql server...
(and which maintain it.. O.S or Sql Server?? )
if u know the answer,please tell me ~ thank you very much~
Steven.
Message #2 by "Branimir Giurov" <branimir@n...> on Mon, 14 May 2001 14:18:18
|
|
on the first example, you'll have client-side cursor - i.e. on the IIS
server.
on the second example, you'll have server-side cursor - on the SQL
server machine.
Don't forget that, when you're using client-side cursors, all recordet is
being transfered over the network, so if those machines are on a long
distance, it might be not a good idea, to use client-side cursor.
> WEB Server(I design the ASP program here.)
> 2.
> Sql Server
>
>
> 1.
> set conn = server.CreateObject ("ADODB.Connection")
> conn.cursorlocation = aduseclient
> conn.Open "DSN=ADO;uid=sa;pwd=;"
> set rs = server.createobject("adodb.recordset")
>
> rs.open sql,conn,3,3
>
> where is the ADO Cursor Engine ??
> it's on WEB server or Sql server...
> (and which maintain it.. O.S or Sql Server?? )
>
> 2.
> set conn = server.CreateObject ("ADODB.Connection")
> conn.cursorlocation = adUseServer
> conn.Open "DSN=ADO;uid=sa;pwd=;"
> set rs = server.createobject("adodb.recordset")
>
> rs.open sql,conn,3,3
>
> where is the ADO Cursor Engine ??
> it's on WEB server or Sql server...
> (and which maintain it.. O.S or Sql Server?? )
>
>
> if u know the answer,please tell me ~ thank you very much~
> Steven.
>
>
>
>
>
>
|
|
|
View Cart
