Access MySQL databases using ODBC and ADO 2.7

Category:
Database
Type:
Classes
Difficulty:
Intermediate

Author: Anonymous

Version Compatibility: Visual Basic 6

More information:
The usual way to use this class is to call Connect after creating an instance of the class, then use Query2 to run queries (or Query3 if no data will be returned from queries). If an operation fails, check the LastError property to see what went wrong. Some functions in this class: Connect, connect to the MySQL database PutBlob, fill a blob field GetBlob, get data from a blob field PutFile, store a file in a blob field GetFile, retrieve a file from a blob field Query3, performs a query with no return data Query2, performs a query with return data MultiQuery2, performs multiple queries with return data MultiQuery, performs multiple queries with return data AddSlashes, adds slashes to a value so that it won't break query ResizeArray, resize a two dimensional array

Instructions: Copy the declarations and code below and paste directly into your VB project.

Declarations:

Code: