Sever-side cursor return NOTHING??(newbie)

Hi,
I try to use dataenv object. I add new connection (jet 3.51 provider with
Biblio example) and then add command (all use server side cursor) and then
drag command in to Form .
However, when I run the project (vb6 sp5 WinXP sp1), I got nothing in the
controls (textboxes).
But if I change to client side cursor, it works (as it should be).
Why?

Thank you in advance.
Sam.

Hi Sam,

Could be several reasons. First check next KBs about potential issues

http://support.microsoft.com/default.aspx?scid=kb;en-us;216666

http://support.microsoft.com/kb/191457/EN-US/

But in a case of server-side cursor bound controls just do not see any
records until you fetch them and this is one of the reasons why we need to
avoid binding of the controls, because you have little control over it. Your
solution in this case would be to switch to the client-side cursor

--
Val Mazur
Microsoft MVP

http://xport.mvps.org

"Sam Tee" wrote in message

> Hi,
> I try to use dataenv object. I add new connection (jet 3.51 provider with
> Biblio example) and then add command (all use server side cursor) and then
> drag command in to Form .
> However, when I run the project (vb6 sp5 WinXP sp1), I got nothing in the
> controls (textboxes).
> But if I change to client side cursor, it works (as it should be).
> Why?
>
> Thank you in advance.
> Sam.
>
>