http://www.perlmonks.org?node_id=820103

Anonymous Monk has asked for the wisdom of the Perl Monks concerning the following question:

Hi all...
Using DBD::SQLite, can i query an existing sqlite DB on a remote machine.
The DB handler is:
DBI->connect("dbi:SQLite:dbname=$dbfile","","").
It doesnt even ask for any remote info.My code is:
$db_handler = "dbi:SQLite:$database:$host";#used host name to connect +to the remote machine but not sure if its correct. $DBIconnect = DBI->connect($db_handler, $user, $pw) or die die "Unable + to connect: $DBI::errstr\n"; $a_query = "SELECT * FROM $tablename where user_name=\"psibond\""; $res = $DBIconnect->prepare($a_query);

this just creates the $database on the local machine and gives me the following error.
DBD::SQLite::db prepare failed: no such table:
So i came to know that this dint connect to the remote machine rather just created a DB on the local machine.
Can u tell me where i went wrong or guide me how to query a remote DB with data