Kok Hoor, Sorry for the very long delay in responding. I've looked into your problem and found a bug in SQL::Translator::Parser::DBI at line 173. If you change it from this:
$tr->load( $pkg ); To this: SQL::Translator::load( $pkg ); I believe it will work for you. HTH, ky On May 24, 2009, at 10:30 AM, Chew Kok Hoor wrote: > Hi all, > > I am a newbie who is not only new to SQL Fairy, but also to Perl. > After some initial difficulties, I am able to install ActivePerl in my > PC. My OS is Vista x64, and the Perl version I used is: > ActivePerl-5.10.0.1004-MSWin32-x64-287188.msi > I downloaded SQL Fairy 0.09004 and installed it by extracting the > folder and running Build.PL, build, build test and build install. > > I then proceed to install dmake and dependencies and optional > libraries required, all except for GraphViz. > > When I run sqlt using the following command line: > > sqlt -f DBI --dsn "dbi:ODBC:driver=SQL > Server;Server=.\sql2008;database=fam_kf;UID=X;PWD=X" -t YAML --db-user > X --db-password X -d -v > > I receive the following error message: > > [SQL::Translator] Got parser: code ref > [SQL::Translator] Got producer: code ref > [SQL::Translator] Got parser: SQL::Translator::Parser::DBI::parse > [SQL::Translator] Got producer: > SQL::Translator::Producer::YAML::produce > Error: translate: Error with parser 'SQL::Translator::Parser::DBI': > Undefined subroutine &SQL::Translator::Parser::DBI::SQLServer::parse > called at E:/Perl64/site/lib/SQL/Translator/Parser/DBI.pm line 177. > > Does that mean SQL Server parser is not defined? > > I have tried to run using other -f parameters such as -f > DBI-SQLServer and -f SQLServer, but that results in sqlt hang for very > long time instead. > > Will be great if someone can provide me pointers and advice on how > to proceed. > > Thanks in advance. > > Regards, > Kok Hoor ------------------------------------------------------------------------------ Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july -- sqlfairy-developers mailing list sqlfairy-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlfairy-developers
