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" 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.
>
>

 >> Stay informed about: Sever-side cursor return NOTHING??(newbie) 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
VB6 using ADO, sproc with return recordset - VB6 code snippet: with cmd .cmdtext = "exec buildwordlist 11" .commandtype = adcmdtext end with set rs = cmd.execute() if not rs.eof then strfield = rs!fieldname rs.movenext end if the above code works just fine if the sproc is ...

newbie - how to resize column MSFlexGrid - newbie - how to resize column MSFlexGrid I do not see in properties, maybe I am blind, how to change column width. I would like to set it to just resize automatically to widest field of the column, of corse. can I, may I!!!??? thanks -- Adam S

newbie - late bind datalist doesn't populate - Private Sub cmdLookUpGroupInfo_Click() In the code below, I succesfully was able to bind and polpulate a text box with my select statement. But I need multiple table rows to be populated so I cannot use the text box. So I am trying to use the..

runtime error 3021 and user permissions - I have a VB6 application that uses ADO 2.7 to access an Access2000 database. I have found on Windows XP and 2000, that if the user is not part of the administrators group, they receive: "runtime error 3021. Either BOF or EOF is true, or the current ...

updatable ado-recordset - Hi, In the code below i have an updatable ado-recordset. However it is not working how i thought it would be. Maybe someone can help me out here? The global connection (Thanks to Brendan): Option Compare Database Option Explicit Public mconn As..
   Database Help (Home) -> Visual Basic -> ADO All times are: Pacific Time (US & Canada)
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 ]