Inquiry To List:

From: James Murphy [mailto:jame...@yahoo.com] Sent: Thursday, March 10, 2005 10:20 AM To: win...@lists.mysql.com Subject: MySql with Visual Basic

I am trying to find some information on using Visual Basic with MySql. What works and what does not. How do I handle a timestamp field.

========================================================================= Reply To List: March 10, 2005

I am using VB6 (VS6, Enterprise) with MySQL 4.1.10 and MySQL ODBC 3.5.11 using XP Pro OS.

Recently I have been 'fooling around' with the Microsoft Active-X Data Objects (ADO) interface using the 'adodc' and 'datagrid' components under ADO 2.8 Libraries.

Also, I would recommend looking at the ADO samples from Microsoft in the MSDN collection if you have it. The DataObjects Collection object that maps (links) external database fields to VB components is a very powerful concept and works brilliantly !

As far as a MySQL timestamp field is concerned, I have found that mapping it to a VB text field and parsing the various elements as needed 'works for me' (ie. working with it as a VB string)

ADO is covered in rich detail in various Microsoft online venues (MSDN et al), many different VB user groups on the web, and in the technical literature. I could recommend two books that I have; 'Serious ADO: Universal Data Access with Visual Basic' by Rob Macdonald and 'ADO Examples and Best Practices' by William R. Vaughn.

HTH !