[Catalyst] reconnecting the DB model using a different DB account

[Karl Forner]

On Wed, Mar 11, 2009 at 5:03 PM, Tomas Doran <bobtfish at bobtfish.net> wrote:

> Karl Forner wrote:
>
>> The problem is that I get error messages
>> [error] DBIx::Class::Storage::DBI::ensure_connected(): DBI Connection
>> failed: ERROR OCIEnvNlsCreate. Check ORACLE_HOME (Linux) env var  or PATH
>> (Windows) and or NLS settings, permissions, etc.
>>
>> I have tried using directly the DBI dbh but with the same results.
>>
> So you're saying if you just do this using DBI, you have the same issue?


Yes, if I write:
$c->model('DB')->storage->disconnect
then
my $newdbh =3D DBI->connect(@$current_connect_info);

I get the same error


>
>
> I don't think the Catalyst list is the place to get help on this one. You
> _may_ have more luck on the DBIC list, but if it happens in raw DBI, then
> you're better off talking to the maintainer of the DBD driver you're usin=
g,
> as the issue will be at that level.
>

ok, thanks I'll try that
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.scsys.co.uk/pipermail/catalyst/attachments/20090311/508e3=
b07/attachment.htm