sorry my mistake

2004-02-12 Thread Raven
Sorry, more my mess, wrong installation of package. Sorry once again!

dbi

2004-02-12 Thread Raven
Good day! I have always this mistake! I copied few times archive from site and it didn't help:(. Could you tell me how to solve this problem Can't load 'C:/WINNT/system32/inetsrv/perl/lib/auto/DBI/DBI.dll' for module DBI: load_file:The specified module could not be found at

Re: getting rid of the Issuing rollback() warning

2004-02-12 Thread Tim Bunce
Let's not get carried away with this thread. When a DBI database handle is destroyed, either by the ref count reaching 0 or by the 'global destruction' that happens when the perl interpreter exits, the DESTROY method is called. The DESTROY method naturally disconnects the database connection.

Performance related question

2004-02-12 Thread Lodewijks, Jeroen
Hi all, I am busy optimising my code and wonder what DBI does internally. At the moment I have something like this FUNCTION my $lcsr = $db-prepare(EOS) || ataerr::dbprepare($db); BEGIN STORED_PROC.GET_SERVICE_BY_ID(:service_id, :last_modified, :base_prod_id, :person_id,

Re: Performance related question

2004-02-12 Thread Michael A Chase
On 02/12/2004 03:27 AM, Lodewijks, Jeroen wrote: So the code would be something like INIT_FUNCTION my $lcsr = $db-prepare(EOS) || ataerr::dbprepare($db); BEGIN STORED_PROC.GET_SERVICE_BY_ID(:service_id, :last_modified, :base_prod_id, :person_id, :operator_id); END; EOS END

Re: getting rid of the Issuing rollback() warning

2004-02-12 Thread Bart Lateur
On Thu, 12 Feb 2004 10:55:56 +, Tim Bunce wrote: All I'm proposing to change is to add a way for drivers to indicate if they are in a transaction or not, and then to use that to disable the warning. That reminds me... I haven't used it in years, but I recall that last time I used DBD::ODBC

Error in make test for Oracle

2004-02-12 Thread Christopher Singer
I am using the latest DBD::Oracle 1.15 and the latest patch of Oracle software (9.2.0.4) on AIX 5.1. My perl is threaded and build with xlc_r . I keep getting the following error no matter how I make the module # make test PERL_DL_NONLAZY=1 /apps/globaldba/bin/perl -Iblib/arch

RE: Performance related question

2004-02-12 Thread Avis, Ed
Jeroen Lodewijks wrote: Would it be quicker to prepare the cursor only once and then call only the binds and execute? Yes. -- Ed Avis [EMAIL PROTECTED]

RE: Performance related question

2004-02-12 Thread Lodewijks, Jeroen
If there is a speed improvement, would it be significant? It is virtually certain you will see some improvement from preparing only once, probably significant. The only way to know how much is to time it a few hundred times each way. The reason I ask this is: INIT_FUNCTION my $lcsr =

RE: Performance related question

2004-02-12 Thread Henrik Tougaard
Lodewijks, Jeroen skrev: ...[snip]... If so, I don't expect much performance improvement as I am only optimising a few lines of Perl. In my experience you always get the greatest performance improvements by changing your SQL instead of changing you Perl - often several orders of magnitude

Re: Error in make test for Oracle

2004-02-12 Thread Reinhard Pagitsch
Hello Christopher, The most mistake is that the user logged in has no ORACLE_* and/or LIBPATH environment variables loaded to use the Oracle environment. Try to find it out with env|grep ORACLE and env|grep LIBPATH regards, Reinhard Christopher Singer wrote: I am using the latest

Install MySQL DBI/DBD on Solaris system - perl 5.6.2

2004-02-12 Thread Wilson, Allen
Title: Message Does any have experience with installing the DBI/DBD for MySQL and fixing errors within the install? Allen This message may contain proprietary or confidential company information. Any unauthorized use or disclosure is prohibited.

RE: install_driver(ODBC) failed: Can't load

2004-02-12 Thread Jeff Urlwin
Sorry for the top-posting, the original was in HTML. Note the Access is denied message. It's most likely in the dbi-faq and the DBD::ODBC documentation. Your IIS user IUSR_ doesn't have permission to something. Most likely, at this point, it's the location where you installed Perl

Re: getting rid of the Issuing rollback() warning

2004-02-12 Thread Henri Asseily
On Feb 12, 2004, at 3:42 AM, Bart Lateur wrote: On Thu, 12 Feb 2004 10:55:56 +, Tim Bunce wrote: All I'm proposing to change is to add a way for drivers to indicate if they are in a transaction or not, and then to use that to disable the warning. That reminds me... I haven't used it in

Re: getting rid of the Issuing rollback() warning

2004-02-12 Thread Greg Sabino Mullane
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 All I'm proposing to change is to add a way for drivers to indicate if they are in a transaction or not, and then to use that to disable the warning. That what I was thinking about. Since DBD::Pg already tracks whether or not it is in a