RE: Turning autocommit off

2001-08-05 Thread Neil Lunn
It's off by defualt. But the documentation should help more here. --Neil >-Original Message- >From: Anurag Minocha [mailto:[EMAIL PROTECTED]] >Sent: Saturday, August 04, 2001 4:33 AM >To: [EMAIL PROTECTED] >Subject: Turning autocommit off > > >Hi, >How do i turn off autocommit in dbi::Or

RE: Perl.exe generating errors when used on Win 2K

2001-08-05 Thread Neil Lunn
Yes. While the soolution below is correct it might help to tell the person who oringally posted this question why they where getting an error. The difference is in: $sth = $dbh->do("insert " $sth->bind_param(" ... and $sth = $dbh->prepare("insert $sth->bind_param(" ... Essentially th

Re: Program slow even with bind/placeholders....

2001-08-05 Thread Tim Bunce
Nesting execute fetch execute fetch execute fetch execute fetch loops to the degree you have is spectacularly inefficient. As you've disc

(Fwd) Re: ANNOUNCE: DBI_Talk5_2001.tar.gz

2001-08-05 Thread Tim Bunce
- Forwarded message from "Scott R. Godin" <[EMAIL PROTECTED]> - From: "Scott R. Godin" <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] (Tim Bunce) Subject: Re: ANNOUNCE: DBI_Talk5_2001.tar.gz References: <[EMAIL PROTECTED]> Organization: Laughing Dragon Services User-Agent: MT-NewsWatcher/3.1 (

RE: Please Help!! Problem inserting Multi-language CLOBS using UTF8

2001-08-05 Thread Sterin, Ilya
Firts you might have to use binmode STDIN and binmode STDOUT then see docs for use utf8 and use bytes. The above might help, might not depending on what is causing the problem. > -Original Message- > From: Rob Foglia [mailto:[EMAIL PROTECTED]] > Sent: Friday, August 03, 2001 8:27 PM > To:

Fumbling towards connectivity

2001-08-05 Thread Thomas Good
Hello I am a postgres user now afflicted with Oracle... I am running Oracle 8.1.6.1.0 on redhat 6.1 using DBD 1.13 and DBD-Oracle 1.07... my connect str is ("dbi:Oracle:", 'doofus', 'hopeless') but the str seems irrelevant as this is what I get back when I attempt a connection: install_driver(O

UTF8 data corrupted one insert of multi-language CLOBS in oracle 8.1.7

2001-08-05 Thread Robert Foglia
I have UTF8 text data supporting multiple languages in a text file that I need to insert into a CLOB field in an Oracle database (v8.1.7.1.0). I'm using PERL v 5.005_03. The contents get corrupted during the insert process. Both the input data and SYS.V_$NLS_PARAMETERS.NLS_CHARACTERSET (for the

Please Help!! Problem inserting Multi-language CLOBS using UTF8

2001-08-05 Thread Rob Foglia
I have UTF8 text data supporting multiple languages in a text file that I need to insert into a CLOB field in an Oracle database (v8.1.7.1.0). I'm using PERL v 5.005_03. The contents get corruted during the insert process. Basically, what goes in as: Comes out as: I've tried thi

DBI::DB2 install trouble- "SQLAllocHandle" symbol not found for DB2.so

2001-08-05 Thread Kurogane Akira
Hi, I'm having trouble building the DBD::DB2 driver (v0.75), in Turbolinux server 6.5, using DB2 V7.1 (Enterprise Edition for Linux, with Application Client stuff selected), DBI v1.19, and perl 5.00503. A quick summary of my problem is this error message during an attempt to connect a