how to connect remote sqlite in windows


I want to add sqlite my rails project. But I have two computer, one of them linux and another one windows. Sqlite inside a windows. How to add path my database.yml for ex : windows machine ip :

database.yml database:\C:\ProgramFiles\Spiceworks\db\spiceworks.db // but not working

sqlite is really not designed for use with a remote database, mysql or postgresql would be better for that. In fact running the server on a different machine to the database is itself not usually a good idea. If you must use sqlite remotely you could set up a samba share on the windows machine and mount that on linux so that it looks like a local db to the rails server.


Okey, I intall rails in that windows machine (remote machine) but I cant access db file.

My old database.yml database:\C:\ProgramFiles\Spiceworks\db\spiceworks.db

New database.yml database: C:\ProgramFiles\Spiceworks\db\spiceworks.db

But get error, I thing my path wrong, but whats true path ?