Hello all,
I'm new to MySQL and have a couple quick questions....
1. In my client app (Delphi 2006), what do I need to have to make a MySQL db using your components? Is there some type of MySQL library that needs to be distributed with my app?
2. I've read that your components can directly connect to a MySQL db over the net. Is there a quick an easy method to make sure that the DB on the client side is in sync with the db on the server?
3. If I create a user on my server to have access to the MySQL db, is it ok to give all client users the same username and password so I don't have to manage numerous accounts? If so, can multiple clients connect at the same time with the same username and password?
Thanks again for any help or advise you can provide. I think these components are what I've been looking for a along, but since I'm new to MySQL I'm not sure. I'm used to working with DBISAM on the client side.
Cheers,
Bryan
Newbie question MySQL client app
Brian,
1]I can advise you to download the MyDAC components trial version.
The components don't need dll's to use on the client side.
2] What do you mean by synch Having the same time or that one DB is a mirror of the other?
3] Yes you can do that. If the user has many rights on the database than i can advise you
to use different users so you can trace who did what.
Another possibility is to use many users with the same password.
I am very sattisfied with the mysql components (Delphi 6 compiler) and can advise you to give it a try
Teunis
1]I can advise you to download the MyDAC components trial version.
The components don't need dll's to use on the client side.
2] What do you mean by synch Having the same time or that one DB is a mirror of the other?
3] Yes you can do that. If the user has many rights on the database than i can advise you
to use different users so you can trace who did what.
Another possibility is to use many users with the same password.
I am very sattisfied with the mysql components (Delphi 6 compiler) and can advise you to give it a try
Teunis
Last edited by teunis on Sat 10 Feb 2007 15:18, edited 1 time in total.
Thanks for your reply, but what if I want the MySQL DB on my server to be replicated on my client app side. How do I access the client MySQL DB?teunis wrote:Brian,
1]I can advise you to download the MyDAC components trial version.
The components don't need dll's to use on the client side
Am I thinking about this the wrong way?
I will be downloading data from the server MySQL DB only. No inserts, or updates to the server data from client...
Thanks again,
Bryan
