how to connect remote sqlite in windows

[Vedat Özcan]

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

--
Posted via http://www.ruby-forum.com/.

[Colin Law]

On 14 March 2014 08:45, Vedat Özcan <li...@ruby-forum.com> wrote:
> 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

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

[Vedat Özcan]

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 ?