SQLite works on a file as a database, so you must have access to the database file. If you can reach that file, for example via an UNC path, then you can use it from within DBD::SQLite.
Comment on Re: Querying an existing sqlite DB on a remote machine