Re: [dancer-users] DBD::Proxy with Dancer

11 Nov 2013

      On Fri, 08 Nov 2013 23:28:03 +0100
Hugues <hugues@max4mail.com> wrote:
...
Hello
I use my  DBD::Proxy to connect my program to ODBC Access Database.
with:
my $dsn      = "DBI:Proxy:hostname=$IP;port=$PORT;dsn=DBI:ODBC:$ODBC";
my $dbh = DBI->connect($dsn, "", "") || die "Erreur de connexion à la
base"; $dbh->{AutoCommit} = 1;
         $dbh->{RaiseError} = 1;
I would like to transpose this  same connection using Dancer,  in 
config.yml, but I do not arrive to pass good settings.
login and password are empty
plugins:
     Database:
         connections:
                    accesssav:
                           driver: 
"Proxy:hostname=192.168.0.19;port=2000;dsn=DBI:ODBC:accesssav"
                           database: 'accesssav'
You have a pre-crafted DSN, so you want to just use
Dancer::Plugin::Database's "dsn" config option, like so:

  plugins:
      Database:
          connections:
              accessav:
                  dsn: "DBI:Proxy:hostname=...."

That should get it working for you.

-- 
David Precious ("bigpresh") <davidp@preshweb.co.uk>
http://www.preshweb.co.uk/     www.preshweb.co.uk/twitter
www.preshweb.co.uk/linkedin    www.preshweb.co.uk/facebook
www.preshweb.co.uk/cpan        www.preshweb.co.uk/github