Sever-side cursor return NOTHING??(newbie)

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sam Tee - 21 Feb 2005 04:47 GMT

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.

Reply to this Message

Val Mazur - 26 Feb 2005 02:11 GMT

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

Signature

Val Mazur
Microsoft MVP

http://xport.mvps.org

> Hi,
> I try to use dataenv object. I add new connection (jet 3.51 provider with
[quoted text clipped - 7 lines]
> Thank you in advance.
> Sam.

Reply to this Message

VB Forum / Database Access / February 2005

Sever-side cursor return NOTHING??(newbie)