RE: Install Issue With DBD-ODBC Module

2005-04-08 Thread Martin J. Evans
Have you got sqltypes.h in /home/harbinger/tle/6_0/odbcHPUX/include? Is this the full C compiler or the one that comes with HP-UX for rebuilding the kernel? Martin -- Martin J. Evans Easysoft Ltd, UK Development On 07-Apr-2005 Cory Cox wrote: I am trying to install the DBD-ODBC version 1.13.

Re: return parameter value if query does't match

2005-04-08 Thread Tim Bunce
On Fri, Apr 08, 2005 at 01:01:02AM +0200, xaver biton wrote: while(my @row = $sql-fetchrow_array){ $sql1-execute($row[3]); What DBD module are you using? If Oracle, are any of the fields CHAR? is MySql, the fields are char Try writing the *smallest* script that demonstrates the

Re: DBD::DBM slow key retrievals....

2005-04-08 Thread Jim Lambert
Jeff, I just realized, I forgot to include the output you requested in my last response, so here it is: $perl tdbm.pl '2', 'b', 'bar' '3', 'c', 'baz' '1', 'a', 'foo' 3 rows ok! DBD::DBM 0.02 using GDBM_File + MLDBM + Storable DBD::File 0.33 DBI::SQL::Nano 0.03 SQL::Statement

Re: DBD::DBM slow key retrievals....

2005-04-08 Thread Jeff Zucker
Jim Lambert wrote: Jeff, I just realized, I forgot to include the output you requested in my last response, so here it is: SQL::Statement 1.005 Yikes! No wonder. That version is almost three years old. It was written long before I introduced the primary key optimizations. I'm about to

installation of dbi for solaris 9 fails

2005-04-08 Thread Thilo Christochowitz
hello dbi team, I am trying to install dbi for Solaris 9, but it fails giving the error message below ? Any idea, what could be the problem. (CPAN v1.76, perl, v5.6.1, gcc version 3.4.2 ) Thanks for any information. Thilo Christochowitz - Sun Microsystems

Re: Install Issues With Perl DBD For Informix

2005-04-08 Thread Jonathan Leffler
Cory Cox wrote: Jonathan, Q1 * Version of IDS (or SE, XPS, OnLine) - though that is not going to material this time. Q1A - The database server is running on another machine on the network. OK - it doesn't matter. Q2 This is the output of 'perl Makefile.PL' for DBD::Informix Perl: perl

Re: installation of dbi for solaris 9 fails

2005-04-08 Thread Jonathan Leffler
Your Perl was built using the Sun (Forte) C compiler - the -KPIC tells us that. You're trying to pretend that GCC is the same as the Sun compiler - it isn't. You can try and work out how to wangle things so that GCC looks sufficiently like the Sun compiler for everything to compile. It will be

execute v. execute_array

2005-04-08 Thread Brandon Metcalf
Does execute_array offer any performance improvement over execute inside of loop? -- Brandon

Re: execute v. execute_array

2005-04-08 Thread Dean Arnold
Brandon Metcalf wrote: Does execute_array offer any performance improvement over execute inside of loop? Depends on the DBI driver you use. There may be some modest improvement if you use a non-array enabled driver due to reducing the method call overhead, but ideally your DBD will have

Re: execute v. execute_array

2005-04-08 Thread Brandon Metcalf
d == [EMAIL PROTECTED] writes: d Brandon Metcalf wrote: d Does execute_array offer any performance improvement over execute d inside of loop? d d Depends on the DBI driver you use. There may be some modest improvement d if you use a non-array enabled driver due to reducing the method d

Accessing MS Access

2005-04-08 Thread Moreno, Javier
Hi all, This is probably a more DB oriented question, but it came out of the DBI. I posted a question and have tried several solutions on how to open up an MS Access DB from the DBI::ODBC but so far have been unable to. What I had to end up doing was create a DTS that runs every 5 minutes

Total Environment allocation failure ... but not the usual problem

2005-04-08 Thread Owen Berry
Hi, I'm experiencing the wonderful Total Environment allocation failure message when using DBD::DB2. I've searched all over for people with this problem, but everyone else seems to be suffering when running as a CGI program. Mine is a CGI program, but I also get the error when running from the

Re: Total Environment allocation failure ... but not the usual problem

2005-04-08 Thread Owen Berry
Okay, I solved the problem. The person who owned the scripts before I did hard coded the instance name into the script, and so when it was moved to a different machine it didn't work. Doh! Silly him for doing that, and silly me for not creating a small test script. Double doh! Sorry for bothering

Re: Accessing MS Access

2005-04-08 Thread amonotod
From: Moreno, Javier [EMAIL PROTECTED] Date: 2005/04/08 Fri PM 03:44:40 CDT snip I posted a question and have tried several solutions on how to open up an MS Access DB from the DBI::ODBC but so far have been unable to. snip I was wondering if there is a better way to get information from