Welcome to dbFreaks.com!
FAQFAQ   SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Sever-side cursor return NOTHING??(newbie)

 
   Database Help (Home) -> Visual Basic -> ADO RSS
Next:  password protection - does this work?  
Author Message
Sam Tee

External


Since: Feb 21, 2005
Posts: 1



(Msg. 1) Posted: Mon Feb 21, 2005 12:40 am
Post subject: Sever-side cursor return NOTHING??(newbie)
Archived from groups: microsoft>public>vb>database>ado (more info?)

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.

 >> Stay informed about: Sever-side cursor return NOTHING??(newbie) 
Back to top
Login to vote
Val Mazur

External


Since: Oct 31, 2003
Posts: 562



(Msg. 2) Posted: Fri Feb 25, 2005 9:11 pm
Post subject: Re: Sever-side cursor return NOTHING??(newbie) [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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" <sammteee.TakeThisOut@hotmail.com> wrote in message
news:421967c9$0$38846$ec3e2dad@news.usenetmonster.com...
> 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.
>
>

 >> Stay informed about: Sever-side cursor return NOTHING??(newbie) 
Back to top
Login to vote
Display posts from previous:   
   Database Help (Home) -> Visual Basic -> ADO All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]