I have found that the problem ocuurs in many
cases. For example, I use
sqlload userid=scott/tiger control=load log=load.log
to upload my data to the oracle. Once the data file
is very long. The same problem also occurs: it is stuck.
Jeff
>From: "Sterin, Ilya" <[EMAIL PROTECTED]>
>To: jeff knot
- Original Message -
From: "Kawai,Takanori" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, May 02, 2001 5:58 AM
Subject: Re: Extract data from MS Excel Spreadsheets. Can it be done?
(snip)
> Now, I'm planinng to make a DBD for Excel with Spreadsheet::ParseExcel
and
> Spread
use DBD::ODBC
Neil
> -Original Message-
> From: David Blaikie [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, May 03, 2001 8:24 AM
> To: [EMAIL PROTECTED]
> Subject: DBD driver for Filemaker Pro
>
>
> Hi All,
>
> does anyone know if there is a DBD driver for Filemaker Pro?
>
> David
>
Hi All,
does anyone know if there is a DBD driver for Filemaker Pro?
David
Didn't know that SUN bought Oracle, but these days you never know,
especially when both of them are more focused on overthrowing Mico$oft than
their product:-) Kidding...
Did you explicitly set AutoCommit => 0, if not you must do that in order to
use commit().
Not sure what is overflowing and wh
Excuse me. But what exactly is your code. I hope your not looping over both
of those lines of code.
-- Neil
> -Original Message-
> From: jeff knot [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, May 03, 2001 8:14 AM
> To: [EMAIL PROTECTED]
> Subject: DBI buffer commit
>
>
> Hi,
> I am new
Ah, guess that wasn't needed.
Sorry Michael, didn't see your post.
Ilya Sterin
-Original Message-
From: Sterin, Ilya [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 02, 2001 9:24 PM
To: David Sevier; [EMAIL PROTECTED]
Subject: RE: Sybase & problem with finish()
How about undef'ing the
How about undef'ing the statement handle
undef($sth);
Then try to call disconnect().
Ilya Sterin
-Original Message-
From: David Sevier [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 02, 2001 5:49 PM
To: [EMAIL PROTECTED]
Subject: DBD:Sybase & problem with finish()
Hi!
I've got a str
> -Original Message-
> From: Sterin, Ilya [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, May 02, 2001 10:56 PM
> To: 'Simon Oliver '
> Cc: '''[EMAIL PROTECTED]' ' '
> Subject: RE: Extract data from MS Excel Spreadsheets. Can it be done?
>
>
> Also I would think that this is a big enough i
Hi,
I am new to this list and I have the following question:
My database is SUN Oracle. I try to use
perl DBI to update the record:
$sth=$dbh->prepare("update mytable set filed=mynewrecord
where id=?");
$sth->execute ($i);
After doing the above over 1000 lines, my database st
Tried that...no good. Still took 43 seconds, I think. I've watched it zip
through all the records until it gets to the end where fetch returns undef, and
that seems to be taking a while.
I kinda' thought that it might be the connection, too, but obviously that's not
the deal.
I'm at a loss...
Set the syb_flush_finish attribute - that should fix the problem.
(the issue being that MS-SQL doesn't handle the ct_cancel() call
correctly)
Michael
David Sevier writes:
> Hi!
>
> I've got a strange problem with DBD:Sybase,
>
> We have a program written that goes into our SQL Server bo
Hi!
I've got a strange problem with DBD:Sybase,
We have a program written that goes into our SQL Server box and lists the
active threads so that we can monitor it remotely. For the most part it
works fine. We've used the same script using DBD:ODBC, and DBD:ODBC through
the dbiproxy. We recent
You would think that I would have already thought to try that...but, alas, I
am a moron...
I'll give that a whirl...
Phillip
Chris Winters wrote:
> * Phillip Perkins ([EMAIL PROTECTED]) [010502 17:44]:
> > Just tried it out... Still takes 25 seconds to do a
> > fetchall_arrayref. This is on
* Phillip Perkins ([EMAIL PROTECTED]) [010502 17:44]:
> Just tried it out... Still takes 25 seconds to do a
> fetchall_arrayref. This is on a query that returns 994 records of
> 22 fields. Then I did another that did 1 record of 69 fields...and
> it took 46 seconds. Is it just the machine that
Just tried it out... Still takes 25 seconds to do a fetchall_arrayref. This is
on a query that returns 994 records of 22 fields. Then I did another that did 1
record of 69 fields...and it took 46 seconds. Is it just the machine that it's
on? I am getting the data off of a Novell mounted serve
Okay, sorry in my last email. I put down wrong version numbers. However, I'm
updating XBase, DBD::XBase, and DBI. Gonna' give it a whirl...
Phillip
"Sterin, Ilya" wrote:
> Phillip did send an example yesterday. Look in your email or the archives.
>
> Ilya Sterin
>
> -Original Message---
- Forwarded message from Bret Bailey <[EMAIL PROTECTED]> -
Date: Tue, 01 May 2001 16:36:37 -0700
From: Bret Bailey <[EMAIL PROTECTED]>
X-Accept-Language: en
To: [EMAIL PROTECTED]
Subject: DBD::Oracle and International characters?
Hi there,
I am using DBI and DBD::Oracle for web applicat
At 12:13 PM 5/2/2001 -0600, Sterin, Ilya wrote:
>Actually I am not even seeing the error number/message
>
>DBD::Pg::st execute failed: ERRO at init_accounts line 163.
>Unable to insert fundsource (ERRO)
>
>ERRO will not really help us help you. If that is all you are getting, try
>using trace(2,
Actually I am not even seeing the error number/message
DBD::Pg::st execute failed: ERRO at init_accounts line 163.
Unable to insert fundsource (ERRO)
ERRO will not really help us help you. If that is all you are getting, try
using trace(2, "file.log") (see docs) to trace the procedures, then
Hmm, I've never seen that before. Are you sure your DB2 client environment
is setup properly? i.e. did you run sqllib/db2profile? Can you connect to
a database from the command line? If this is all okay, please send me the
complete output for each step: 'perl Makefile.PL', 'make' & 'make insta
At 09:22 AM 5/2/2001 -0600, Sterin, Ilya wrote:
>We would also like to see your prepare statement with a little more
>description of the fields that are being binded.
Ilya,
Thanks for your quick response!
I think you're inferring too much complexity. I get the same bogus error
message(s) doin
´ve tried to install DBD:DB2 using CPAN or compiling it directly via perl Makefile.PL,
then make test and i get always this error:
[root@linux DBD-DB2-0.75]# make test
make[1]: Entering directory '/instalar/DBD-DB2-0.75/Constants'
make[1]: Leaving directory '/instalar/DBD-DB2-0.75/Constants'
PER
I'm running RedHat Linux 6.1 (Cartman), Perl version 5.005_03 for i386 Linux,
XBase 1.07, and DBD::XBase 0.160.
Here's the example again:
use DBI;
my $dbh = DBI->connect("DBI:XBase:/directory") || die...;
my $sth = $dbh->prepare("select * from table") || die...;
# This is the part that only ta
This is something done a lot based on my experience. Here
we're okay for the most part: We mostly need to extract
spreadsheet data row by row and either use it as Oracle query
arguments or add to it with row by row queries.
You can read row by row like that with Spreadsheet::ParseExcel
and cr
We would also like to see your prepare statement with a little more
description of the fields that are being binded.
Ilya Sterin
-Original Message-
From: Rick Cochran
To: [EMAIL PROTECTED]
Sent: 05/02/2001 9:05 AM
Subject: DBD::Pg errstr problem
The following code:
$insert_fundsou
The following code:
$insert_fundsource->execute("$aalias -
tmp[1]",$tmp[1],$aalias,$tmp[4],$accttypes{$tmp[2]},$tmp[5])
or carp "Unable to insert fundsource (".$dbh->errstr.")\n";
produces the following error messages:
DBD::Pg::st execute failed: ERRO at init_accounts line 163.
U
Well, first of both shoud of failed, since you can't use ';' at the end of
you query in DBI. That simply is an end line character used by various
databaser query parsers.
Second, you should use trace() possibly at level two to trace the operation.
You can then post the output to the list.
Ilya S
We need more code than (SELECT... and INSERT...). How did you see the funny
unescaped character? Did you print them out, in that case did you binmode
STDOUT?
Use trace() to see exactly what is going on. Also an error message on
insert would be very helpful to us.
Ilya Sterin
-Original M
Hi,
although I'm programming a lot I don't use DBI every day.
So, being more familar with perl itself, C or
SGML-Standards, I found a problem that unfortunately costed
me a whole evening to identify and I think it is some kind
of bug. I expected that both of the following expressions
should have
Also I would think that this is a big enough issue to address, since most of
the servers are not NT and most of the clients are win32, therefore if
clients are working on excel which is later uploaded to the server (Unix),
it should be processed on the server side, rather than having users save as
Right, but what I was thinking is how difficult would it be to port DBD::ADO
to use OLE::Storage which is cross platform and preatty much same OLE DB
functionality, unless you know of any limitations.
Ilya Sterin
-Original Message-
From: Simon Oliver
Cc: ''[EMAIL PROTECTED]' '
Sent: 05/0
Phillip did send an example yesterday. Look in your email or the archives.
Ilya Sterin
-Original Message-
From: Honza Pazdziora
To: Phillip Perkins
Cc: [EMAIL PROTECTED]
Sent: 05/02/2001 1:46 AM
Subject: Re: Last fetch takes forever to undef under XBase
On Tue, May 01, 2001 at 11:36:4
We've encountered some trouble with fetching CLOBs using a 8.17 client vs.
an Oracle utf8 DB. I'm pretty sure the bug's somewhere in the OCI, but I
may
be wrong, and anyway - maybe you've heard something about this.
When running the following code I get the following output (including
error)
According to the man page...
The DBD::Sybase module is built on top of the Sybase Open Client Client
Library API. This library makes use of the Sybase interfaces file
(sql.ini on Win32 machines) to make a link between a logical server name
(e.g. SYBASE) and the physical machine / port number t
Hi!
Does anybody knows how to quote the binarie fields properly using the DBI.pm (on
Mysql)?
I used "SELECT ..." ,
then
$dnh->quote(some data),
then
$dbh->do("INSERT ...")
The last "do" leads to error.
As I see, some funny characters selected from binary fields are not escaped. I
compared
I'm trying to install DBD-Sybase. I already have DBI installed. So first, I
installed freetds.
Next, I was able to configure DBD-Sybase already. But I tried running "make
test" to make sure everything is OK. I know I have to edit PWD. But what
value should I put into SRV? Is it the IP or the
Steve Sapovits wrote:
> If I'm wrong about this and someone's used either DBD::ADO or
> DBD::ODBC on Sun/Solaris, I'd like to hear how you did it.
One can't use DBD::ADO because that uses Win32::OLE which needs a Win32
Operating System.
--
Simon Oliver
On Tue, May 01, 2001 at 11:36:49AM -0400, Phillip Perkins wrote:
> Here's a question I hope someone can answer for me. When using DBI to
> query a table, the query takes only milliseconds. However, if you do
> any type of fetch on an sth, when you reach the EOF ($sth->fetch is
> undef), it takes
39 matches
Mail list logo