Re: 'unsupported file format' in DBD::SQLite

I guess you are trying to access a SQLite Version 2 database file with the SQLite Version 3 module. Please try (and install DBD::SQLite2)

my $dbh=DBI->connect("dbi:SQLite2:dbname=climhy","","") or die 'arrgh'
+;
[download]

and see how it goes.

holli, /regexed monk/

Comment on Re: 'unsupported file format' in DBD::SQLite Download Code

Replies are listed 'Best First'.
Re^2: 'unsupported file format' in DBD::SQLite by Anonymous Monk on Feb 07, 2006 at 20:56 UTC
Thanks every one. I think I get it. Who would have guessed I'm on the cutting edge. I just set up SQLite today. I'm running SQLite version 3.2.7. Does this mean I have to wait for DBD::SQLite3? I guess I'll try and find an old verion of SQLite.	[reply]
Re^3: 'unsupported file format' in DBD::SQLite by bart (Canon) on Feb 07, 2006 at 22:05 UTC
The newer versions of the module use SQLite 3. According to the change file, and if I read that correctly, any module version >= 1.00 should do. I think DBD::SQlite 1.10 or 1.11 would be best, as these module versions use the same db engine version as yours.	[reply]