SqlDependency - MySQL equivalent

[David]

Hi all,

I little while ago, I asked about app design and updating screens when data
changed. The outcome was that I could use SqlDependency.

I have found out that the client is using mostly based around Linux and that
their DB runs on MySQL. While my app can still use SQL and I can interface
to their MySQL, it would make it much easier and allow them to self fix the
data if I used MySQL, however, I don't know what options there are to notify
my application of any changes in data.

Also, at this point in time, I don't know what version of MySQL they are
using.

So, is the only solution for me to poll the data or is there some way of my
application being notified of a change of data from a MySQL database?

--
Best regards,
Dave Colliver.
http://www.AshfieldFOCUS.com
~~
http://www.FOCUSPortals.com - Local franchises available

 

[vanderghast]

Add a MS SQL Server Express (it is free), and from it, link the tables to
MySQL ?

You app will speak to an MS SQL Server engine, even if the data is not
natively stored there. Sure, it is preferable to have the SQL Express
version on the PC with your application, so you won't use an extra network
communication trip to the queries.


Vanderghast, Access MVP

 

[CY]

Add a MS SQL Server Express (it is free), and from it, link the tables to
MySQL ?

SQLEx will not as I recollect use the net.
//CY