[Fwd: Re: MySql with Visual Basic]

Actually it could be considered more mature than MyVbQl at this point,
and is available at www.vbmysql.com, a site dedicated to VB-MySQL
development.



Mike


Daniel da Veiga wrote:
> I wouldn't use ADO to connect with MySQL, it seems that you'll have
> more trouble dealing with the objects than really doying any work with
> the database itself. I am using an old version of a standalone library
> called MyVBqL, that later evolved into VBMySQLDirect, wich is still
> under development I believe... Its a single dll that can be easily
> registered, solving many problems (VBA for instance, when Word can't
> find the datasources).
>
> Hope that helps,
>
>
> On Thu, 10 Mar 2005 11:52:12 -0500, Lawrence Martin wrote:
>
>>Inquiry To List:
>>
>>From: James Murphy [mailto:jameshmurphy@yahoo.com]
>>Sent: Thursday, March 10, 2005 10:20 AM
>>To: win32@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 !
>>
>>Regards,
>>Larry Martin
>>
>>--
>>MySQL Windows Mailing List
>>For list archives: http://lists.mysql.com/win32
>>To unsubscribe: http://lists.mysql.com/win32?unsub=danieldaveiga@gmail.com
>>
>>
>
>
>

--
Mike Hillyer, Technical Writer
MySQL AB, www.mysql.com
Office: +1 403-380-6535
Mobile: +1 403-330-0870

MySQL User Conference (Santa Clara CA, 18-21 April 2005)
Early registration until February 28: www.mysqluc.com


--
Mike Hillyer, Technical Writer
MySQL AB, www.mysql.com
Office: +1 403-380-6535
Mobile: +1 403-330-0870

MySQL User Conference (Santa Clara CA, 18-21 April 2005)
Early registration until February 28: www.mysqluc.com

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org