Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Visual Basic 6, Myodbc, mysqld-opt 3.23.47 and ADO Data1

Status
Not open for further replies.

WildBill42

Programmer
Feb 25, 2002
3
US
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top