Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: Visual Basic
Expertise: Beginner
Jan 10, 2000

ADO

Question:
I want to open a small ADO recordset from the server and save it the local drive to be used as a disconnected session. Can you tell how to do that?

Answer:
If you want to use the recordset in a disconnected state, meaning that it no longer has a connection to the server, use a client-side cursor and, after fetching the data, set the recordset's ActiveConnection to Nothing.

To save the recordset to disk use the recordset's Save method, and open it with the Open method passing the file name and adCMDFile for the options parameter.

DevX Pro
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date