Hi Jonathan,
I am sorry for the attachment, I didn't recognize this huge size, sorry
again.
about the versions,
NT 4.0
ActvieState Perl 5.6.1
ClientSDK 2.30, ESQL/C 9.21.TC1
MSVC 6.0
Do I need newer version of ClientSDK?
Regards,
Mahdi.
-Original Message-
From: Jonathan Leffler [mai
There is a problem with DBD::Oracle 1.07 coneecting to Oracle 7. I
sorted this issue with reference to an old post, but then just got
another one, about missing symbols on the make perl step of a static
build, so you might get the same thing, which is
/usr/ccs/bin/ld: Unsatisfied symbols:
dbd
"Robert S Robinson (Manchester)" wrote:
> Trying to install dbi:
>
> makefile runs ok.
>
> When I try to run
>
> make
>
> I get the follwing error messages:
>
> (Bundled) cc: warning 480: The -A option is available only with the C/ANSI C
> pr.
> (Bundled) cc: warning 480: The -O option is availab
"Mahdi A. Sbeih" wrote:
> Hi All,
>
> while trying to build DBD::Informix on NT,
>
> nmake Makefile.PL ...OK
> namke ...OK
> namke test : most of the test failed for the same error.
>
> nmake install ... OK
>
> attached is a snap shot for the error that was repeated for most
> of the 40 some tes
Tim
If you are interested, I have updated the W32ODBC module to include a few
more of the Win32::ODBC methods.
The module provided the basis for a great solution to a memory leak problem
with Win32::ODBC.
We were able to transparently upgrade to DBI without changing any of the
code.
I have att
Hi Jonathan,
i found your bug report where is exactely described
what went wrong.
http:[EMAIL PROTECTED]/msg04576.html
We have the same problem here ("desc_h" undefined).
I also read a posting from Mr. Bunce where he promised
to come up with a fix (that was at Wed, 6 Jun 2001).
http:[EMAIL PROT
It's even in the fine manual ('perldoc DBD::Oracle'):
=head2 dbms_output_enable / dbms_output_put / dbms_output_get
These functions use the PL/SQL DBMS_OUTPUT package to store and
retrieve text using the DBMS_OUTPUT buffer. Text stored in this buffer
by dbms_output_put or any PL/SQL block can b
More specifically, you enable DBMS output with a private database handle
function like (just setting another attribute on the database handle):
$dbh->func( 100, 'dbms_output_enable' );
and after the procedure is executed use something like
my @text = $dbh->func( 'dbms_output_get' );
to
Tim,
If you have a look at the doco on dbms_output, you will see it really does
nothing special apart from buffering the output in an internal buffer. That
is why it is limited in the amount of output you can produce using it.
SQL*Plus, and other tools that are dbms_output 'aware' simply make a
Hi Hervé. Your first problem is that your using a very old version of
DBD::DB2. If you used the latest version (0.75), the complete message
would have been:
"Total Environment allocation failure! Did you set up your DB2 client
environment?"
And that is very likely your problem. Make sur
I am using ODBC on winnt4 with sql server 7 and am having problems with DBI.
It will work fine for a while and then all of a sudden any script that has
"use DBI;" on it will no longer work, the page sits loading forever. I have
tried restarting the web server and didn't fix the problem but restar
If the actions in the second while do not rely on the all the records having
being processed in the first while then you should just combine the two. If
you can't combine the two, you could push all the results into an array and
then walk through the array.
-Original Message-
From: Eric,
I assume you want to read debug messages from triggers invoked as a result
of DBI, inserts, updates or deletes.
You can do this by having your triggers (and package functions) write to a
message table, which you then read back out using DBI.
Lincoln
-Original Message-
From: [EMAIL PRO
The code you have here will of course not work
As Paul mentioned selectall_arrayref might be your best bet, but if the data
set is quite large, you might just want to reexecute the statement and fetch
again.
Ilya
-Original Message-
From: Paul DuBois
To: Eric, Audet; [EMAIL PROTECTED]
S
At 2:11 PM -0400 7/23/01, Eric, Audet wrote:
>I want to be able to loop more than once through a result of rows as I
>am new .. I tried a few things ... but did not work .. here's one thing I
>tried.
>
>
>$sth2 = $dbh->prepare($query);
>$sth2->execute();
>$sth3=$sth2;
>$rv=$sth2->rows;
>while
I want to be able to loop more than once through a result of rows as I
am new .. I tried a few things ... but did not work .. here's one thing I
tried.
$sth2 = $dbh->prepare($query);
$sth2->execute();
$sth3=$sth2;
$rv=$sth2->rows;
while (@row=$sth2->fetchrow_array){
#do something
}
while (
I am new to the group, but I am actually subscribing to post a solution,
rather than ask a question (go figure) As it seems that if you ask what is
considered to be a stupid question, you either get flamed pretty bad, or a
message saying RTFM.
My problem related to the core dumps during the "make
Dear list members,
Is it possible to use the dbms_output functions with Perl DBI?
I guess not, since dbms_output is part of SQLPLUS.
Is there any other way to get output directly from a SQL statement in Perl
DBI? (Other than cut & paste to SQLPLUS.)
Regards,
Tim
I've seen this when the environment variables are not defined. If you're
trying to run this as a CGI, you'll have to explicitly export the
appropriate DB2 environment variables. I'd be more specific, but I don't
have access to the DB2 environment I've experienced this in at the moment.
-Ori
DBI->connect(MyDatabase)?
Please see perldoc DBI and perldoc DBD::DB2 for connection methods and
arguments.
Ilya
-Original Message-
From: Hervé BOULNOIS
To: [EMAIL PROTECTED]
Sent: 07/23/2001 10:10 AM
Subject: DBD::DB2
Hi
I try to connect to a remote DB2 database. I installed the
Hi
I try to connect to a remote DB2 database. I installed the DB2 Connect
Personnal Edition V7, DB2 Application Development Client V7, DB2
Administration Client V7, DBD::DB2 compilation was fine, test was OK (I'm
under RH 7.0 with perl 5.6.0).
I tested a connection with this little programm whi
First thing you want to do is open a simple SQL book or reference. 2 out of
4 of your queries are wrong. SHOW test is a mysql program command only and
is not a sql statement, therefore will not work with DBI.
$command_1 ="CREATE TABLE test (name VARCHAR(20), address1 VARCHAR(40),
address2 VAR
Hi Joseph,
> $command_1 ="CREATE TABLE test (name VARCHAR(20), address1 VARCHAR(40),
> address2 VARCHAR(40), city VARCHAR(25), state VARCHAR(16), postalcode
> VARCHAR(12), country VARCHAR(30)";
I don't know mysql, but don't you need an closing parenthis ")" ? (If that
is a parenthis)
> $comman
Hello,
I have a database set up on my web site at my ISP server. Connection to
the DB can only be made from the localhost. So I am doing everything
through CGI, Perl. They have the perl DBI and php3 that I can use to
access the database. They provided a script to access the DBI which I
modified
Hi All,
while trying to build DBD::Informix on NT,
nmake Makefile.PL ...OK
namke ...OK
namke test : most of the test failed for the same error.
nmake install ... OK
attached is a snap shot for the error that was repeated for most
of the 40 some tests.
Please let me know if you need more inf
I forgot to mention. Oraperl.pm is fine to let old code keep running, but
new scripts should absolutely, positively use DBI and DBD::Oracle for
database access.
--
Mac :})
** I normally forward private questions to the appropriate mail list. **
Give a hobbit a fish and he eats fish for a day.
Giv
The script already has a 'use Oraperl;' line which is all that should be
needed to use the Oraperl emulation that comes as part of DBD::Oracle. The
Oraperl emulation is provided specifically to allow old scripts that use
oraperl calls to continue to work with minimal changes.
A much much bigger
Thank you all for the great advice. Drawing the fields of the table out
into a hash and then doing the matching operation in Perl saved me a lot of
time. I went from 300 second queries to 7 seconds.
Here is a more complete description of the problem and my solution:
I have a CSV file with name
Hi
I got this error (below) when runnig 'make test'
I tried also 1.15 and 1.18 versions, all had same problem.
DBI-1.14 run test ok.
I'm currently using 1.14 from Mandrake RPM (perl-DBI-1.14-4mdk). And it
causes the same libsafe violation in some cases, not allways.
I'm using Mandrake Linux 7.2
29 matches
Mail list logo
