DamnDirtyApe has asked for the wisdom of the Perl Monks concerning the following question:

I'm getting an error when I try to use DBD::RAM, and I can't figure out quite what's wrong. I have the following modules installed:

I'm trying to do this from Windows and ppm refuses to install DBD::File for me, but I do have File.pm in my c:\Perl\site\lib\DBD directory.

When I discovered that my script didn't work, I went back to the opening example from the DBD::RAM docs, and I got the same error. Here is the script:

use DBI; my $dbh = DBI->connect('DBI:RAM:','usr','pwd',{RaiseError=>1}); $dbh->func({ table_name => 'my_phrases', col_names => 'id,phrase', data_type => 'PIPE', data_source => [<DATA>], }, 'import' ); print $dbh->selectcol_arrayref(qq[ SELECT phrase FROM my_phrases WHERE id = 1 ])->[0]; __END__ 1 | Hello, New World 2 | Some other Phrase

And here is the error I receive:

Can't locate DBI object method "csv_cache_sql_parser_object" via packa +ge "DBD::RAM::db" at c:/Perl/site/lib/DBD/File.pm line 170, <DATA> li +ne 2.

Can anyone enlighten me as to why this is happening, and how I can fix it?

Much thanks,


_______________
D a m n D i r t y A p e
Home Node | Email

Replies are listed 'Best First'.
Re: Problem with DBD::RAM
by Kanji (Parson) on Jul 12, 2002 at 20:03 UTC

    It could be incompatable versions, but before you spend any significant time trying to debug the problem, I'd suggest taking a look at DBD::AnyData (alt.) -- DBD::RAM's successor.

        --k.


      Hmmm.... DBD::AnyData sounds great from the docs, but when I try to install AnyData (a prerequisite), I lock up here. (Now on RH7.3)

      /usr/bin/make -- OK Running make test PERL_DL_NONLAZY=1 /usr/bin/perl -Iblib/arch -Iblib/lib -I/usr/lib/perl +5/5.6.1/i386-linux -I/usr/lib/perl5/5.6.1 test.pl AnyData XML ...

      My machine locked up here for hours. Has anyone else had problems either using DBD::RAM or installing AnyData?


      _______________
      D a m n D i r t y A p e
      Home Node | Email

        You need XML::Parser and XML::Twig installed to use (or just test!) the XML mode.

        I seem to remember problems with the installation when the module first came out. You should email the author or use rt.cpan.org to report the problem.

        --
        The Error Message is GOD - MJD