Copy one installation to another server - not working

2006-08-29 Thread Sunil A V
Hi, I have a properly installed and working DBI/DBD::Oracle on Sun Solaris Unix box 'A'. While installing this, I had used INSTALLIBDIR option which created all my lib and DBI.pm and DBD.pm in the directory I mentioned. I have working perl programs using these DBI/DBD in the programs to connect a

RE: DBI::PurePerl and DBD::Oracle...

2006-08-29 Thread Lincoln, Adym
Check. Correct. The DBI::PurePerl does not include the DBD::Oracle. They do however work together though, as the tests conducted "after" the make install worked against my Oracle::XE database. All the failed test were from the same type of problem. The test could not load a given DBI and/or D

Re: DBI::PurePerl and DBD::Oracle...

2006-08-29 Thread Jeff Zucker
Lincoln, Adym wrote: Hi all, Just trying to understand the instructions on both these packages. The main thing to understand is that DBI::PurePerl is meant to work only with DBDs that are pure Perl (have no C/XS component) and AFAIK, that does *not* include DBD::Oracle. You might be able

Autocommit attribute not set...(DBD::mysql)

2006-08-29 Thread Ryan Perry
I sometimes get: DBD driver has not implemented the AutoCommit attribute at /usr/local/lib/perl5/site_perl/5.8.8/Apache/DBI.pm line 277. On my HTML::Mason site. I'm using Apache 2.2/mod_perl 2. I list PerlModule Apache::DBI before any other perl modules. What am I doing wrong?

RE: Oralce10g database compatible Perl version, DBD and DBI -on URGENT Basis

2006-08-29 Thread Reidy, Ron
Why don't you just try them? rr -Original Message- From: Elangovan, Sasikala [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 29, 2006 6:04 AM To: Jared Still Cc: Jared Still; dbi-users@perl.org Subject: RE: Oralce10g database compatible Perl version, DBD and DBI -on URGENT Basis Hi, Cu

RE: Oralce10g database compatible Perl version, DBD and DBI -on URGENT Basis

2006-08-29 Thread Elangovan, Sasikala
Hi, Currently I'm using perl version 5.6.1 with DBD-Oracle v1.15 and Perl DBI v1.28 in Oracle9i database. Kindly let me know if these version is compatible against Oracle 10g database. Best Regards, Sasikala, GPSy Development Team, HP-GDIC,Chennai,India, Ph:+91-44-3985 3015. -Original Me

Re: finishing sth using Childhandles

2006-08-29 Thread michael . peppler
Ah! I think I know what happens... You probably have the syb_flush_finish attribute turned on - which means that DBD::Sybase will try to fetch all the results that are pending for the active sth. I'm going to have to look at the code to see how that could be invalidated (or fixed!) Michael E

Re: DBI::PurePerl and DBD::Oracle...

2006-08-29 Thread John Scoles
When that many test fail with DBD::Oracle the most likely cause is that you do not have a correct ORACLE_USERID enviornment variable set. Chech the readmes for this. they should answer your questions Cheers John Scoles - Original Message - From: "Lincoln, Adym" <[EMAIL PROTECTED]> To:

DBI::PurePerl and DBD::Oracle...

2006-08-29 Thread Lincoln, Adym
Hi all, Just trying to understand the instructions on both these packages. Each set of instructions explains that we do the following steps in the following order: - perl Makefile.PL - make - make test - make install Thing is, everything works fine except the make test. On the initial pass, if

Re: finishing sth using Childhandles

2006-08-29 Thread Henri Asseily
On Aug 29, 2006, at 2:08 PM, [EMAIL PROTECTED] wrote: As you see this calls the DESTROY for the sth (which cancels the query), and then calls the DESTROY for the dbh (which closes the connection). There is no special code in DBD::Sybase to handle this case AFAIK. Thanks, I didn't have

Re: finishing sth using Childhandles

2006-08-29 Thread michael . peppler
Here's a little test: #!/usr/bin/perl use DBI; my $dbh = DBI->connect('dbi:Sybase:server=DBA_SQL', '...', '...'); my $sth = $dbh->prepare("select * from histo..table_size where serverName = 'BPSREC5_SQL'"); $sth->execute; DBI->trace(5); undef $dbh; This produces the following: DBI 1.51-ithr

Re: finishing sth using Childhandles

2006-08-29 Thread Henri Asseily
Thanks, Tim. One more question to the group: If I "undef $dbh" when it is active and it has active (or inactive) child handles, what happens exactly? Is an actual $dbh->disconnect() made, and are the $sth's finished at all? Is it DBD dependent? Thanks in advance, Henri. On Aug 28, 2006, at

Re: ANNOUNCE: DBI 1.52 - plus PDF of "What's New" presentation

2006-08-29 Thread Tim Bunce
On Wed, Aug 09, 2006 at 10:01:06AM -0400, Matthew Persico wrote: > >http://www.cpan.org/modules/by-authors/id/TIMB/DBI_WhatsNewTalk_200607.pdf > > Very nit picky, but is there a version of this that I can print > without killing all the black ink in my printer? I've updated it with a plain one (a