VB and ODBC

pts.
Tags:
Visual Basic
connecting to a database by ADO through ODBC, are the queries Pass-through or ODBC Direct?

Answer Wiki

Thanks. We'll let you know when a new response is added.

Hi Carbon,

They can be either depending on how you do it.

Pass Through queries [harking back to MS Access] are where code is executed directly against the database using for example a Connection object to execute SQL strings.

Direct access is when you work with an ADO recordset that you instantiate, manipulate and send back to the database [If required].

Hope this helps/makes sense 🙂
M

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: