Hailin, thanks for your reply. when I run : $c->stash(ages => [$c->model('DB::Age')->all]); it get error, I am run on Windows 7, with [Microsoft][ODBC SQL Server Driver][SQL Server] I tried to switch to Sqlite to do a test, it runs good. I also try to connect to another table in the same sql server database, the error came again. the strange thing is after a reload of the same page, the problem gone. but restart the Catalyst server, it show up for the first connection Hugh Wang Hailin Hu 写道: It seems the error only occurs on connection. Do you have any sql statement in on_connect_do, which SQL server can't execute correctly?On Thu, Jun 6, 2013 at 2:38 PM, Hugh Wang <yow...@verizon.net> wrote:I am trying to use Catalyst, with DBIx::Class to connect to a MS Sqlserver database. after I start the Catalyst server, perl script/libApp_server.pl -r I connect to a page to open a table and display it, but the first time when I open the page, such as: http://localhost:3000/admin/ticket it shows error: [error] DBIx::Class::Storage::DBI::_do_query(): DBI Exception: DBD::ODBC::db do failed: [Microsoft][ODBC SQL Server Driver][SQL Server]'=' Grammer Error nearby (SQL -42000)(DBD: Execute immediate failed err=-1) at K:\LibApp\lib/LibApp/Controller /admin.pm line 47 but after I refresh to reload the page, it works good . if I restart the server, the error will show up again for the first time I open the same web page. the refresh of the same page, will work good. what's wrong with it? any one has experience thanks Hugh Wang _______________________________________________ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/ Searchable Archive: http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk_______________________________________________ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/ Searchable Archive: http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk |
_______________________________________________ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/ Searchable Archive: http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk