Re: Trapping Errors

2003-06-03 Thread Hardy Merrill
Brian McCauley [EMAIL PROTECTED] wrote: [EMAIL PROTECTED] (Dataondata) writes: I am using the following code and would like someway to display errors and/or redirect on event of crash inside the IF block at about where the #ERROR COULD BE HERE point: Your question has nothing to do

(Fwd) metadata

2003-06-03 Thread Tim Bunce
- Forwarded message from [EMAIL PROTECTED] - Delivered-To: [EMAIL PROTECTED] Date: Mon, 2 Jun 2003 20:12:49 +0800 (CST) From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: metadata X-SHIP: 219.150.96.110 X-SHMOBILE: 0 X-SHBIND: 0 hi: can dbd::oracle add support to meta data of

Rebinding variable error

2003-06-03 Thread Bernard Golden
Help! I am getting the following error code: C:\Temp\Kaiser\kaisersubscribersoapclient.pl: Failed: Can't rebind placeholder 8 at c:/Perl/lib/Subscriber.pm line 795, DATA line 164. with the following code: my $substh = $dbh - prepare( INSERT INTO ktc_subscriptions (

RE: Connection Problem

2003-06-03 Thread David Sacks
Naveed, The short - there is not a DBD:Oracle client that currently works with the 9i Oracle drivers, however you the current DBD:Oracle still works with the Oracle 8i client drivers with are fully compatible with talking with a 9i server. Long explanation is below: I recently upgraded to

DBI-data_sources(mysql); DBI_USER?

2003-06-03 Thread Scot Needy
Hi; Trying to write a script to backup all my MySQL databases. The number and name of the databases may change from day to day so I am trying to use data_sources to fetch a list of databases but I can't seem to get this to work. The database is bound to an IP so localhost doesn't work. How do

Re: Trapping Errors

2003-06-03 Thread Brian McCauley
[EMAIL PROTECTED] (Hardy Merrill) writes: I'll just clarify that you need to test/trap errors on *all* your DBI statements, including the connect and prepare. Actually, for a siginificant subset of simple applications, it is sufficient to specify RaiseError=1, AutoCommit=0 and be done with it.

RE: Rebinding variable error

2003-06-03 Thread Bernard Golden
I was contacted by Mark C. in the mail below and followed his suggestion and the problem cleared up. I can only assume that something in the underlying database changed in the past few days and something that worked before stopped working (a first in software, eh?). Anyway, I started to see a

RE: Rebinding variable error

2003-06-03 Thread Jeff Urlwin
I was contacted by Mark C. in the mail below and followed his suggestion and the problem cleared up. I can only assume that something in the underlying database changed in the past few days and something that worked before stopped working (a first in software, eh?). What that does

RE: Connection Problem

2003-06-03 Thread Rick Ressegger
Hi all, I've spent the last few weeks working on a port of a perl application as if my job depends on it (it does). Problem was/is - when I stared I knew nothing about perl or the application, and had some small experience doing makes and builds. I'm a little better now. But then I read this one.

Re: Connection Problem

2003-06-03 Thread Andy Hassall
David Sacks wrote: The short - there is not a DBD:Oracle client that currently works with the 9i Oracle drivers, however you the current DBD:Oracle still works with the Oracle 8i client drivers with are fully compatible with talking with a 9i server. That's not really true. DBD-Oracle does

DBD::Informix Issues

2003-06-03 Thread George Karabotsos
Hey guys, I have the following issues with connecting to my DB using Perl. But first some background: I create my DB like: CREATE DATABASE george_db_upp IN maindbs WITH BUFFERED LOG; I use DBD::Informix version 1.00.PC2 Running IDS 9.3: Here's my script:

Re: DBD::Informix Issues

2003-06-03 Thread Jonathan Leffler
George Karabotsos wrote: Hey guys, I have the following issues with connecting to my DB using Perl. But first some background: I create my DB like: CREATE DATABASE george_db_upp IN maindbs WITH BUFFERED LOG; I use DBD::Informix version 1.00.PC2 Running IDS 9.3: Thanks for the nice simple

RE: DBD::Informix Issues

2003-06-03 Thread George Karabotsos
I think I 'll follow your advice and upgrade, I 'll let you know how it goes. thanks again for the help, George -Original Message- From: Jonathan Leffler [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 03, 2003 1:32 AM To: George Karabotsos Cc: '[EMAIL PROTECTED]' Subject: Re:

Re: Connection Problem

2003-06-03 Thread Kristian Nielsen
Andy Hassall [EMAIL PROTECTED] writes: David Sacks wrote: The short - there is not a DBD:Oracle client that currently works with the 9i Oracle drivers, however you the current DBD:Oracle still That's not really true. DBD-Oracle does work with 9i client libraries, I've been running it

Problem with deadlocks DBD::Sybase (Intern)

2003-06-03 Thread alexander.ballamy
Hi! I am running a lot of queries through the DBD::Sybase, but lately I've got some problems with deadlocks in the Sybase database the DBI connects to. The error message: DBD::Sybase::st execute failed: Server message number=1205 severity=13 state=1 line=1 text=Your server command (family id

DBD and Ingres II make test failure

2003-06-03 Thread gavin . hale
I did post previously, but assume no-one out there is sad enough to still be using ingres with something as dynamic as perl. My make test fails, either with an undefined symbol mutex_init if -lthread is specified, or undefined symbol finite when -Kthread is used. As below

Re: Problem with deadlocks DBD::Sybase (Intern)

2003-06-03 Thread Michael Peppler
On Tue, 2003-06-03 at 00:51, [EMAIL PROTECTED] wrote: Hi! I am running a lot of queries through the DBD::Sybase, but lately I've got some problems with deadlocks in the Sybase database the DBI connects to. The error message: DBD::Sybase::st execute failed: Server message number=1205

RE: DBD and Ingres II make test failure

2003-06-03 Thread Mark Buckle
I've had the occasional problem building DBD-Ingres myself on some of our servers - Bull Escala running AIX 4.3. The problem showed itself with a similar to that below :- install_driver(Ingres) failed: Can't load 'blib/arch/auto/DBD/Ingres/Ingres.so' for module DBD::Ingres: dynamic linker:

ANNOUNCE: CGI::Application 3.1

2003-06-03 Thread Jesse Erlbaum
Version 3.1 of CGI::Application is now available via CPAN! Download site for CGI::Application: http://search.cpan.org/dist/CGI-Application/ CHANGES SINCE VERSION 3.0: - Changed dump_html default run-mode to be referenced by name instead of sub-ref. This allows dump_html() to be

RE: Mac OS X dbi, DBD::ODBC question

2003-06-03 Thread Jeff Urlwin
Hello, I feel as though I am getting very close to finally having this things setup but I do not know what the following means and how to fix it...any help would be greatly appreciated! Burke Squires [BS-PBG4:~] squiresb% listdsns.pl Driver: ExampleP Data Source is