WildBill42
Programmer
I have searched this formum and Visual Basic and I can get into dbf databases, but not MySql. In the Data1 (ADO) component attributes are not MySql or MyODBC aware.
The attribute Default Type only specifies Use Jet or use ODBC (apparently Microsoft's ODBC) noy MyODBC. The Connect attribute dors not list MySql (but I work fine with dbase50 for example.
I set the Database Name attribute to C:\Mysql\data\myEvents, which is the database name.
The attribute Record Source does not list my one table.
I can sql in MySql directly and get all of the results I expect, I just can not get Visual Basic 6 to recognize MySql or MyODBC. Ant assistance will be appreciated.
The attribute Default Type only specifies Use Jet or use ODBC (apparently Microsoft's ODBC) noy MyODBC. The Connect attribute dors not list MySql (but I work fine with dbase50 for example.
I set the Database Name attribute to C:\Mysql\data\myEvents, which is the database name.
The attribute Record Source does not list my one table.
I can sql in MySql directly and get all of the results I expect, I just can not get Visual Basic 6 to recognize MySql or MyODBC. Ant assistance will be appreciated.