GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Interview Questions  >  Microsoft  >  Visual Basic
Go To First  |  Previous Question  |  Next Question 
 Visual Basic  |  Question 378 of 453    Print  
What is adUseClient and adUseServer?
where it is going to affect in runtime?

  
Total Answers and Comments: 2 Last Update: May 08, 2006     Asked by: Dipak Apate 
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
April 12, 2006 07:42:02   #1  
Arun        

RE: What is adUseClient and adUseServer?where it...

These are constants in CursorLocationEnum of CursorLocation property on a ADO Connection object.

If the CursorLocation property is set to adUseClient then the recordset will be in read only mode i.e. the recordset cannot be used to update records in the database. A recordset with the CursorLocation asUseClient is typically used when an active Recordset is Disconnected for viewing data.

By setting the CursorLocation as adUseServer the recordset can perform any transaction with the database.


 
Is this answer useful? Yes | No
May 08, 2006 02:13:06   #2  
amrita sinha        

RE: What is adUseClient and adUseServer?where it...

hello All

First I must say you all that until u are not very clear about your answers plz dont post here.

UseClientSide cursor location doesnot mean that that recorset is in read only mode!!!!!!!!!!!!!!.

This is nothing to do with disconnected recordset tooooooooooo.

If u are using cursor location to client side it means that the reference to the recorset is in client machine's RAM. if there are 1000 records..... they all reside on client machine not on server which will happen in the other case (when cursor location is on server side). this means if u are moving recodset its going to take place on ur local machine........... no server trip at all.

And for your kind information............... Oracle does not suport server side cursor.

Ok then

bye


 
Is this answer useful? Yes | No

 Related Questions

Latest Answer : There are many property which cannot be changed at runtime i.e locked, passwordchar, multiline etc. If maxlength property of textbox is set to 0 it indicates user can enter a value of any length. ...

Latest Answer : Placed a command button on the form, in each click we are adding a mnu itemPrivate Sub Command1_Click()Static bbbb = bb + 1Load Mnuaa(bb)MnuAA.caption = "Item" & bbMnu(bb).Visibal = trueEnd Sub ...


At runtime, Property used to count number of items in a combobox,resize a label control according to your caption.?

Syntax Errors, Runtime , Logic.  

Latest Answer : hello AllFirst I must say you all that until u are not very clear about your answers plz dont post here.UseClientSide cursor location doesnot mean that that recorset is in read only mode!!!!!!!!!!!!!!.This is nothing to do with disconnected recordset ...
Read Answers (2) | Asked by : Dipak Apate

Q. How we can create a controls like textboxes or buttons on runtime according or depends to the output from the database?
Read Answers (3) | Asked by : Akshay


 Sponsored Links

 
Related Articles

jQuery - Basic Alphabetical Sorting

Learning jQuery Basic Alphabetical Sorting Now let s perform a sort on the Title column of the table We ll need a class on the table header cell so that we can select it properly geshibot lang html" Title Author s Publish Date Price geshibot mosgoogle To perform the actual s
 

Working with XML in Visual Basic

Working with XML in Visual Basic Extensive markup language and Visual Basic is the odd couple of the industry Visual Basic is one of the most common languages that are being used today This Microsoft introduced language was meant to be middle tier in characteristic but has managed to get the top tie
 

SDLC Model Basic Stages

SDLC or the Software Development Life Cycle refers to the steps involved in creating a software from scratch.  During earlier days, software used to be scarce and its creation was comparatively easier.  Developers could create any programs they want and experience no competition. I
 

The Interview Snafu

How to turn someone else’s mistake to your advantage Your dream job is about to become reality. A recruiter gave you the heads up about the perfect position at Humungous Conglomerate, Inc. You went through five interviews as well as a battery of psychological tests mandated by their HR de
 

Winning a Job Interview with a Winning Resume

Does your resume unlock your potential, take your skills to the highest level and win you the interview and the job you want now? The job market today is highly competitive and even if you think you have what it takes to get an interview you won’t get over the line without a polished, prof
 

Basic PC Skills

For those that have decided to walk into the world of technology, they may be overwhelmed by the types of knowledge that are available.  There are several code languages and words as well as different areas that you can move into.  If you are a beginner in technology, you can fin
 

Importance of Proper English during Job Interview

Importance of Proper English during Job Interview Your job interview is crucially important and it will determine whether or not you will get the job Depending on the type of job you re going for it is very important for you to use proper English In most cases jobs which offer higher salaries will h
 

Scholarship Basic Facts

Scholarship Basic Facts A scholarship is a financial award that is given to students by colleges universities or other organizations The goal of a scholarship is to enhance the education of the student There are a wide variety of scholarships available and each scholarship will require applicants to
 

HR Interview - HR Interview Mistakes You Will Want To Avoid

HR Interview Mistakes You Will Want To Avoid The job interview can be a stressful process This is especially true for those who are going after a competitive position Your nonverbal communication combined with the answers you give during the interview will determine if you are hired mosgoogle While
 

HR Interview - Behavioral HR Interviews

Behavioral HR Interviews As the name implies a behavioral interview is an interview that is held by a human resources department to determine if an applicant has the behaviors that are appropriate for a job The company must know how an applicant will behave in a certain situations mosgoogle The logi
 

About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape