Help with DBD-Oracle-1.12 'make test' problem

2003-01-13 Thread profoune.w
After we installed DBI-1.32 successfully,we encountered a 'make test' problem while installing DBD-Oracle-1.12 on our systems. The environment is solaris 7 on a E450. We were using DBD-Oracle-1.12, Perl 5.6.1. The following is a console dump of the relevant part of the session. ~

Re: Help with DBI-1.32 'make test' problem

2003-01-13 Thread Jonathan Leffler
profound.w wrote: We encountered a 'make test' problem while installing DBI-1.32 on one of our systems. The environment is solaris 7 on a E450. We were using DBI-1.32, Perl 5.6.1. The following is a console dump of the relevant part of the session. This has occurred sufficiently frequently that

Help with DBI-1.32 'make test' problem

2003-01-13 Thread profound.w
We encountered a 'make test' problem while installing DBI-1.32 on one of our systems. The environment is solaris 7 on a E450. We were using DBI-1.32, Perl 5.6.1. The following is a console dump of the relevant part of the session.

Re: Whereis DBD & DBI for Oracle?

2003-01-13 Thread Michael A Chase
On Mon, 13 Jan 2003 15:12:27 -0800 (PST) David Piazza <[EMAIL PROTECTED]> wrote: > I'm looking for the DBD and DBI::Oracle modules for > Windows. I went to activestate.com and when I click > on the Perl Modules, I get a 404: File Not Found > error. > Are they located anywhere else?? http://xmlpr

Whereis DBD & DBI for Oracle?

2003-01-13 Thread David Piazza
Hi, I'm looking for the DBD and DBI::Oracle modules for Windows. I went to activestate.com and when I click on the Perl Modules, I get a 404: File Not Found error. Are they located anywhere else?? /Dave __ Do you Yahoo!? Yahoo! Mail Plus - Powerfu

perl 5.8.0, Oracle 8.0.3, DBD-Oracle 1.12 make problems (fprintf errors)

2003-01-13 Thread David Shivak
The only fprintf warning I googled was at http:[EMAIL PROTECTED]/msg00081.html perl Makefile.PL works fine, DBD-Oracle built fine for perl 5.6.0. gcc -v yields: Reading specs from /share/usr/local/bin/../lib/gcc-lib/sparc-sun-solaris2.8/3.2/specs Configured with: ../configure --with-as=/usr/ccs/

RE: Odd Connection problem with DBD::ODBC, MS SQL 2000 and IIS on Win2k

2003-01-13 Thread Jeff Urlwin
> > Hello all, > > Sadly, I don't like how this question goes, but I'm at the > end of my rope -- please bear with me :) > > I've created a simple script, which uses a DSN-less > connection to grab some data from an MS SQL 2000 server and > display it as XML. No big deal. I've installed Perl,

Odd Connection problem with DBD::ODBC, MS SQL 2000 and IIS on Win2k

2003-01-13 Thread Brian Cassidy
Hello all, Sadly, I don't like how this question goes, but I'm at the end of my rope -- please bear with me :) I've created a simple script, which uses a DSN-less connection to grab some data from an MS SQL 2000 server and display it as XML. No big deal. I've installed Perl, DBI, DBD::ODBC and II

DBD::Proxy::db table_info failed: Server returned error: Failed to execute method CallMethod: Can't use string ("1") as an ARRAY ref while "strict refs" in use

2003-01-13 Thread Fenaughty, Kevin M
Title: DBD::Proxy::db table_info failed: Server returned error: Failed to execute method CallMethod: Can't use string ("1") as an ARRAY ref while "strict refs" in use I'm having a problem using the table_info() via ProxyServer... I'm getting the following error messages: I am using a Sun b

DBD::Oracle (perl 5.8.0, Oracle 8.0.3, DBD-Oracle 1.12, Solaris 8) make problems (fprintf)

2003-01-13 Thread a314159
The only fprintf warning I googled was at http:[EMAIL PROTECTED]/msg00081.html Any suggestions appreciated. I'm assuming since the perl Makefile.PL ran clean, I'm using kosher Oracle libraries (binaries worked with Perl 5.6.0). Thanks, Dave S. Appended output of (in order): make outp

Problem with DBD::Proxy and Apache::DBI

2003-01-13 Thread Bob Showalter
I'm using Apache::DBI under mod_perl to manage connections to a remote database using DBD::Proxy. My problem is that Apache::DBI is not properly issuing a rollback to DBD::Proxy handles in the PerlCleanupHandler. The relevant section from Apache/DBI.pm is (in sub cleanup): if ($Rollback{$Idx}

DBD::Pg and stored procedures

2003-01-13 Thread Jeff Boes
Has anyone here done any work with PostgreSQL stored procedures which themselves use DBI? Essentially, I've got a stored procedure that looks like ... CREATE FUNCTION fn_stored_proc(integer) as ' use DBI; my $dbh = DBI->connect(...); my $sth = $dbh->prepare(...); $sth->execute(...); ret

Re: Renaming tables in Access

2003-01-13 Thread Simon Oliver
Brad Smith wrote: I am assuming that I have to open the database first, then rename the table. Is that much correct? You need to create an Access Application object via OLE, open the database, do your stuff and close. Here's the basics (no error checking): use Win32::OLE; my $file='d:\tes

Re: Why can't use SQL "GROUP BY..."?

2003-01-13 Thread Jeff Boes
On Fri, 2003-01-10 at 00:33, Philip Newton wrote: > On Thu, 9 Jan 2003 22:59:03 +0800 (CST), [EMAIL PROTECTED] (Gary fung) > wrote: > > > My coding is similar as: > > > > $value2 = $dbh->prepare("SELECT page FROM $Table > > > > GROUP BY page") || die "Couldn't add record, ".$dbh->errstr(); > >

DBD-CSV error message

2003-01-13 Thread Felix Aertz
Hi, I have a problem with the perl module *DBD-CSV-0.2002* installation. I prepared my debian system with: - DBI-1.30 - SQL-Statement-1.005 - Text-CSV_XS-0.23 By the way, perl 5.6.1 Now I get this error message, but I don't understand what it really means. [Debian]:/muh/DBD-CSV-0.2002

DBI, Oracle and setting timeouts with perl 5.8.0

2003-01-13 Thread Steve Haslam
Hi, I have trouble with Oracle connections "stalling" if they are unused for a long time, particularly Apache::DBI connections. So I overrode the DBD::Oracle::db::ping subroutine to set an alarm and hence detect this case-- if the "select sysdate from dual" statement took more than a few seconds,

RE: Problem with login as sysdba in DBI/DBD::Oracle

2003-01-13 Thread Georg Botorog
Of course not. At least, they are not part of SQL. The description in my mail was a short-cut of what the script is actually doing, and the startup/shutdown part may be somewhat misleading. However, whereas it is necessary to call sqlplus to startup/shutdown a DB, it is nevertheless useful to be a