hey, actually MYSQL database is already a server database. All you have to do is to connect the ip address of the server from the other pc (client) and you must have a connection to the server database ofcourse.

hi Muster, does that mean that instead of server=localhost, I would have to have this:
server=IP_address_server, from the client PC?

thanks.

Try using an Alias to point to your SQL Server PC.

The application connection string then contains the alias name.

server=DATABASE_ALIAS

where DATABASE_ALIAS is the database alias you name you define in the config tool.

The benefit of this is that you can change your server location by simply adjusting the alias definition on the client pc rather than changing the app itself.

TCP-IP alias's can be set up using Start->Run->Cliconfg.exe

I am using MySQL database. My understanding is that Clionfg.exe is SQL Server Client Network Utility application. I doubt it will work with MySQL database.

In a C# compiled application, which read values from the MySQL server database, is it possible to read in those updated values from the database? What I mean is that if the values change on the server database, I would want those values to be updated on the client, without re-compiling the application again. What is the better way to achieve this? I would not want to use a Timer tick to do its update.

thanks.