Re: [Catalyst] DB2 Connection string problem

2012-03-27 Thread Cosimo Streppone
On Tue, 27 Mar 2012 20:49:41 +0200, Gianni Ceccarelli wrote: On 2012-03-27 Kenneth S Mclane wrote: [IBM][CLI Driver] SQL1031N The database directory cannot be found on the indicated file system. SQLSTATE=58031 This is the result I get from that change. I can't really help you more than

Re: [Catalyst] DB2 Connection string problem

2012-03-27 Thread Gianni Ceccarelli
On 2012-03-27 Kenneth S Mclane wrote: > [IBM][CLI Driver] SQL1031N The database directory cannot be found on > the indicated file system. SQLSTATE=58031 > > This is the result I get from that change. I can't really help you more than this, I was just reading the documentation… I've never worke

Re: [Catalyst] DB2 Connection string problem

2012-03-27 Thread Kenneth S Mclane
[IBM][CLI Driver] SQL1031N The database directory cannot be found on the indicated file system. SQLSTATE=58031 This is the result I get from that change. Regards From: Gianni Ceccarelli To: catalyst@lists.scsys.co.uk Date: 03/27/2012 11:45 AM Subject: Re:

Re: [Catalyst] DB2 Connection string problem

2012-03-27 Thread Gianni Ceccarelli
https://metacpan.org/source/IBMTORDB2/DBD-DB2-1.84/DB2.pod#L187 you may want: dbi:DB2:DATABASE=${your_db_name};HOSTNAME=${server_name};PORT=${port} -- Dakkar - GPG public key fingerprint = A071 E618 DD2C 5901 9574 6FE2 40EA 9883 7519 3F88

[Catalyst] DB2 Connection string problem

2012-03-27 Thread Kenneth S Mclane
./script/myapp_create.pl model DB2 DBIC::Schema MyApp::Schema create=static dbi:DB2:dbname:server.com:port 'user' 'pass' I have tried various permutations of this connection string and the error I get most often is "[IBM][CLI Driver] CLI0124E Invalid argument value. SQLSTATE=HY009". this tell