I am trying to build an app using MySQL and of course Delphi with Zeos components.
So... I need to deploy my application to my client that has a small LAN and will be using my app on all the computers. One of the computers will be the server for my MYSQL database and the rest of the users will access the DB through LAN.
So far I used MS ACCESS for my apps and used ODBC. Now with Zeos I connect directly to the MYSQL database so there's no need for ODBC :)
My problems are
1... Do I need to build 2 different apps (one for use on the server and the other for the use on the rest of the LAN members) ?
2... If so... then what settings do I need to make on the server/(and)or the client to make it work.
(rigth now it tells me that "host 192.168.0.25 is not allowed to connect to this MYSQL Server" where the host is the workstation not the server, and the MySQL server is on a Windown XP)
To be short tell me what should I do to be able to connect to my MySQL server that is installed on an XP from a Win98 from LAN running a ZeosLib powered delphi application. I repeat I am no expert in MySQL.