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:
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
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
|
---|
Replies are listed 'Best First'. | |
---|---|
Re: Querying an existing sqlite DB on a remote machine
by ikegami (Patriarch) on Jan 28, 2010 at 06:50 UTC | |
by BrowserUk (Patriarch) on Jan 28, 2010 at 07:02 UTC | |
by psibond (Initiate) on Jan 28, 2010 at 08:48 UTC | |
by Corion (Patriarch) on Jan 28, 2010 at 08:54 UTC | |
Re: Querying an existing sqlite DB on a remote machine
by stefbv (Curate) on Jan 28, 2010 at 08:24 UTC | |
by perrin (Chancellor) on Jan 28, 2010 at 17:53 UTC | |
Re: Querying an existing sqlite DB on a remote machine
by bart (Canon) on Jan 28, 2010 at 09:47 UTC |
Back to
Seekers of Perl Wisdom