I think either table engine would be OK but InnoDB has some good extra features and is the default in recent versions of MySQL so I would go with that.
Now about your connection problem.... You need to check the following things in this order. Can you get to the server machine on the network? Ping should check that. If not some routing tables may need to be changed. Consult your networking people. Can you get to the MySQL port (usually 3306 but might be different)? I'm not sure how you check that. If you get this far you should get some response from MySQL even if it is just to tell you that access is denied. If that happens it is a MySQL permissions problem. Make sure the user you are logging in as (to MySQL) has permission to log in from the host where you are running the client. How far do you get when you try to connect your client to the MySQL server? Do you get any error messages? Make sure your VB6 application fully reports any errors that happen on the database connection. (It will depend on how you are connecting how you do that.) John B. -----Original Message----- From: Michael Louie Loria [mailto:[EMAIL PROTECTED] Sent: Thursday, 14 July 2005 10:46 AM To: John Bonnett, R&D Australia; [EMAIL PROTECTED]; mysql@lists.mysql.com Subject: Re: Engine Type -- I don't quite understand your question. I assume you are interested in the MySQL database engine. The latest production version of MySQL should be fine for this, running on suitable hardware. The server would not actually be VB6 but I assume you mean that there may be some head office clients written using VB6 that access the same database as used by all the branches. If you give me more details I could offer some more advice. -- My question was: "What is the best engine for the project I will create?" MyISAM, InnoDB, etc.. The server and client applications will be created with Visual Basic 6. The OS of server and client will be windows 2000 or XP. The clients will be scattered in different places. The client and server connection will through VPN. The Server will have a payroll and Daily Time Record (DTR) system while the client will only have the DTR system. Everytime an employee from a branch (client part) logs in. The info will be saved to the Server (MySQL) passing through VPN. But my problem is still I can't connect my client application to the server which contains the mysql database. But when I run my client application in the server, the client applications runs. I have disabled all firewalls. But still solving this problem. Hope I could get some insights regarding this problem. Thanks, Michael Louie Loria __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
