[dancer-users] DBD::Proxy with Dancer

[David Precious]

On Fri, 08 Nov 2013 23:28:03 +0100
Hugues <hugues at 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 at 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