RE: ODBC problem

2002-10-30 Thread GAY Samuel
p? DSN, ADO Connection String, DAO, etc... JFercan *** sql *** -Original Message- From: GAY Samuel [mailto:S.GAY@;envergure-conseil.com] Sent: October 30, 2002 04:47 To: Mail List MySQL (E-mail) Subject: ODBC problem Hi, To test MySQL I'm migrating a small VB project wich already run wi

ODBC problem

2002-10-30 Thread GAY Samuel
Hi, To test MySQL I'm migrating a small VB project wich already run with SQLServer2000 to try ODBC. I've a problem with two versions of MyODBC (2.50.39 and 3.51.04). I can connect, make some "select..." with succes, one update, and my VB program always crash on an update ! Here is the request,

RE: Backup DB

2002-10-29 Thread GAY Samuel
Hi, Shut your database down, backup all files, and restart it If you use InnoDB you can do a hot backup like Oracle (the implementation of InnoDB is near of Oracle), but it's not free. I can't say more about this, but it's in the documentation about InnoDB. You can also keep a differenti

Multiple MySQL running

2002-10-29 Thread GAY Samuel
Hi, I'm a new user of MySQL (but not of databases...), and new member of this mail-list, and I hope I don't bother anyone with a question already asked (and with my english...). I'm interested in the InnoDB part of MySQL because I thing it's more reliable than other table's type, and because i