devxlogo

ADODB.Recordset Type “Not Defined”

Why Trust Us

Question:
I copied the following code from a good book on e-commerce, but the VB code (Visual Studio 6.0 Enterprise) gets an error on the Dim rsBankData line “User-defined type ont defined.” Why is this?

Option ExplicitPublic Function Transfer(vUserName As Variant, vTransferAmount As Variant, _  vSavingsBalance As Variant, vCheckingBalance As Variant) As Variant  '/  Declare local variablesDim cyTransferAmount As CurrencyDim strQueryString As StringDim rsBankData As ADODB.Recordset

Answer:
Make sure that you have a reference to the Microsoft Active Data Objects library in your project. Once you do this, all the ADODB types will be available to you.

Charlie has over a decade of experience in website administration and technology management. As the site admin, he oversees all technical aspects of running a high-traffic online platform, ensuring optimal performance, security, and user experience.

See also  Five Early Architecture Decisions That Quietly Get Expensive
Disclosure

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.

Show More