Engine Type

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA512

I would like to ask what is the best type of engine
for this project I
will take

Payroll and Daily Time Record system

- -
Payroll system is located in the head office (server).
Daily Time Record is located in all 10 branches
(clients).

The connection from client to server is VPN

The Daily Time Record will save the data to the server
everytime an
employee logs in.

The server and client will be developed with Visual
Basic 6.


Thanks,

Michael Louie Loria
-----BEGIN PGP SIGNATURE-----
Comment: GPG Public Key:
https://www.biglumber.com/x/web?qs=0x4A256EC8
Comment: GPG Public Key:
http://www.lorztech.com/GPG.txt
Comment: Yahoo ID: michaellouieloria

iQEVAwUBQtVSiLXBHi2y3jwfAQo8gwf+OrUCgzirjzpWXtTcAaXREFJTlXVV 5mhJ
ggN75al7O47V7hIhY+8rUu9HOYAJj/Hp3HGo3Ls5AJ8febV9uXYW9RK424iU Op8p
j7DckjisWwVXGqmKlD5dd7ftjNay5C3Otx23+ggEFqA8pwNEp2yZsppxhR6n 00Tq
8kwy6wuGlizwIkLgktah1Xcae1d6YvmuvC7kC1dTQypzd2/Kgz7TJKsqCYrv u7EN
0BX1lwIDkolG5ifWJtnRRebM53A5zxSahhItRl6r6MyJMPsg4sa+QeRyzM+q gdRd
r2Kn6kem8gvKA5m3uNWVRqFraHf/ciENKsYXhIvYSxrvO1ScOXkdgQ==
=hx6L
-----END PGP SIGNATURE-----


--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.323 / Virus Database: 267.8.13/47 -
Release Date: 7/12/2005




____________________________________________________
Start your day with Yahoo! - make it your home page
http://www.yahoo.com/r/hs


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org

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.

John Bonnett

-----Original Message-----
From: Michael Louie Loria [mailto:michaellouieloria@yahoo.com]=20
Sent: Wednesday, 13 July 2005 8:13 PM
To: win32@lists.mysql.com; mysql@lists.mysql.com
Subject: Engine Type

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA512

I would like to ask what is the best type of engine
for this project I
will take

Payroll and Daily Time Record system

- -
Payroll system is located in the head office (server).
Daily Time Record is located in all 10 branches
(clients).

The connection from client to server is VPN

The Daily Time Record will save the data to the server
everytime an
employee logs in.

The server and client will be developed with Visual
Basic 6.


Thanks,

Michael Louie Loria
-----BEGIN PGP SIGNATURE-----
Comment: GPG Public Key:
https://www.biglumber.com/x/web?qs=3D0x4A256EC8
Comment: GPG Public Key:
http://www.lorztech.com/GPG.txt
Comment: Yahoo ID: michaellouieloria

iQEVAwUBQtVSiLXBHi2y3jwfAQo8gwf+OrUCgzirjzpWXtTcAaXREFJTlXVV 5mhJ
ggN75al7O47V7hIhY+8rUu9HOYAJj/Hp3HGo3Ls5AJ8febV9uXYW9RK424iU Op8p
j7DckjisWwVXGqmKlD5dd7ftjNay5C3Otx23+ggEFqA8pwNEp2yZsppxhR6n 00Tq
8kwy6wuGlizwIkLgktah1Xcae1d6YvmuvC7kC1dTQypzd2/Kgz7TJKsqCYrv u7EN
0BX1lwIDkolG5ifWJtnRRebM53A5zxSahhItRl6r6MyJMPsg4sa+QeRyzM+q gdRd
r2Kn6kem8gvKA5m3uNWVRqFraHf/ciENKsYXhIvYSxrvO1ScOXkdgQ==
=3Dhx6L
-----END PGP SIGNATURE-----


--=20
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.323 / Virus Database: 267.8.13/47 -
Release Date: 7/12/2005



=09
____________________________________________________
Start your day with Yahoo! - make it your home page
http://www.yahoo.com/r/hs
=20


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql@m.gmane.org

Re: Engine Type

--0-230926090-1121303742=:26548
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
Content-Id:
Content-Disposition: inline

--
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
--0-230926090-1121303742=:26548
Content-Type: application/pgp-signature; name="signature.asc"
Content-Transfer-Encoding: base64
Content-Description: 3412282408-signature.asc
Content-Disposition: attachment; filename="signature.asc"

LS0tLS1CRUdJTiBQR1AgU0lHTkFUVVJFLS0tLS0NCkNvbW1lbnQ6IEdQRyBQ
dWJsaWMgS2V5OiBodHRwczovL3d3dy5iaWdsdW1iZXIuY29tL3gvd2ViP3Fz
PTB4NEEyNTZFQzgNCkNvbW1lbnQ6IEdQRyBQdWJsaWMgS2V5OiBodHRwOi8v
d3d3Lmxvcnp0ZWNoLmNvbS9HUEcudHh0DQpDb21tZW50OiBZYWhvbyBJRDog
bWljaGFlbGxvdWllbG9yaWENCg0KaUQ4REJRRkNyd1IzRVdMSGYwb2xic2dS
QTB5MEFLQ0w4aWFjaXA1eGZFWG1sVkkzem0xTzBWenpjQUNlS1JjMQ0KVjI1
ZjI2NlJ4Rk55bXVLV2dXaDhIdDQ9DQo9R2FrOA0KLS0tLS1FTkQgUEdQIFNJ
R05BVFVSRS0tLS0tDQoNCi0tLS0tLS0tLS0tLS0tZW5pZ0JBQURGMDAxQUZC
ODUwOUVFNzFGMkUwQS0t


--0-230926090-1121303742=:26548
Content-Type: text/plain; charset=us-ascii


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org
--0-230926090-1121303742=:26548--

RE: Engine Type

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.)=20

John B.

-----Original Message-----
From: Michael Louie Loria [mailto:michaellouieloria@yahoo.com]=20
Sent: Thursday, 14 July 2005 10:46 AM
To: John Bonnett, R&D Australia; win32@lists.mysql.com;
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=20
http://mail.yahoo.com=20

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql@m.gmane.org

Re: Engine Type

-----BEGIN PGP SIGNED MESSAGE-----
Hash: RIPEMD160

jbonnett@sola.com.au wrote:
> 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.
>

I think I stick with InnoDB. I already fixed, it was
not the problem of
MySQL. It was the fault of the VPN. I change my
encryption to 3DES frm
AES-256 and it worked. I think it had to do something
with my key size
which is only 1024.

Thanks for da help,

Michael Louie Loria
-----BEGIN PGP SIGNATURE-----
Comment: GPG Public Key:
https://www.biglumber.com/x/web?qs=0x4A256EC8
Comment: GPG Public Key:
http://www.lorztech.com/GPG.txt
Comment: Yahoo ID: michaellouieloria

iD8DBQFCr0N9EWLHf0olbsgRA3QeAJwKJEt3BLmuNRPf99AKmyZEHYMriQCf cVcd
zgyStn3UcOkHx/RRcbsrY9E=
=SSIa
-----END PGP SIGNATURE-----



____________________________________________________
Start your day with Yahoo! - make it your home page
http://www.yahoo.com/r/hs


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org