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

By submitting your information, you agree that devx.com may send you DevX offers via email, phone and text message, as well as email offers about other products and services that DevX believes may be of interest to you. DevX will process your information in accordance with the Quinstreet Privacy Policy.


Tip of the Day
Language: Visual Basic
Expertise: Beginner
Aug 7, 1997

WEBINAR:

On-Demand

Application Security Testing: An Integral Part of DevOps


Overcome ODBC ErrorTip Correction-Same ol' Story

A tip on page 48 of the March 1996 issue of VBPJ states that an ODBC error message occurs when using VB3 with the Access 2.0 compatibility layer. An error occurs if DB_SQLPASSTHROUGH is used to create a record set and then another record set is created without fully populating the previously opened one. The article concludes by saying that the error does not occur in VB4.

I currently use the 32-bit version of VB4 which uses Jet 3.0, and this error still occurs. I use the above method to get around it. If you create a record set that is only going to return one row you do not need to do this, and you can use DB_FORWARDONLY, which speeds up the query.

Dave Barraclough
 
Comment and Contribute

 

 

 

 

 


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

 

 

Sitemap
×
We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.
Thanks for your registration, follow us on our social networks to keep up-to-date