Hello, I am new to VB and MySQL connections.

I can use ether VB6 or VB.NET.

I need to make an ODBC connection to MySQL
and then I need to have the VB program poll the table
every 10 minutes.
What are some general guidles to acomplish this?

Thanks
Taccea

Form Template: MySQL Connection Property Form:
http://www.veign.com/vrc_codeview.asp?type=app&id=92

VB MySQL:
http://www.vbmysql.com/

Above are some samples to connect to a MySQL database using the ODBC
connector.  What exact issues are you having?

Show quoteHide quote

In message <XdGdnZgE4et0sw_fRVn***@adelphia.com>, taccea
<tac***@adelphia.net> writes
It really depends on what you want to do in the database every 10
minutes. However, generally you would add a timer to your Form and set
it to fire once a minute (no point firing more frequently as your going
to ignore anyway). On every 10th firing on the event you would:

1.  Stop the Timer.
2.  Make connection to MySQL.
3.  Perform polling of required table and apply any updates.
4.  Close connection to MySQL.
5.  Reset counters.
6.  Restart the Timer.

You would normally Stop and Start the timer just in case your polling
operations take more than 10 minutes (ie: you don't want the event to
fire again while you are in the middle of processing the previous one).

If you only want to read a table to extract something that is relevant
to your application then I would suggest using a FireHose cursor (ie:
client side, read only, forward only) for speed.

If you need to update the database during the processing then pick an
appropriate cursor.

Don't forget to and some DoEvents into your processing loop to keep
things running smoothly.

Need some help in compressing bmp file to jpeg file
Get rid of flicker inside a frame.
VB6 don't see events of the implemented interface
checkbox always is disabled!!!!
X-axis value of Excel chart
load extern exe file into mdi framework?
Installing Fonts
using user defined types
Optimizing Binary File Input
Touchscreen Keyboard