Hej all,
Andrew Gable wrote:
Hi all,
Does anyone know any good free to use replication software.
What i have is as follows
I have 4-20 terminals with a database that holds all the products/
cashier ids etc in it and I want the system to sync the local database
to it the server and then delete any data that his has processed
can this be done with Replication or do I need to create my own app to
handle this
Sorry, could't resist: first answers @ google when searching for
firebird replication
http://www.firebirdsql.org/en/some-solutions-to-old-problems/
http://www.firebirdfaq.org/faq249/
http://www.symmetricds.org/
http://www.ibphoenix.com/download/tools/replication
IIRC, Holger Klemt (ibexpert.net) has written an article about how to
build your own replication some few years (~2005?) ago in a german
developer magazin.
There are several show stoppers buried in the database layout, such as
ids, primary and foreign keys, unique values, generators and triggers.
Also does anyone know anyway of checking to see if the server is online
before connection to it in VB6 (via ODBC Driver)
You will have no luck accessing the firebird services API via ODBC, as
ODBC is data only.
One option would be to work with something like try-catch(-finally). I
don't know if that feature is available in VB6
Feel free to take a look at:
- http://pythonhosted.org/fdb/usage-guide.html#working-with-services
Even if not programming in python, it declares a lot about how to attach
to a service.
thanks
Andy
hth, Marcus
++
Visit http://www.firebirdsql.org and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !
Also search the knowledgebases at http://www.ibphoenix.com
++
Yahoo Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/
* Your email settings:
Individual Email | Traditional
* To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)
* To change settings via email:
firebird-support-dig...@yahoogroups.com
firebird-support-fullfeatu...@yahoogroups.com
* To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com
* Your use of Yahoo Groups is subject to:
http://info.yahoo.com/legal/us/yahoo/utos/terms/