Re: Oracle Troubleshooter HOWTO on my homepage

2006-09-29 Thread Jared Still
Re your troubleshooting document: Setting ORACLE_HOME on windows is not supported. In fact, the oracle installer will remove it if it is found as an environement variable. I have set it in my user environment, and used scripts to manage it at a user session level, but do not do so on a global l

Re: Compiling DBD::Oracle 1.17 with LD_RUN_PATH

2006-09-29 Thread John Scoles
Oracle changed the internal location/mapping/bundleing of some thier binaly files. Specifally the libclntsh.so file is now bundled in the libclntsh.so.10.1 file (depending on which client) Pehaps we can use LD_RUN_PATH instead in the next version of DBD::Oracle I will look into this. cheers

Re: defining a DSN for Access on Linux

2006-09-29 Thread Jeffrey Seger
All that you need to know to set this up can be found in the perldocs for DBD::Proxy and DBD::ProxyServer. Correction: DBI::ProxyServer -- -- The darkest places in hell are reserved for

Re: defining a DSN for Access on Linux

2006-09-29 Thread Jeffrey Seger
On 9/29/06, Justin Findlay <[EMAIL PROTECTED]> wrote: Is it possible to connect to an MS access database on windows from Linux To the best of my knowledge, MS Access provides no listener capable of accepting connections without an ODBC DSN being present. However, you can set up a DBI proxy on

Re: Bug found when using a stored procedure with DB2 and DBD::ODBC

2006-09-29 Thread Stephen More
On 9/29/06, Martin J. Evans <[EMAIL PROTECTED]> wrote: Do you know where I can get the DB2 ODBC driver for Linux. I have not got a rpm based system but I could probably unpack the rpm and manually install it. The rpm can be downloaded from: http://www.ibm.com/eserver/iseries/access/linux/ If yo

defining a DSN for Access on Linux

2006-09-29 Thread Justin Findlay
Is it possible to connect to an MS access database on windows from a linux machine using DBD::ODBC without needing unixODBC? Would I need to first set up a system DSN on the windows machine or according to the DBD::ODBC documentation can I connect without a 'full' DSN, whatever that is? Something

Compiling DBD::Oracle 1.17 with LD_RUN_PATH

2006-09-29 Thread Ronald J Kimball
I had just built and installed DBD::Oracle 1.17, and I found that I couldn't use it unless I had LD_LIBRARY_PATH set in my environment. However, with an installation of DBD::Oracle 1.06, I didn't need LD_LIBRARY_PATH set. It turns out that the Makefile for 1.06 sets LD_RUN_PATH, which then gets i

Re: Bug found when using a stored procedure with DB2 and DBD::ODBC

2006-09-29 Thread Martin J. Evans
On 29-Sep-2006 Stephen More wrote: > On 9/29/06, Martin J. Evans <[EMAIL PROTECTED]> wrote: >> Stephen. I would try correcting your code which calls bind_param >> incorrectly: >> >> $sth->bind_param(1, \$a ); -> $sth->bind_param(1, $a ); >> $sth->bind_param(2, \$b ); -> $sth->bind_param(2, $b ); >

Re: Bug found when using a stored procedure with DB2 and DBD::ODBC

2006-09-29 Thread Stephen More
On 9/29/06, Martin J. Evans <[EMAIL PROTECTED]> wrote: Stephen. I would try correcting your code which calls bind_param incorrectly: $sth->bind_param(1, \$a ); -> $sth->bind_param(1, $a ); $sth->bind_param(2, \$b ); -> $sth->bind_param(2, $b ); I changed my code with: $sth->bind_param(1, $a );

Re: Statement Handle still Active

2006-09-29 Thread mark addison
On Fri, 2006-09-22 at 13:37 -0700, Philip M. Gollucci wrote: > Hi, > > I've a several 100 thousand line application. I did not introduce this > issue, but I need to fix it. > > prepare_cached(SELECT foo FROM A where X = ?) > statement handle MyDBI::st=HASH(0xd630194) was still active at X.pm >

Re: Bug found when using a stored procedure with DB2 and DBD::ODBC

2006-09-29 Thread Martin J. Evans
On 28-Sep-2006 Martin J. Evans wrote: > Stephen More wrote: >> Environment: >> RHEL 4 >> perl-5.8.5-24.RHEL4 >> perl-DBI-1.40-8 >> perl-DBD-ODBC-1.13-1 >> unixODBC-2.2.11-3.FC4.1 >> iSeriesAccess-5.4.0-1.0.i386.rpm >> >> I am trying to call a simple stored procedure on an iSeries / AS