share a database bettwen 2 computers

[startup]

i have 2 computers in the same place

i have no internet connection in that place
i have linked the two computers in a lan

so
i can deal with sqlite and ams or what ever it will need

now
is it possible to share the database ??
what i need to deal with the data base in the client side ??

i have no idea where to start
please guide me to any example like
or give me a tip

[RizlaUK]

you can not have consecutive connections to a sqlite database, you will corrupt your data, sqlite is for a single local connection only, if you want to share a database then use mysql, for a simple database you could also use xml but for this case sqlite is not an option

FYI: it can/has been done but by very skilled programers that know how to avoid data corruptions!

[reteset]

Take a look at this page

[startup]

you can not have consecutive connections to a sqlite database, you will corrupt your data, sqlite is for a single local connection only, if you want to share a database then use mysql, for a simple database you could also use xml but for this case sqlite is not an option

FYI: it can/has been done but by very skilled programers that know how to avoid data corruptions!

firest
thanks RizlaUK

ok
let us depend on mysql no proplem

how ??
i mean what is the scenario ??
i mean
tel me the major jumps
then i will step the reset


retest
thanks alot but
i need an example

thanks for your interest

[Nickj]

The idea is that you outline what you are trying to do.
The PCs are on a LAN (server based or through a dumb router).... does the database have to exist concurrently both PCs , can the database exist on a single PC with application clients accessing it as required... can the database exist elewhere. Are the transactions required to be in realtime, how robust does it need to be, how much data is there likely to be.
If you have to run a web server what will it be as then different databases are available, Exist, MYSQL, MSSQL etc
The answer to each of these options takes you down different paths with many different solutions.
The answer depends on the question.
First you need to ask a question that can be more easily answered.

[claus707]

I don't know exactly your problem, but if you are trying to access a local network mysql database it can be done by changing the user host privileges in my case I selected % for all clients on the local network.
The connection string will be:
host: 192.168.1.10
username: root
Password: YOUR_PASS

[startup]

hay claus !!
its a very detailed answer
and easy to understand

but forgive me
what is the program that prigs this ??

[Ham]

That's phpMyAdmin to administrate your databases.
More info: www.phpmyadmin.net

[claus707]

I suggest you to use xampp, it includes php & mysql.
After installing it you have also phpmyadmin installed!
You can access it http://localhost/phpmyadmin

[Nickj]

Of course if you have these two PCs on a LAN you can use a server stack to run a database on and use MySQL or quite a few other databases.
If you are never going to be moving off this LAN environment then could also use a standalone db like the free ms sql server express (or whatever the current version is called).
If you use something like this http://www.mindquake.com.br/actions/odbc to connect then you can easily set up connections to a wide range of dbs really simply.
If you want to risk it the jet engine is available on any windows PC through to win7. The current version has much better locking which allows much safer concurrent user.