I decided to play around with DBIx::Class, and Im missing something. I'm having trouble connecting to a sqlite db. I can connect to the db in question using DBI, as follows:

my $dbpath = 'C:/my/path/stats.db'; my $dsn = "dbi:SQLite:$dbpath"; my $dbh = DBI->connect( $dsn, '', '', { RaiseError => 1, AutoCommit => + 1 } );

To use DBIx::Class, I created a Schema.pm file that contains:

package My::Schema; use strict; use warnings; use base qw/DBIx::Class::Schema::Loader/; __PACKAGE__->loader_options( relationships => 1 ); 1;
which I then use as follows:
package My::Pkg; use strict; use warnings; use My::Schema; my $dbpath = 'C:/my/path/stats.db'; my $dsn = "dbi:SQLite:$dbpath"; my $schema = My::Schema->connect( $dsn, '', '', { RaiseError => 1, Aut +oCommit => 1 } );

When I try to run this script (on Windows) I get a popup saying "the Perl Cmd Line Interpreter encountered a problem and needs to close". There is no other output to STDOUT.

Any ideas?


In reply to Cannot connect to a SQLite db using DBIx::Class by bobf

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post; it's "PerlMonks-approved HTML":