The ease or difficulty in doing this is greatly dependent on the
format of the SQL in the flat file.
If it is arranged so that the only text in the file is DDL, and that
each statement is delimited with a '/' or ';', it's just a matter
of making a connection to the database, opening the file, rea
I have an Access database with funny field names like: REPORT #
I forgot the advice to use square brackets [] and used double quotes
instead : "REPORT #".
Now, that works fine. But is that going to cause me trouble
somewhere/sometime? Should I replace that with the square brackets, or
let it r
> On Tue, Mar 04, 2003 at 02:31:37PM -0800, Dean Arnold wrote:
> > While trying to test some multiprocessing on Win2K (ActiveState 633), I
ran
> > into
> > an issue I'm hoping you can shed some light on. If I open a $dbh before
> > forking
> > off some kids that also open some $dbh's, I get the fol
On Tue, Mar 04, 2003 at 02:31:37PM -0800, Dean Arnold wrote:
> While trying to test some multiprocessing on Win2K (ActiveState 633), I ran
> into
> an issue I'm hoping you can shed some light on. If I open a $dbh before
> forking
> off some kids that also open some $dbh's, I get the following error
On Tue, Mar 04, 2003 at 10:45:45PM -, Simon Taylor wrote:
> Will this include support for Oracle 8 objects?
Is your cheque in the mail?
;-)
Let's get the ball rolling bfore we try to steer it shall we?
Tim.
> -Original Message-
> From: Tim Bunce [mailto:[EMAIL PROTECTED]
> Sent: 0
Will this include support for Oracle 8 objects?
-Original Message-
From: Tim Bunce [mailto:[EMAIL PROTECTED]
Sent: 04 March 2003 22:25
To: Andreas Koch
Cc: [EMAIL PROTECTED]
Subject: Re: Problems installing DBD1.12 on DBI1.34 and Perl 5.8
On Tue, Mar 04, 2003 at 04:33:59PM +0100, Andrea
While trying to test some multiprocessing on Win2K (ActiveState 633), I ran
into
an issue I'm hoping you can shed some light on. If I open a $dbh before
forking
off some kids that also open some $dbh's, I get the following error in the
kids:
"DBD::Teradata::dr connect failed: handle 1 is owned by
On Tue, Mar 04, 2003 at 09:32:27AM -0800, Jeff Zucker wrote:
> Tim Bunce wrote:
>
> >On Mon, Mar 03, 2003 at 10:07:29AM -0800, Jeff Zucker wrote:
> >
> >>use SQL::Statement;
> >> print $SQL::Statement::VERSION;
> >>
> >
> >Or run this command
> >
> > perl -MSQL::Statement=
> >
>
> Hmm, w
On Tue, Mar 04, 2003 at 04:33:59PM +0100, Andreas Koch wrote:
> After successful installation of Perl and DBI, i get some errors installing
> the DBD 1.12. What can i do to fix it?
There are no errors, only warnings. The short story is that DBD::Oracle
has not yet been updated for recent perl vers
IBM Informix Database Driver for Perl Version 2003.03.0400 (2003-03-04) has been
uploaded to CPAN.
IBM Informix Database Driver for Perl (also known as DBD::Informix) is
the driver code that enables Perl 5.005 or later to access Informix
databases via the DBI module (but if you are not already u
Jeff Zucker wrote:
> Tim Bunce wrote:
>
>>On Mon, Mar 03, 2003 at 10:07:29AM -0800, Jeff Zucker wrote:
>>
>>>use SQL::Statement;
>>> print $SQL::Statement::VERSION;
>>>
>>
>>Or run this command
>>
>>perl -MSQL::Statement=
>>
>
> Hmm, what am I missing? That doesn't work for me with SQL::S
Tim Bunce wrote:
On Mon, Mar 03, 2003 at 10:07:29AM -0800, Jeff Zucker wrote:
use SQL::Statement;
print $SQL::Statement::VERSION;
Or run this command
perl -MSQL::Statement=
Hmm, what am I missing? That doesn't work for me with SQL::Statement.
It also doesn't work for me with DBD::ODBC,
Peter Schuberth wrote:
Hello Jeff,
I believe the problem of the low speed is due using SQL-Statement 1.005. I
think I should change to a XS Version like 0.1021.
Maybe it will help, though as others have pointed out MySQL and
PostgreSQL and SQLite may be better for you All of them work fine on
I had this problem until I pointed ORACLE_HOME to a directory that contained all the
Pro*C executables. I think it's looking for your OCI installation...
> -Original Message-
> From: Tim Bunce [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, March 04, 2003 5:14 AM
> To: [EMAIL PROTECTED]
> Cc:
Thanks for the feedback.
I'm confused regarding multiple connections to the
same database/user. What's the point in ever having multiple
connections to the same database/user, other than say, one
having PrinError=>0 and the other having PrintError=>1.
Or is having different attributes itself the
Title: Problems installing DBD1.12 on DBI1.34 and Perl 5.8
After successful installation of Perl and DBI, i get some errors installing
the DBD 1.12. What can i do to fix it?
The make process give me following output
--->>>
Oracle.xs : In function 'XS_DBD
hi,
How can i connect to an Oracle database with an oracle user where the
authentification were set to externaly.
is it possible ?
thanks
Christophe
On Mon, Mar 03, 2003 at 08:20:34PM -0500, Bob X wrote:
> "Tim Bunce" <[EMAIL PROTECTED]> wrote in message
> news:[EMAIL PROTECTED]
> > On Mon, Mar 03, 2003 at 04:25:13PM -0500, Bob X wrote:
>
> > Thanks. I believe the appended patch fixes it.
> >
> > Tim.
> >
> > *** lib/DBD/Proxy.pm2003/02/28
- Forwarded message from [EMAIL PROTECTED] -
Delivered-To: [EMAIL PROTECTED]
Subject: DBD::Oracle and AIX 5.1 64 bit
To: [EMAIL PROTECTED]
From: [EMAIL PROTECTED]
Date: Tue, 4 Mar 2003 11:40:32 +0100
Hallo,
do you have experience with AIX 5.1 64 bit mode and DBD::Oracle?
I have a strang
> Hi Folks,
> I am a Perl newbie so please forgive if I've done something stupid or
> omiitted something smart.
>
> I have the Activeperl 5.8 distribution which is running fine. I used
> PPM to install DBI-Oracle, which seemed to go fine.
> When I run any programs (including test.pl or ora_explai
Hello Jeff,
I believe the problem of the low speed is due using SQL-Statement 1.005. I
think I should change to a XS Version like 0.1021.
But from where can I get such a package? I have loaded it initaly from
ActivePerl. But the package they provide there for 6xx build (5.6.1) has
only the SQL-S
Just figured it out
OLD:
my $st = "select $clob_field from $table where $column in
($search)";
my $sth = $dbh->prepare($st);
$sth->execute;
my @rows = $sth->fetch;
NEW:
my $st = "select $clob_field from $table where $column in
($search)";
"Tim Bunce" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> On Mon, Mar 03, 2003 at 04:25:13PM -0500, Bob X wrote:
> Thanks. I believe the appended patch fixes it.
>
> Tim.
>
> *** lib/DBD/Proxy.pm2003/02/28 17:50:06 11.12
> --- lib/DBD/Proxy.pm2003/03/03 22:37:14
> *
> You can cure this error by setting LongReadLen to a bigger number
I know. I'm trying to find a way to do it programmatically.
>> When I $sth->fetch* a CLOB the following is sent to STDERR
>>
>> DBD::Oracle::st fetch failed: ERROR fetching field 2 of 1. LOB value
>> truncated from 10347
Hello Jeff,
below the sample query, the one which is commented is working under Linux
(this is the one I need) , but gives an empty result under Windows, then I
removed the field artnummer wich is also a string field, then I got some
results but the result looks like a simple OR between (artbez_' .
I'd say the current behaviour is correct. I have situations where I
have multiple DBI connects to the same DB with different attributes. I
don't want these munged into the same $dbh if I choose to use
connect_cached.
I also don't want the state of my handles changed if another piece of
code us
It looks like a false alarm. I can't reproduce it outside Class::DBI
(using mysql client, or DBD::mysql, using v3 or v4) so I need to
dig deeper into Class::DBI to see what's happening there.
Tim.
On Mon, Mar 03, 2003 at 06:39:01PM -0600, Paul DuBois wrote:
> At 0:18 + 3/4/03, Tim Bunce wrote
On Mon, Mar 03, 2003 at 09:43:45PM -0800, Jonathan Leffler wrote:
> Tim Bunce wrote:
> >>package name at C:/Perl/site/lib/DBD/Proxy.pm line 272.
> >>BEGIN not safe after errors--compilation aborted at
> >>C:/Perl/site/lib/DBD/Proxy.pm line 414.
> >>Compilation failed in require at (eval 3) line 3.
On Mon, 3 Mar 2003 17:56:33 +0100, Peter Schuberth wrote:
>Hello,
Hi Peter
>I would also like to stick to MySQL, but I have to change it, since
>there is
>no DB-Server available.
What do you mean? I use MySQL under Windows.
--
Cheers
Ron Savage, [EMAIL PROTECTED] on 04/03/2003
http://savage.net.
29 matches
Mail list logo