how to connect remote sqlite in windows

rubyonrails-talk
1

Hello,

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 :10.0.0.30

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

2

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.

Colin

3

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

My old database.yml database: 10.0.0.30:\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 ?