RE: FN-FORUM Database question

date posted 9th April 2002 10:45

Hi Darren,

I am not sure about synchronizing the two databases but I would be
interested to know
if anybody else has a way of doing it.
However if the only thing you want is a COPY of the remote database (IE :
you don't update
it locally), then you might want to try to backup the remote one and
download the backup.

On the second point, I would try the ODBC driver, which will allow you to
use all your
usual VB database components. I program myself using DELPHI, and that's the
way I would
go about it, at least to start. If performance is an issue, you might want
to search
for native drivers, possibly ADO drivers if such a thing exists.
Anyway, the address is http://www.mysql.org/downloads/index.html for the
ODBC drivers.

I hope it helps,

Guillaume.
============================================
Guillaume JUSTIER
Inmeres Solutions Ltd

[e] [EMAIL REMOVED]
[w] www.inmeres.com
[t] +44 (0)7980 743 771
[f] +44 (0)7092 012 199
[a] 6 Cambridge Square
Royal Earlswood Park
Redhill
Surrey
RH1 6TG
UK
============================================


-----Original Message-----
From: [EMAIL REMOVED]
[EMAIL REMOVED] Behalf Of Darren Spink
Sent: 08 April 2002 13:28
To: [EMAIL REMOVED]
Subject: FN-FORUM Database question


Good afternoon everyone...just a quick question....looking for others
views/opinions etc...

I am just designing a database system (MySQL) to work on a web site, but I
am also planning to have the same database sat locally. Now here is the
part for everyone, I am wondering the best way of synchronising the 2
databases (web and local), does anyone have any views/advice on this. Also
has anyone tried to develop a local database (probably in Visual Basic) that
uses/accesses MySQL ?

TIA

Regards


Darren Spink

T: 0113 2534750
F: 0113 2531686
E: [EMAIL REMOVED]
W: http://www.arkad.co.uk



==================================================================
= ******************** Take a Break ******************** =
= http://liveinthemix.com Music and much more =
= Check out the forum and chat to others interested in new music =
==================================================================


Sponsor the forum for as little as £1 at:

http://www.freelancers.net/cgi/sponsor.cgi?action=show


Freelancers and Freelance Jobs:
http://www.freelancers.net

Forum FAQs:
http://freelancers.netrickery.com

To unsubscribe please email:
[EMAIL REMOVED]

If you have difficulties unsubscribing please email:
[EMAIL REMOVED]