Sorry, but how do I check the version of DBD::SQLite I have installed? Perl
is not my thing. When I look in the Perl code I can see DBIx::SimplePerl
commands. I ran the scipt below but it did not show any installed modules.
"#!/usr/bin/perl
use CPAN;
printf("%-20s %10s %10s\n", "Module", "Installed", "CPAN");
foreach $a (@ARGV) {
foreach $mod (CPAN::Shell->expand("Module", $a)){
printf("%-20s %10s %10s %s\n",
$mod->id,
$mod->inst_version eq "undef" || !defined($mod->inst_version)
? "-" : $mod->inst_version,
$mod->cpan_version eq "undef" || !defined($mod->cpan_version)
? "-" : $mod->cpan_version,
$mod->uptodate ? "" : "*"
);
}
}"
Thanks
> -----Original Message-----
> From: P Kishor [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, 5 December 2007 5:44 p.m.
> To: sqlite-users@sqlite.org; [EMAIL PROTECTED]
> Subject: Re: [sqlite] File Is Encrypted Or Is Not a Database
>
> On 12/4/07, Mark Easton <[EMAIL PROTECTED]> wrote:
> > I have also tried v 3.5.3 now and still cannot open the database. I
> > guess I need the right version of sqlite3 so that I can dump to sql
> > and then I can rebuild in a newer version. But how do I
> find our what
> > version of sqlite I need?
> >
> >
> > > -----Original Message-----
> > > From: Mark Easton [mailto:[EMAIL PROTECTED]
> > > Sent: Wednesday, 5 December 2007 3:58 p.m.
> > > To: sqlite-users@sqlite.org
> > > Subject: [sqlite] File Is Encrypted Or Is Not a Database
> > >
> > > I have a sqlite db file. I have tried to open it with sqlite v
> > > 3.4.1, 2.8.17 and 3.3.5 and each of these versions give
> me the same
> > > error "File Is Encrypted Or Is Not a Database". How can I
> determine
> > > what version of sqlite will open this db? The perl
> application can
> > > open the database using the perl module it has. But I cant get
> > > command line access to the db. Any ideas?
> > >
>
>
> If you can open the database with Perl then it is not
> encrypted. Check the version of DBD::SQLite you have
> installed. Its docs will tell what version of SQLite it has
> compiled in.
>
> Then, are you sure you are trying to open it with the right
> versioned SQLite? Try
>
> $ which sqlite3
>
> to find out if you are inadvertently picking up an old SQLite
> program installed somewhere in your path.
>
> --------------------------------------------------------------
> ---------------
> To unsubscribe, send email to [EMAIL PROTECTED]
> --------------------------------------------------------------
> ---------------
>
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
