> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
>
> I have two questions. First, where can I find the possible error
> strings that $DBI::errstr might contain?
You will have to look in (at least) three places:
1) the DBI documentation (and probably also the code) to see
the error me
Smithson, Michael (M.E.) <[EMAIL PROTECTED]> wrote:
> ...
> When I turn off the taint mode, it seems to work fine.
> Are there any workarounds or resources that anyone can
> tell me about to help me out??
Untaint the data before you send it to DBD::CSV or DBD::AnyData (see the
faq on Taint), o
Hi,
I have two questions. First, where can I find the possible error
strings that $DBI::errstr might contain?
Second, when a connection to a database is made via DBI->connect(..),
how long will that connection stay open? Does it matter if the
database is on the same machine or on a separate mac
Hi,
I have installed
Oracle 9.0.1
DBI-1.13
DBD-Oracle-1.03
The test script works well when I ran the script on
a remote machine. The script die with "ERROR: -1 'ERROR OCIEnvInit'"
if I ran the script on the same machine that Oracle is
running on? Any idea/ suggestion are very welcome.
James
>-Original Message-
>From: Jeff Urlwin [mailto:[EMAIL PROTECTED]]
>Sent: Thursday, August 23, 2001 6:27 AM
>To: Neil Lunn; 'Timothy C. Phan'; [EMAIL PROTECTED]
>Subject: RE: [Patch] RE: DBD-ODBC 0.28 for Cygwin
>
>
>Neil,
>
>To confirm: you don't need the readme.cygwin anymore?
That shoul
On Wed, Aug 22, 2001 at 03:22:53PM -0700, Tim Harsch wrote:
> I have this problem where I think DBD::Oracle truncated tailing whitespace
> from some input so I searched the archives and I ran accross this thread,
> where someone states that DBD::Oracle trims trailing whitespace by default.
>
> ht
On Wed, Aug 22, 2001 at 01:49:20PM -0700, Amy Roberts wrote:
> I have difficulty installing DBI because the installment package uses gcc. I
> do not have gcc on my machine and I can not install gcc because that
> requires a C compiler. A C++ compiler-which is what I have won't work. I
> want to kn
Tim Harsch writes:
> I have this problem where I think DBD::Oracle truncated tailing whitespace
> from some input so I searched the archives and I ran accross this thread,
> where someone states that DBD::Oracle trims trailing whitespace by default.
>
> http://www.xray.mpe.mpg.de/cgi-bin/w3g
I have this problem where I think DBD::Oracle truncated tailing whitespace
from some input so I searched the archives and I ran accross this thread,
where someone states that DBD::Oracle trims trailing whitespace by default.
http://www.xray.mpe.mpg.de/cgi-bin/w3glimpse2html/dbi/2001-06/msg00451.h
Michael,
You are a star! Using TDS 7.0 had no effect at all, but using the
convert function solved the problem.
For anyone searching the archive of this list, here is the statement I
used to return 'Memo' field(s) intact :
my $sth = $dbh->prepare("SELECT convert(text, [Long Description
(English
Hi there,
Thanks for the answer.
If I use ppm to install DBI module it gives me error that it cannot
install DBI module for multithreaded environment and it aborts :-(
Shital Joshi
On Wed, 22 Aug 2001 [EMAIL PROTECTED] wrote:
>
>
> Use ppm instead of make or nmake to install modules on W
I have difficulty installing DBI because the installment package uses gcc. I
do not have gcc on my machine and I can not install gcc because that
requires a C compiler. A C++ compiler-which is what I have won't work. I
want to know if there is a way to install DBI without going through a build
usi
Use ppm instead of make or nmake to install modules on Windows, assuming you're
using ActiveState Perl.
Typing 'ppm' by itself at a command prompt should give you the list of options.
Helps if the machine has a live internet connection.
Shital Joshi <[EMAIL PROTECTED]> on 08/22/2001 01:15:22
dan writes:
> Hello,
>
> I'm using Red Hat Linux 5.2, Perl 5.004_04, FreeTDS 0.52 and DBD::Sybase
> 0.91 to communicate with MS-SQL 7.0 on a machine running MS-Windows
> 2000.
>
> Reading through the archive of this list, it seems the problem I'm
> having is seemingly not uncommon. Howe
It is now.
Jeff
>
> Can't the (intended) error be silenced by the test script?
>
> Tim.
>
> On Wed, Aug 08, 2001 at 12:24:58PM +1000, Neil Lunn wrote:
> > > I have this problem during 'make test'. Is it good/bad? Thanks
> > >
> > >t/02simple..ok 7/14DBD::ODBC::st fetchrow failed:
> > >
Neil,
To confirm: you don't need the readme.cygwin anymore?
Thanks,
Jeff
> -Original Message-
> From: Neil Lunn [mailto:[EMAIL PROTECTED]]
> Sent: Monday, August 06, 2001 8:41 PM
> To: 'Timothy C. Phan'; [EMAIL PROTECTED]
> Subject: [Patch] RE: DBD-ODBC 0.28 for Cygwin
>
>
>
> >-Or
On Tue, Aug 21, 2001 at 10:48:01AM -0700, Amy Roberts wrote:
> I have difficulty installing DBI because the installment package uses gcc. I
> do not have gcc on my machine and I can not install gcc because that
> requires a C compiler. A C++ compiler-which is what I have won't work. I
> want to kn
Why aren't you using Activestate's PPM to download/install the modules?
I seem to remember needing to install the Proxy module also available from Activestate
to get MySql-Perl to install properly.
If at all possible, use Activestate's prebuilt binaries instead of using VC to build
the source
Hi there,
I am trying to install DBI module on WinNT 4.0
I downloaded DBI module from couple of places and tried to install it but
it gave me same error.
When I say perl makefile.pl for DBI module it gives me following output:
* You are using a perl with experimental threading enable
***
> > Are you using Apache::DBI? Are you opening a connection in the parent
> > process (in startup.pl or equivalent)?
> Yes, yes.
Don't open a connection during startup. If you do, it will be shared when
Apache forks, and sharing a database handle is bad for the same reasons
sharig a file handle
> After some time of work (about hundred of requests), I get
>
> DBD::Oracle::db prepare failed: ORA-03113: end-of-file on communication
> channel
> (DBD: error possibly near <*> indicator at char 1 in '<*>select
slogan_text
> from
> slogans') at /usr/local/www/lib/SQL.pm line 221.
>
> and all Or
I am use:
Solaris 8 on Intel, Oracle 8.1.5, DBI-1.18, DBD-Oracle-1.08
My script:
#! /usr/bin/perl
use DBI;
use strict;
my $dbh = DBI->connect( "dbi:Oracle:base", 'user', 'pass',) or die $DBI::errstr; #line
16 here
$dbh->disconnect;
Probmem:
if i try to connect with Oracle with DBD compile
I have difficulty installing DBI because the installment package uses gcc. I
do not have gcc on my machine and I can not install gcc because that
requires a C compiler. A C++ compiler-which is what I have won't work. I
want to know if there is a way to install DBI without going through a build
usi
Hi, I'm having difficulty installing DBD-ASAny-1.10
on my linux box. Red Hat 2.2.16-22
I'm at the perl Makefile.PL stage and getting this
responce:
Using DBI 1.19 installed in
/usr/local/lib/perl5/site_perl/5.6.1/i686-linux-ld/auto/DBI
Configuring DBD::ASAny...
** Unable to find Adaptiver Serv
Hello, I'm attempting to build DBD-Oracle 1.08 on a Compaq alpha box and
running into an unknown symbol. I didn't want to post the huge gory
details to the list w/o checking to see if there was a known work around
to this problem. The basic stats are: Oracle 9.0.1, Perl 5.6.1, Tru64
version 5
Wes,
Thanks for your quick reply. I understand the relationships enough to
know that my original subject line was confusing. I can eliminate the
parse_form subroutine, but it doesn't really make a difference, the form
input isn't recognized. The problems show up in my original html print
statem
You need to set your oracle environment:
see:
http://ugweb.cs.ualberta.ca/~c391/manual/chapt3.html
If you still have trouble, feel free to email me direct.
On Wed, 22 Aug 2001, Carlos Augusto Perez Lima wrote:
> Hi,
>
> I'm wanting to access a Remote Database Oracle in my network. The dat
System: Sun Ultra 2.7
install_driver(Oracle) failed: Can't load
'/usr/local/lib/perl5/site_perl/5.6.0/sun4-solaris/auto/DBD/Oracle/Oracle.so'
for module
DBD::Oracle: ld.so.1: /usr/local/bin/perl: fatal: libclntsh.so.1.0: open
failed: No such file or directory at
/usr/local/lib/perl5/5.6.0/sun
Hi,
I'm wanting to access a Remote Database Oracle in my network. The database
Oracle is a machine windows...
I'm trying to configure DBD-Oracle1.08, but It's show error...
# perl Makefile.PL
Using DBI 1.18 installed in
/usr/local/lib/perl5/site_perl/5.005/alpha-dec_osf/auto/DBI
Configuring D
Greg...
Thanks for the input but that did not help. I looked in the DBI.pm file
in the lib directory (of the DBI directory that was set up by the
Makefile...if this is not the correct one to look at then let me know)
and it had the correcto version number.
To test something out...I ran the test.
Installing DBD::Oracle (v1.08), DBI (1.19), on HP 11, and Oracle 8.1.7
This may be old news, falling under the category of "been there done that"
but for anyone who is having/has had a hard time, here is how I did it.
1) Make sure you have all your Oracle environmental variables set!!! If you
On Wed, Aug 22, 2001 at 09:42:59AM -0400, Perrin Harkins wrote:
> > > Are you using Apache::DBI? Are you opening a connection in the parent
> > > process (in startup.pl or equivalent)?
> > Yes, yes.
>
> Don't open a connection during startup. If you do, it will be shared when
> Apache forks, an
Hi,
My perl/cgi script allows me to fetch any row(s) from my Postgres 7.1
database and display the returns in a Web page as long as I don't have
to parse name/value input from my HTML form. When I try to get the
script to read text input from the form and output the matching row(s)
to the Web pa
I really love using the DBD::CSV module for parsing text files, but I have run into a
slight problem. When I run my cgi scripts with the -T mode on, I get the following
error:
DBD::CSV::Statement=HASH(0x2867c8) is not a valid SQL::Statement object at
/proj/fsn/www/shared/perlib/DBD/File.pm li
On Wed, Aug 22, 2001 at 09:07:59AM -0400, Perrin Harkins wrote:
> > (DBD: error possibly near <*> indicator at char 1 in '<*>select
> slogan_text
> > from
> > slogans') at /usr/local/www/lib/SQL.pm line 221.
> Are you using Apache::DBI? Are you opening a connection in the parent
> process (in st
Hello,
I'm using Red Hat Linux 5.2, Perl 5.004_04, FreeTDS 0.52 and DBD::Sybase
0.91 to communicate with MS-SQL 7.0 on a machine running MS-Windows
2000.
Reading through the archive of this list, it seems the problem I'm
having is seemingly not uncommon. However, I'm either overlooking the
solu
Hello!
I'm getting constant troubles with DBD::Oracle and mod_perl.
DBD::Oracle 1.08, DBI 1.19, mod_perl 1.26 on Apache 1.3.20,
SunOS netra 5.8 Generic_108528-09 sun4u sparc SUNW,UltraAX-i2
gcc 2.95.3 20010315 (release)
This is perl, v5.6.1 built for sun4-solaris
# perl -V:usemymalloc
usemymall
This response received from Stephen Clouse. This fixed the problem.
>>
Ah, you had the same problem I did on Slackware 8. Seems they do something like
hardcode some SuSE pathnames into the thing and it won't link properly anywhere
else. But I have figured out how to get everything to link suc
> Several years ago I wrote some code making sql connections
> from the web server on an NT box to SQL server on the same
> machine. Now I'd like to have the webserver and sqlserver on
> separate hosts.
If both servers are Win32 then there should be no problem. Just make sure
your DSN is working
39 matches
Mail list logo
