The ppm in
http://pgfoundry.org/projects/dbdpgppm/
got to work fine, can connet/select to the
same WindowsXP box's binary PostgreSQL.
Regards,
Hirosi Taguti
> Hello,
>
> Any one knows the working Win32 ppm package of DBD-Pg?
>
> I'm using AP588 and Windows XP.
> DBD-Pg is not in ActiveState and
Hello,
Any one knows the working Win32 ppm package of DBD-Pg?
I'm using AP588 and Windows XP.
DBD-Pg is not in ActiveState and the Theoryx5's not working, the maintener
also says so.
I've already installed the latest PostgreSQL binary for Win32,
and I cann't "nmake" from DBD-Pg CPAN source, 'cau
Hello,
I'm trying to let DBD::Oracle connect to Oracle DB 8.0.x.
My client OS is Windows XP, ActivePerl 588.
>From lists entitiled "DBD::Oracle and Oracle 8" and other articles
I found the current DBD-Oracle.ppd in ActiveStates.com uses
Oracle10g, which cann't connct to older DBs less than R8.1.
> perl -MDBI -e 'print "$DBI::VERSION\n";'
Less typed:
perl -MDBI -le 'print DBI->VERSION'
Regards,
Hello,
Someone can point out a sample code of DBD::ODBC & SQLServer with CURSOR?
I can fetch records without cursor, but I like to update the first record
gotten with cursor.
OK without CURSOR:
my $stmt = "SELECT * FROM KT..MyTable";
my $sthSEL = $dbh->prepare($stmt);
$sthSEL->execute();
my @row
Did you install successfully already?
Exactly README file isn't there, I checked.
I think you can do by copying them with your "hand",
though I didn't test it.
By the way esoftmatic has stopped to follow the AS version?
Or DBI-1.43-5.8.3.tar is valid for 5.8.7?
Regards,
Hirosi Taguti
[EMAIL PRO
Hello,
I'm now using Perl 5.005, DBI-1.15, DBD-DB2-0.75 on AIX 4.3.
And like to upgrade them to Perl 5.8, DBI-1.48, DBD-DB2-0.78.
Installation may be ok, but when I INSERT double bytes characters,
I get the following error.
[IBM][CLI Driver] CLI0109E String data right truncation.
I'm using Japan
Thanks, maybe I understand it.
By using prepare_cached method, I can do without a
hash like %cached_statments, and I can get a benefit from
all modules I'm making.
Regards,
Hirosi Taguti
[EMAIL PROTECTED]
> -Original Message-
> From: Steven Lembark [mailto:[EMAIL PROTECTED]
> Sent: Mond
Thank you so much.
I was checking UDFs.
Now SQL::Statement has become my tool.
Thank you again.
Regards,
Hirosi Taguti
[EMAIL PROTECTED]
> >INSERT INTO MyTbl (col1,record_ts,col2)
> > VALUES (7,CURRENT TIMESTAMP,'o''brian') };
> >
> That calls for a combination of SQL::Statement and your
> >>> my @new_values = ();
> >>> my @place_holders =
> >>> map {
> >>> if (/^CURRENT TIMESTAMP$/) {
> >>> $_;
> >>> } else {
> >>> push @new_values => $_;
> >>> "?";
> >>> }
> >>> } @args
> >>> ;
> >>
> >
> >SQL::Statement can do this?
> >
> Yes. The snippet I sent before will automatically turn #
> > my @new_values = ();
> > my @place_holders =
> > map {
> > if (/^CURRENT TIMESTAMP$/) {
> > $_;
> > } else {
> > push @new_values => $_;
> > "?";
> > }
> > } @args
> > ;
...
> It's a bit of a pain, but until DBD::Informix becomes "smart"
> enough to
> detec
Sorry, I mean...
my $q = join ',' => map { '?' } @args;
my $sql = "$name VALUES ($q)";
if (!exists $sth{$sql}) {
# $sth{$sql} = $dbh->prepare_cached($sql);
$sth{$sql} = $dbh->prepare($sql);
}
return $sth{$name}->execute(@args);
Regards,
Hirosi Taguti
[EMAIL PROTECTED]
Thanks for a good hint & code.
I'm using DBD:DB2.
Maybe quatation (') rwapping data must be dropped, and
"CURRENT TIMESTAMP" keyword will be treated.
my @new_values = ();
my @place_holders =
map {
if (/^CURRENT TIMESTAMP$/) {
$_;
} else {
push @new_values => $_;
"?";
Hello,
Is there a module already existing to memoize non-place-holding sql
statements to place-holding ones and suppress prepare to minimum?
I'm now transforming other peaple's scripts for a performance inprovement.
This system is so big, I cann't understand quickly, but I foud that all
SQL state
Yesterday my friend installed perl from Sunfree and installed
DBD::Oracle with "-r=build64" at "perl Makefile.pl"
He said he can resolve the compile error of ELFCLASS64.
Did you try "-r=build64"
Regards,
Hirosi Taguti
[EMAIL PROTECTED]
> -Original Message-
> From: Jeff Urlwin [mailto:[E
Thanks for reply.
I'v tried but my script selecting the record in update
is not ending from "fetchrow_arrayref" in more than 20 minutes.
Our SQL Server is set as 600 sedonds, not 0 (infinite).
It display result just after updater's end.
Regards,
Hirosi Taguti
[E
Hello,
Is there way to set timeout in DBD::ODBC?
I'm trying to make a script updating SQL server.
I hear our SQL server is set 10 minutes as timeout (default).
And also I hear ADO has 30 secomd default time & can be
changed with some property.
Not knowing much about timeou
Hello,
Sorry if it is FAQ.
So called "Direct Pass" can be used by DBD::Oracle?
I ususally load data by my script made with DBI/DBD::Oracle.
But sometimes when the data is so big I wonder if I shoud use
my script or use SQL*LOADER.
I like Perl so much but I can't wait so lo
Hello,
Is there DBD-Oracle for ActivePerl 5.8.1.807 anywhere?
I know
ftp://ftp.esoftmatic.com/outgoing/DBI/806/DBD-Oracle.ppd
but it ends with error:
Entry point Perl_Glockhook_ptr not found in perl58.dll
My env:
Windows XP SP1
C:>perl -V
This is perl, v5.8.1 buil
19 matches
Mail list logo