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'
username: ''
password: ''
port: 2000
connection_check_threshold: 3
#dbi_params:
# RaiseError: 1
# AutoCommit: 1
#on_connect_do: ["SET NAMES 'utf8'", "SET
CHARACTER SET 'utf8'" ]
log_queries: 0
[5268] error @0.140813> [hit #1]Database connection failed - Cannot log
in to DBI::ProxyServer: Refused by server: User is not permitted to
connect. at /usr/local/share/perl5/RPC/PlClient.pm line 82. in
/usr/local/share/perl5/Dancer/Plugin/Database.pm l. 16
I try lot of settings as
driver: "Proxy:hostname=192.168.0.19;port=2000;dsn=DBI:ODBC:accesssav"
driver: "Proxy:hostname=192.168.0.19;port=2000;dsn=DBI:ODBC:accesssav,
'', '' "
nothing works , someone has already test Dancer with DBD::Proxy ?
_______________________________________________
dancer-users mailing list
[email protected]
http://lists.preshweb.co.uk/mailman/listinfo/dancer-users
