devxlogo

ADODB.Recordset Type “Not Defined”

ADODB.Recordset Type “Not Defined”

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.

See also  Comparing different methods of testing your Infrastructure-as-Code
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