On 2010-09-06 17:50:44 +0530, Raghavendra Kalimisetty wrote:
> Hope you will provide solution to our problem.
>
> We have recently moved from Oracle 10g to Oracle 11g. Now we are facing an
> issue when trying to connect to DB through Perl.
>
> Here is the error we got:
>
> DBI connect('host=loc
rebuild DBI and DBD::Oracle with your new
Oracle enviornment.
Post the results of the Perl Makefile.pl and the make install.
That would be the first thing I would try
Cheers
John Scoles
> To: [email protected]
> Subject: Reg DBI Problem
> From: [email protected]
Hi ,
Hope you will provide solution to our problem.
We have recently moved from Oracle 10g to Oracle 11g. Now we are facing an
issue when trying to connect to DB through Perl.
Here is the error we got:
DBI connect('host=localhost;sid=omc','omcdbsys',...) failed: ORA-30136:
Drop-in compatibil
Hi,
at first it is not necessary to say "use DBI::DBD". You name the driver
in the call of DBI->connect(). Regarding the syntax error it would be
worth to see some more lines before line 23. May be a missing ';' in
line 22?
Regards
Robert
didik kustriant schrieb:
Hi, i'm newbie in perl pr
Hi, i'm newbie in perl programing
I have some problem when installing squid2mysql, the problem occur when
starting squid:
#service squid start
Starting squid: "use" not allowed in expression at /var/log/squid//squid2mysql
line 23, at end of line
syntax error at /var/log/squid//squid2mysql
Comments in line ...
-Original Message-
From: Gregg Allen [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 09, 2006 4:50 PM
To: [email protected]
Subject: Perl DBI problem.
When I try to install the CPAN module DBI on Mac Tiger, it fails even
with force. When I scroll back through
When I try to install the CPAN module DBI on Mac Tiger, it fails even
with force. When I scroll back through the output I find the
following error message:
"Can't locate Data/Dumper.pm in @INC" (followed by a long list of
directories.)
But I installed Data::Dumper with no problems.
I
Get an event 10046 trace. That will show you the exact problem.
--
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-Original Message-
From: Engin-A Guelen [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 07, 2005 9:03 AM
To: [email protected]
Subject: DBI-Problem
Hello Tim,
i am using
Hello Tim,
i am using Perl Version 5.8.7 with DBI v1.48 and DBD-Oracle 1.16.
Yesterday I tried to write about 100 Records into a table with serveral
dozen columns within an Oracle 9i - Database.
I prepared the insert - stmt once and for each record modified the
respective perl-variables.
After
Thank you for your answer.
I have checked that LD_LIBRARY_PATH is set, and it includes
$II_SYSTEM/ingres/lib.
I check that DBD::Ingres is present (version 0.30).
And i have the following line in my .profile :
LD_LIBRARY_PATH=/lib:/usr/ccs/lib:/usr/ucblib:/usr/local/lib:$II_SYSTEM/ingres/lib:$LD_LI
On 11/10/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
> Thank you for your answer.
> I have checked that LD_LIBRARY_PATH is set, and it includes
> $II_SYSTEM/ingres/lib.
>
> I check that DBD::Ingres is present (version 0.30).
> And i have the following line in my .profile :
>
> LD_LIBRARY_PAT
On Wed, Nov 09, 2005 at 08:34:39AM -0800, Jonathan Leffler wrote:
> On 11/9/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> >
> > Hello,
> > I'm having a trouble when i try to execute a simple perl program.
> >
> > Perl version : 5.6.1.
> > OS : SunOS 5.8
> >
> > The source code:
> >
> > #!/usr/
On 11/9/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
> Hello,
> I'm having a trouble when i try to execute a simple perl program.
>
> Perl version : 5.6.1.
> OS : SunOS 5.8
>
> The source code:
>
> #!/usr/local/bin/perl -w
>
> use DBI;
> use Sys::Hostname;
>
> $dbh = DBI->connect( "dbi:Ingres
Hello,
I'm having a trouble when i try to execute a simple perl program.
Perl version : 5.6.1.
OS : SunOS 5.8
The source code:
#!/usr/local/bin/perl -w
use DBI;
use Sys::Hostname;
$dbh = DBI->connect( "dbi:Ingres:kpreprod::maj", "kmaj" );
$dbh->commit ;
I get the following message :
insta
back again. Using PPM, I downloaded
DBD 1.16 and DBI 1.48.
And got this error again
Let me know if you can help,
Thanks,
Boris
_
From: Jonathan Leffler [mailto:[EMAIL PROTECTED]
Sent: Sunday, September 11, 2005 10:02 AM
To: Boris Volf
Cc: [email protected]
Subject: Re: DBI problem
you download the PPM).
On 9/9/05, Boris Volf <[EMAIL PROTECTED]> wrote:
>
> Yes,
> DBI version 1.48
> DBD version 1.16
>
> -Original Message-
> From: Reidy, Ron [mailto:[EMAIL PROTECTED]
> Sent: Friday, September 09, 2005 2:54 PM
> To: Boris Volf; dbi-u
Yes,
DBI version 1.48
DBD version 1.16
-Original Message-
From: Reidy, Ron [mailto:[EMAIL PROTECTED]
Sent: Friday, September 09, 2005 2:54 PM
To: Boris Volf; [email protected]
Subject: RE: DBI problem
Did you install DBD::Oracle?
--
Ron Reidy
Lead DBA
Array BioPharma, Inc
Did you install DBD::Oracle?
--
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-Original Message-
From: Boris Volf [mailto:[EMAIL PROTECTED]
Sent: Friday, September 09, 2005 12:50 PM
To: [email protected]
Subject: DBI problem
Hi,
I am trying to connect to an Oracle(8) database
Hi,
I am trying to connect to an Oracle(8) database using DBI module.
I have Perl 5.8.6 installed on my machine with DBI version 1.16, and DBD
version 1.47.
Below is my program that I am using to connect to the Database
use DBI;
$db_handle = DBI->connect("dbi:Oracle
Hi,
I am struggling with a (simple?) DBI problem under MP2
on Fedora Core 3. A script that uses Oracle-DBI works
under regular CGI but fails under MP2 with the
following error:
ERROR OCIEnvNlsCreate (check ORACLE_HOME and NLS
settings etc.)
My test script dumps out the environment varables
On 05/03/2005 11:42 AM, [EMAIL PROTECTED] said:
/usr/ucb/cc: language optional software package not installed
*** Error code 1
make: Fatal error: Command failed for target `Perl.o'
What language optional software package (name) does the error message
refer to?
The one that includes the same compil
This is, unfortunately, the usual collection of problems.
The C compiler you have 'installed' is a dummy that isn't really
there, and wouldn't be any use if it was. You need the Forte (Sun)
compiler because your Perl was compiled using -KPIC to generate shared
libraries - installing GCC won't hel
My ultimate goal is to load DBI to interface Perl with Sybase. I am
using Solaris 9 Operating system on a SUN Fire 880 Server.
The following are the step I followed to load the DBI.
#find out if I have DBI software loaded#
# find / -name perldoc
/usr/local
Look at odbc_more_results in DBD::ODBC and the same in the test cases in the
subdir called t when DBD::ODBC is unpacked.
Martin
--
Martin J. Evans
Easysoft Ltd, UK
Development
On 01-Dec-2004 Marc TRAVAILLE wrote:
> Good evenning,
>
> I create a calculate Select on SQL Server:
>
> SELECT col1,
Tim Bunce wrote:
If this code is running undr a web server then "not every time"
usually means you're not always running the code you think you are.
You've caught this one. My client is running on a web server farm. It
fails on one of the servers, but not the other two. It's still limited
to acc
On Tue, Oct 12, 2004 at 02:13:19PM -0400, Sean McMillan wrote:
> Tim Bunce wrote:
> >If this code is running undr a web server then "not every time"
> >usually means you're not always running the code you think you are.
>
> You've caught this one. My client is running on a web server farm.
On Thu, Oct 07, 2004 at 10:33:26AM -0400, Sean McMillan wrote:
> >It would only happen if the ora_auto_lob attribute has been explicitly set
> >false.
> >See the docs.
> Neither of these sets ora_auto_lob at all. Unfortunately, this
> doesn't happen on my test machines, only on my cl
It would only happen if the ora_auto_lob attribute has been explicitly set false.
See the docs.
Alas, I am not setting the ora_auto_lob attribute. according to the
docs, this needs to be set on prepare. I'm calling selectrow_array (and
selectrow_hashref), which take a hash of possible attributes
On Wed, Oct 06, 2004 at 04:47:22PM -0400, Sean McMillan wrote:
> Greetings DBI Users,
>
> I am having an intermittent problem which has increased in
> frequency. Googling the output doesn't provide any answers, or even
> evidence of other people with the same question.
>
> Whe
Greetings DBI Users,
I am having an intermittent problem which has increased in frequency.
Googling the output doesn't provide any answers, or even evidence of
other people with the same question.
When I pull from a table containing a CLOB column, sometimes, I don't
get the CLOB data, and ins
ricardo Guerra Flores wrote:
Hi all...
i'm having some problems trying to run a script that uses DBD::DB2 inside
mod_perl and the Apache::DBI module, the program runs right when i execute
it as a stand alone perl program. I've already set the ENV for db2home,
db2instance, etc. in startup.pl
This
Hi all...
i'm having some problems trying to run a script that uses DBD::DB2 inside
mod_perl and the Apache::DBI module, the program runs right when i execute
it as a stand alone perl program. I've already set the ENV for db2home,
db2instance, etc. in startup.pl
This is the trace when connect
On Sun, May 23, 2004 at 11:03:50AM +0300, Eilon Uzi wrote:
> Hi
>
> I want to install dbi and oracle dbd on Solaris but I got this problem in
> the DBI compilation :
What problem?
> Argument "0.48_01" isn't numeric in numeric lt (<) at
> /usr/local/lib/perl5/5.6.1/ExtUtils/MakeMaker.pm line 33
Hi
I want to install dbi and oracle dbd on Solaris but I got this problem in
the DBI compilation :
perl Makefile.PL
*** Note:
The optional PlRPC-modules (RPC::PlServer etc) are not installed.
If you want to use the DBD::Proxy driver and DBI::ProxyServer
modules, then you'll need to
On 02-Feb-2004 Tim Howell wrote:
> I've got a script that runs a query that uses a user defined function. The
> query looks something like 'SELECT * FROM dbo.f_myfunction(?, ?, ?);'
>
> My problem is that prepare fails with a syntax error indicating that there is
> a problem near @P1. I'm using
Subject
DBI problem to connect to a solid
hello,
I'm trying to make a connection to a solid database.
The database is from HPOV and it's called the nnm.
But I'm not able to make a connection with the DBI module.
Now my question is: Is the solid DB supported by DBI modul?
regards
Adrian
___
On 11-Sep-2003 [EMAIL PROTECTED] wrote:
>
> Hi,
>
> I'm not trying to connect to the 2 db's at the same time, so I'm not sure
> what you mean.
Appologies, I clicked reply on the wrong message. My reply was for Jenda
Krynicky.
Sorry about that.
--
Martin J. Evans
Easysoft Ltd, UK
Development
Hi,
I'm not trying to connect to the 2 db's at the same time, so I'm not sure
what you mean.
What I'm doing is executing the script for the 1st; editing it so that
the "dbname" parameter in the connect string is for the other 2nd; running
the script again.
The problem is that it's only connecti
I haven't tried it in a long time (other than running make test) but from
perldoc DBD::ODBC:
odbc_async_exec
Allow asynchronous execution of queries. Right now,
this causes a spin-loop (with a small "sleep") until
the sql is complete. This is useful, howev
Ronald J Kimball wrote:
On Tue, Jul 29, 2003 at 05:01:40PM -0400, JT MacNeil wrote:
Check the permissions on DBI.pm. They should be 664.
Also check the permissions on the directories in /usr/lib/whatever.
Thank Q to all!
type
PERL-DL_DEBUG=255 perl -e 'use DBI;'
DynaLoader is searc
On Tue, Jul 29, 2003 at 05:01:40PM -0400, JT MacNeil wrote:
> Check the permissions on DBI.pm. They should be 664.
>
Also check the permissions on the directories in /usr/lib/whatever.
Ronald
2003 1:37 PM
> To: [EMAIL PROTECTED]
> Subject: Perl DBI problem with locate loadable object
> Importance: Low
>
>
> My OS is Redhat Linux 7.2
> My database is PostgreSQL 7.1.3
>
> I have success installed DBI 1.3.7 and DBD-Pg 1.2.2
> with out any problem.
>
My OS is Redhat Linux 7.2
My database is PostgreSQL 7.1.3
I have success installed DBI 1.3.7 and DBD-Pg 1.2.2
with out any problem.
I created a testDBI.pl file contains two lines
#!/usr/bin/perl -w
use DBI;
When I execute this file, I got
Can't locate loadable object for module DBI in @INC (@INC
One way to handle this is to validate what you just inserted into the
database. Once you are sure of the success of your insert then delete it
from the pop server. I don't know how light weight you trying to keep
your program. This would certainly add some overhead not only to your
database ser
I have a Perl cron job that reads emails off a pop server once a
minute and stores them in a MySQL database on a remote machine. I
logged onto the MySQL server today and performed a "select * from
messages where received > 2003032200;" Zero records were
returned.
I did some more inv
I have a Perl cron job that reads emails off a pop server once a minute
and stores them in a MySQL database on a remote machine. I logged onto
the MySQL server today and performed a select * from messages where
received > 2003032200; Zero records were returned.
I did some more investigat
On Wed, 26 Feb 2003, Paul DuBois wrote:
> >I have a few books on Perl that have DBI examples but they are not
> >made for MySQL and the examples are very Mickey Mouse compared to
> >what I'm trying to do. Any suggestions or directions to potential
> >resources will be greatly appreciated.
> The
are using placeholders, right? ;-)
> >
> > --Thunder
> >
> > -Original Message-
> > From: gregg [mailto:[EMAIL PROTECTED]
> > Sent: Wednesday, February 26, 2003 9:11 AM
> > To: [EMAIL PROTECTED]
> > Subject: MySQL DBI problem
> >
> > I a
r but it wasn't inserted either.
Thanks.
On Wednesday, February 26, 2003, at 11:15 AM, PARLEY,THUNDER
(HP-MountainView,ex1) wrote:
You are using placeholders, right? ;-)
--Thunder
-Original Message-
From: gregg [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 26, 2003 9:11 AM
To:
I am trying to read email off a mail server using perl, parse it,
and then store the fields in a MySQL database. I managed to write
the first two parts in a couple of days, but now I've spent two
weeks trying to get the fields into a the "Messages" database. I
have got several fields to go in
I am trying to read email off a mail server using perl, parse it, and
then store the fields in a MySQL database. I managed to write the
first two parts in a couple of days, but now I've spent two weeks
trying to get the fields into a the "Messages" database. I have got
several fields to go in
"Alain Brasseur" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Hello,
>
> I have install the same configuration on three pc but the last one doesn't
> work.
>
> Apache 2.44 9+mysql+ activeperl5.8 + module cgi, dbd-mysqlPP via ppm.bat.
> (win98 is the OS)
>
> I
Hello,
I have install the same configuration on three pc but the last one doesn't
work.
Apache 2.44 9+mysql+ activeperl5.8 + module cgi, dbd-mysqlPP via ppm.bat.
(win98 is the OS)
I have the following error : can't load DBI (@IND is d:\perl\bin;
d:\perl\lib, ...).
Do I have forgotten somethi
Thanks Jonathan. I'll look into it. The Makefile is probably missing
a dependency.
Tim.
On Sun, Dec 01, 2002 at 08:24:26PM -0800, Jonathan Leffler wrote:
> Dear Tim,
>
> An odd one, and I'm not sure whether you even want to do anything
> about it, but...
>
> I was using 'cpan' from Perl 5.8.0
How do I unsubscribe from this group?
-Original Message-
From: David M. Lloyd [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 16, 2002 11:50 AM
To: darrefo
Cc: [EMAIL PROTECTED]
Subject: Re: iPlanet, Perl 5.8.0, DBI problem
Try to write a CGI that generates the whole error message as
Try to write a CGI that generates the whole error message as valid output,
something like this:
#!/usr/bin/perl
eval "use DBI;";
print "Content-Type: text/plain\n\n";
if ($@) {
print "The error was $@";
} else {
print "There was no error, weird";
}
Then you can see the
I have encountered a peculiar problem involving the DBI, although I
have no evidence to suggest the DBI is the cause of the problem.
I am running Solaris 8 and using the iPlanet 6.0 (I guess now called Sun
One)
web server. I have a load of perl CGI scripts talking to an Oracle 9i
database
on anot
On Fri, 2 Aug 2002 21:53:31 -0700, Soheil Shaghaghi wrote:
>2. This one might not be related to DBI, but I can't find any answer for it
>anywhere!
>I see this error inmy eror log files:
>Argument "O_RDONLY" isn't numeric in subroutine entry at
>/usr/local/lib/perl5/5.6.1/i386-freebsd/DB_File.pm l
Hello everone,
I was running Peerl 5.6.0, Apache 1.3.4, and mod_perl 1.27 on a FreeBSD
server.
I upgraded to Perl 5.6.1, and since then I have been having a few problems
with DBI:
1. If I add mod_perl to a site, the httpd server will not start.
PerlModule Apache::Registry
ok, now i am getting an error that my locales are incorrectly set, deart
gd this is too much
posting? Its a prod problem and
> i would really like to get going.
>
> Thanx a lot.
> Danny
>
>
> > -Original Message-
> > From: Rozengurtel, Daniel
> > Sent: Wednesday, January 09, 2002 9:52 AM
> > To: '[EMAIL PROTECTED]
I guess you took the time to actually see the code. Good response. See if
you can run it with those fixes before trying my suggestions.
Ilya
-Original Message-
From: David M. Lloyd
To: Rozengurtel, Daniel
Cc: '[EMAIL PROTECTED]'
Sent: 1/9/02 10:19 AM
Subject: Re: FW: D
ECTED]'
> Cc: Rueth, Loretta F.
> Subject: DBI Problem
>
> Hello friends,
>
> I have a problem with DBI.pm module running on Sun5.8. While using
> selectall_hashref i get this strange error. I am 100% sure the table
to
> select from does exist. And that the s
to my previous posting? Its a prod problem and
> i would really like to get going.
>
> Thanx a lot.
> Danny
>
>
> > -Original Message-
> > From: Rozengurtel, Daniel
> > Sent: Wednesday, January 09, 2002 9:52 AM
> > To: '[EMAIL PROTE
t; Cc: Rueth, Loretta F.
> Subject: DBI Problem
>
> Hello friends,
>
> I have a problem with DBI.pm module running on Sun5.8. While using
> selectall_hashref i get this strange error. I am 100% sure the table to
> select from does exist. And that the same statement w
Hello friends,
I have a problem with DBI.pm module running on Sun5.8. While using
selectall_hashref i get this strange error. I am 100% sure the table to
select from does exist. And that the same statement works on our dev machine
(which is Sun5.6) We also descovered that there is a diference in
> -Original Message-
> From: Michael A. Chase [mailto:[EMAIL PROTECTED]]
> Sent: Friday, June 08, 2001 1:50 PM
> To: Pei Du; [EMAIL PROTECTED]
> Subject: Re: install DBI problem
>
>
> It looks like you are using ActiveState Perl. If you are, use PPM to
> ins
ive a hobbit a ring and he'll eat fish for an age.
- Original Message -
From: "Pei Du" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, June 07, 2001 16:27
Subject: install DBI problem
> QUICK START GUIDE:
>
> The DBI requires one or m
QUICK START GUIDE:
The DBI requires one or more 'driver' modules to talk to databases.
Check that a DBD::* module exists for the database you wish to use.
Read the DBI README then Build/test/install the DBI by doing
perl Makefile.PL
make
make test
Alan Pesola wrote:
> How can I get the data type of each column(text, single,date etc...)
> Not familiar with hashes!!
Get familiar with them...
> This command $sth->{TYPE}; will supposedly return an array reference
> for each column but how do I read it correctly?? I keep getting
> Array(hexval
71 matches
Mail list logo
