Re: Querying an existing sqlite DB on a remote machine

Replies are listed 'Best First'.
Re^2: Querying an existing sqlite DB on a remote machine by BrowserUk (Patriarch) on Jan 28, 2010 at 07:02 UTC
. It might work over a networked drive, but the thought makes me cringe. If the DB was fairly small, it would be catched locally and might work surprisingly well. But yeah! you wouldn't want to rely upon it. Examine what is said, not who speaks -- Silence betokens consent -- Love the truth but pardon error. "Science is about questioning the status quo. Questioning authority". In the absence of evidence, opinion is indistinguishable from prejudice. "I'd rather go naked than blow up my ass"	[reply]
Re^3: Querying an existing sqlite DB on a remote machine by psibond (Initiate) on Jan 28, 2010 at 08:48 UTC
Well..Now i copied the DB to my local machine.modified the code as follows `$db_handler = DBI->connect("dbi:SQLite:dbname=$dbfile","","") or die " +Unable to connect: $DBI::errstr\n"; $a_query = "SELECT * FROM $tablename where user_name=\"Psibond\""; $res = $db_handler->prepare($a_query); $res->execute(); $row = $res->fetch;` [download] I am geeting the followin erros now: DBD::SQLite::db prepare failed: no such module: calmfts2 at DB-Querying.pl line 22. Can't call method "execute" on an undefined value at DB-Querying.pl line 24. Is there anything wrong.I guess the sqlite module supports prepare n execute methods. I also will be glad if u can tell me how to fetch out data Thanks, Psibond	[reply] [d/l]
Re^4: Querying an existing sqlite DB on a remote machine by Corion (Patriarch) on Jan 28, 2010 at 08:54 UTC
This likely means that on the other machine, SQLite is compiled with an SQLite-specific plugin, `calmfts2`, which sounds to me like it is a Full Text Search implementation. And this plugin does not seem to exist on your local machine. Ask your system administrator about the differences between the two machines and also how to bring the two machines closer in sync.	[reply] [d/l]