Access MySQL databases using ODBC and ADO 2.7
Category:
DatabaseType:
ClassesDifficulty:
IntermediateAuthor: 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: