devxlogo

Overcome ODBC ErrorTip Correction-Same ol’ Story

Overcome ODBC ErrorTip Correction-Same ol’ Story

A tip on page 48 of the March 1996 issue of VBPJ statesthat an ODBC error message occurs when using VB3 with the Access2.0 compatibility layer. An error occurs if DB_SQLPASSTHROUGHis used to create a record set and then another record set iscreated without fully populating the previously opened one. Thearticle 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 aroundit. If you create a record set that is only going to return onerow you do not need to do this, and you can use DB_FORWARDONLY,which speeds up the query.

See also  lenso.ai - an AI reverse image search platform
devxblackblue

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist