Hi, I just discovered a typo in my recent post (see below)
> > Does
> >
> > print $params{-id};
> >
> > really print your isolate ID entered into the form?
> > If you are new to CGI.pm, perhaps you mean someting
> > like $query->params('id') ?
^
This should read $query-
Actually just a thought. Is there a possibilty that iodbc was installed on
this machine. The driver manager found should have been reported by
Makefile.PL. I remeber Nick providing patches explicitly so that UnixODBC
wasn't reported as something else.
Neil
> -Original Message-
> From: N
> -Original Message-
> From: Sterin, Ilya [mailto:[EMAIL PROTECTED]]
> Sent: Friday, May 11, 2001 1:58 PM
> To: Jack McKinney; [EMAIL PROTECTED]
> Subject: RE: ODBC connects, but queries fail.
>
>
> But what driver are you using, ODBC is a layer on top of
> other drivers, like
> Access
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Thu, May 10, 2001 at 11:27:21PM -0500, VIDYASAGAR R NALLU wrote:
> I have problem installing DBD-Oracle. Basically i downloaded the
> DBD-Oracle-1.0.6.tar.gz and uncompressed into a temporary folder. When
> i'm trying to use the command "perl Makef
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Thu, May 10, 2001 at 09:58:17PM -0700, Vargas, Steven wrote:
> $h->rows count is incomplete before all rows fetched.
You apparently didn't read the Fine Manual's note about using $sth->rows with
SELECT statements.
Generally, you can on
I just ran an example by my co-worker, thinking it would be very easy.
However, I've never used these modules before and it really bombed. I'm
trying a simple SQL query to return the total number of rows in an Oracle
database before printing each one. Here's the small program. Error message
at __E
> -Original Message-
> From: Jack McKinney [mailto:[EMAIL PROTECTED]]
> Sent: Friday, May 11, 2001 1:24 PM
> To: [EMAIL PROTECTED]
> Subject: Re: ODBC connects, but queries fail.
>
>
> Big Brother tells me that Sterin, Ilya wrote:
> > DBI->connect(Driver=/usr/local/lib/odbc-i02.so;Se...
Hi all,
I have problem installing DBD-Oracle. Basically i downloaded the
DBD-Oracle-1.0.6.tar.gz and uncompressed into a temporary folder. When
i'm trying to use the command "perl Makefile.pl" the following error is
displayed:
Can't locate DBI.pm in @INC(@INC contains: D:Perl/lib
D:/Perl/si
But what driver are you using, ODBC is a layer on top of other drivers, like
Access, SQL Server, Oracle, etc..., I don't think /usr/local/lib/odbc-i02.so
qualifies as a driver. You might want to check your ODBC documentation.
Ilya Sterin
-Original Message-
From: Jack McKinney [mailto:[E
Big Brother tells me that Sterin, Ilya wrote:
> DBI->connect(Driver=/usr/local/lib/odbc-i02.so;Se...
>
> You still must use DBI->connect("dbi:ODBC:dsn_string_here")
I am:
$driver = "Driver=/usr/local/lib/odbc-i02.so;... ";
$db = DBI->connect("DBI:ODBC:$driver") or die $DBI::err
DBI->connect(Driver=/usr/local/lib/odbc-i02.so;Se...
You still must use DBI->connect("dbi:ODBC:dsn_string_here")
Ilya Sterin
-Original Message-
From: Jack McKinney [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 10, 2001 10:53 PM
To: '[EMAIL PROTECTED] '
Subject: Re: ODBC co
Make sure your DSN is not *read only*.
Ilya Sterin
-Original Message-
From: Trevor Webster [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 10, 2001 7:00 PM
To: Sterin, Ilya; dbi-users
Subject: Re: Problem with DBI and Access newbie
Yeah sorry, but I had started preparing the message whi
couple of reasons:
1) continuity (this is the only interaction of the remainder of the
development with Perl scripts)
2) documentation (saves me explaining PHP AND Perl:DBI in the
emergency documentation should I keel over and die tomorrow and take
the Perl:DBI knowledge with me. like it or not
Big Brother tells me that Neil Lunn wrote:
>
> Nonetheless the concept it the same, and is part of the ODBC specification.
> Look at all the entries in your DSN TEST ie hostname=myhost or whatever. You
> supply these as the DSN string in your connect statement.
OK. I see. Here is what I go
> -Original Message-
> From: Jack McKinney [mailto:[EMAIL PROTECTED]]
> Sent: Friday, May 11, 2001 12:27 AM
> To: '[EMAIL PROTECTED] '
> Subject: Re: ODBC connects, but queries fail.
>
>
> Big Brother tells me that Sterin, Ilya wrote:
> > $driver = "driver={Microsoft Access Driver
> > (
On Thu, 10 May 2001, Dave VanAuken wrote:
> Radius authentication scenario... radius polls out to a perl script
> which checks against the postgres database for authentic
> information...
>
> we need to do an additional call out to a PHP file (sending it args if
> it cannot read the env[] args)
may seem like an odd one...
Radius authentication scenario... radius polls out to a perl script
which checks against the postgres database for authentic
information...
we need to do an additional call out to a PHP file (sending it args if
it cannot read the env[] args) and have its "text" outpu
Hi,
I'm trying to call a stored procedure that needs a "record type paramater".
I'm unclear as to how to pass the record data. The record data is a hash; I
believe i need to pass in just the values of the hash, as a flattened list
$reg_string.
Something like this?
my $proc = 'proc_name'
This is a known problem with registry access during global cleanup. Assign
undef to your handle variables ($dbh = $sth = undef;) after you
disconnect().
--
Mac :})
** I normally forward private database questions to the DBI mail lists. **
Give a hobbit a fish and he'll eat fish for a day.
Give a
Yeah sorry, but I had started preparing the message while I was making
adjustments on the fly, so was manually changing the script in the messge
rather than recopying . Bad error on my part sorry!. My actual script is
correct and has $sqlstatement. So it is not an empty string issue. Below
is
Aha. I see. Well, consider this an official plea to include
data_sources() in the next version. In fact, I extend that plea to all
DBD writers if any other driver doesn't support that method.
Thanks!
~chris
[EMAIL PROTECTED] wrote:
>
> Hi Chris, the CAVEATS file that came with DBD::DB2 lists t
DBD::Chart 0.40 is now available from either
CPAN or at http://home.earthlink.net/~darnold/dbdchart/.
Changes from 0.30:
- add Y-MAX and Y-MIN properties for barcharts
- fixed problem with last column definitions in CREATE TABLE
- fixed problem with FORMAT property
FYI: DBD::Chart is a Pe
Hi Chris, the CAVEATS file that came with DBD::DB2 lists that function as
unsupported. I'm planning on adding it in the next version.
Regards,
Robert
Chris Radcliff <[EMAIL PROTECTED]> on 10/05/2001 03:59:34 PM
To: [EMAIL PROTECTED]
cc:
Subject: DBD::DB2 and data_sources?
Hello,
I'm n
Sorry Guys,
I checked my .profile and there is a line that says:
PATH=$PATH:$ORACLE_HOME/bin; export PATH
Is there any other way to connect to the DB remotely than the onesused
below?
>From: "Julio Santiago" <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED]
>Subject: DB Connection (Dumb Question)
>D
Hello,
I am having a hard time trying to connect to a Oracle DB.
If I use:
my $dbh = DBI->connect('dbi:Oracle:', "$user/$passwd\@$sid", "", {
AutoCommit => 0, RaiseError => 1, PrintError => 1 }) or die "Can't
connect:$DBI::errstr";
the connection works fine and everything runs smooth.
When I
Hello,
I'm new to DB2, but I've been using DBI with Oracle, ODBC, and mysql for
quite a while.
I recently installed DB2 to test a customer's application, and I'm
running into a baffling problem. None of my DB2 databases show up when I
call DBI->data_sources("DB2").
I can connect() to my dataso
>From this...
$SQL = qq/INSERT INTO Respondent (england, relativity, lotr) VALUES
('$england', '$relativity', '$lotr')/;
#$SQL = qq|INSERT INTO Respondent (england, relativity, lotr) VALUES (?,
?, ?)|;
print qq/$SQL /;
# $sth = $dbh->prepare($SQL); my $sth = $dbh->prepare($sqlstateme
Mark,
Could you try rebuilding Perl and then use the new Perl to run Makefole.PL?
Mike
Mike Lacey
www.tek-tips.com -- a friendly, flame free, environment for computer
professionals and students
Perl forum at:
http://www.tek-tips.com/gthreadminder.cfm/lev2/4/lev3/32/pid/219
- Original Messa
I thought you said you were getting a lot of rows. If you are fetching more
than 100,000 or so all in one chunk (depending on the row size), you risk
running out of memory.
--
Mac :})
** I normally forward private database questions to the DBI mail lists. **
Give a hobbit a fish and he'll eat fis
This was using Perl 5.6.1 compiled from source using gcc. (We originally had a
depot version that must have been compiled using cc, but this gave all sorts of
problems since cc on this system is a junky non-ANSI C compiler.)
> "Ferré, Oscar" wrote:
>
> Hi Robert !!
>
> Do you have Perl 5.6.1 so
To whom it may convern:
I am running perl on a Win32 (WIN/NT 4.0 SP5) system. The version of perl I have is
ActiveState build 623 of the perl v.5.6.0 base.
I used ppm to install DBD-Oracle today. My copy of ppm is configured to use an
ActiveState server for pulling down modules. No error mess
Hi Michael,
I am addressing this problem directly to you.
I'm trying to connect to an Oracle 8.1.6 database using perl 5.6.0. My
Oracle client is 8.0.5.My DBI/DBD version is 1.13. OS is SUNOS 5.6.
Error message is given below:
install_driver(Oracle) failed: can't load
/usr/local/lib/perl5/site_per
I would
$dbh -> {RaiseError} = 1;
my $sth = prepare();
$sth -> execute( ... );
$sth -> bind_columns( \( ... ) );
while ( $sth -> fetch ) {
}
They are all described in the fine manual (perldoc DBI).
--
Mac :})
** I normally forward private database questions to the DBI mail lists
You might be surprised, check http://www.perl.org/ to see if there are any
local PerlMongers.
If you are using RPM to install Perl, you need to get your modules from the
same source. If you can't get DBI or the necessary DBDs from there, build
Perl yourself and then add any necessary modules.
-
I'm trying to connect to an Oracle 8.1.6 database using perl 5.6.0. My
Oracle client is 8.0.5.My DBI/DBD version is 1.13. OS is SUNOS 5.6.
Error message is given below:
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
Can you get mysql to work with its client tools, no dbi involved?
Can you get dbi to work without mysql, dbd::csv?
Does the version of perl you are using work with the version of dbi&dbd that
you are using?
have you considered freebsd, ports makes this stuff very easy?
marc
ps I do not hate l
I would like that you help.
I'm from brasil, and in Brazil don't have people that know how to use perl with mysql.
Than, I need to install DBI.
I do it:
First , i read this web page: http://www.lynxafrica.demon.co.uk/dbi/index.html then I
do it:
[root@servidor floppy]$ sh checkdbi.sh
If all is
Once you have associated a type with a placeholder in a statement, DBI
remembers the type, so you could do something like this (untested):
use DBI ( :sql_types );
# _Always_ check for errors
$dbh -> {RaiseError} = 1;
my $sth = $dbh -> prepare( ... );
# This value gets replaced in the
Thank you for the help. I think the problem
was the DSN name. Having switched off the response form in the script it
was coming back with an error in the dbi->connect line. I shortened the
DSN name to a single word. Having adjusted a couple of syntax errors the
script runs to the execute
Sure it work's..
If you have installed perl from active state
search for the modules to install and install it..
ppm> install DBI
ppm>install DBD-Oracle
that's it...
Good luck
Rajanath
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; <[EM
Hello,
I need to run this select statement:
select ISID.instr_id, ISDE.iss_desc from FT_T_ISID ISID, FT_T_ISDE ISDE
where ISID.ID_CTXT_TYP='BBTICKER' and ISID.instr_id=ISDE.instr_id
which invokation method should I use? ( it has to return a lot of records)?
Thank you
Daniel Rozengurtel
Analyst
Do you have an internet connection when you are doing this? Seems like you
either don't or you are behind a firewall.
Ilya Sterin
-Original Message-
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: 05/10/2001 9:59 AM
Subject: Install DBI on Window Me
Hi,
I tried to install p
M.W. Koskamp wrote:
>> I was missing
>> oci1.h
>> ociap.h
>> nzt.h
>> nzerror.h
>> oci8dp.h
>>
>> They were somewhere in the oracle tree, but not in the directories
contained
>> in the include path.
>> It's more likely to be an oracle then a DBD::Oracle problem.
The regular expression pattern
Hi,
I tried to install perl DBI on my lab top using PPM but failed. I am using
Window Me as my operating system and I have installed ActivePerl 5.6.620. When I
enter "install DBI" the following messages show up: "Error installing package
'DBI': could not locate a PPD file for package DBI".
Since you mentioned it was isolated to your CGI
scripts, I imagine you already know how to retrieve
the data, and Bodo Eing probably gave you the answer
you were looking for.
If not:
use DBD::Oracle qw(:ora_types);
$update_clob=$dbh->prepare(UPDATE table SET CLOB_FIELD
= ? Where ID="SOMEID")
- Original Message -
From: Foskett Roger <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, May 10, 2001 12:38 PM
Subject: DBD::Oracle Makefile.PL problem
>
> Hi - not sure who to direct this at
>
> I've just had a build problem where 'nzt.h' and 'ociextp.h' were missing
> duri
From: Henrik Tougaard <[EMAIL PROTECTED]>
To: Kevin Cornmell <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
Subject:RE: how do I insert a null value into an Ingres table ?
Date sent: Thu, 10 May 2001 13:58:27 +0200
> From: "Kevin Cornmell
Big Brother tells me that Sterin, Ilya wrote:
> Well are you using an ODBC client or are you trying to connect through
> DBD::Proxy? If you are using ODBC client for Linux I would imaging it would
> be the same, but if DBD::Proxy is used, then that's a different problem.
I am using unixODBC
Well are you using an ODBC client or are you trying to connect through
DBD::Proxy? If you are using ODBC client for Linux I would imaging it would
be the same, but if DBD::Proxy is used, then that's a different problem.
Ilya Sterin
-Original Message-
From: Jack McKinney
To: '[EMAIL PROT
Big Brother tells me that Sterin, Ilya wrote:
> $driver = "driver={Microsoft Access Driver
> (*.mdb)};DBQ=C:/databases/products.mdb";
> $dbh = DBI->connect("dbi:ODBC:$driver");
I am running this script on a linux box. This driver string looks like
what one might use on a windoze system...
-
$driver = "driver={Microsoft Access Driver
(*.mdb)};DBQ=C:/databases/products.mdb";
$dbh = DBI->connect("dbi:ODBC:$driver");
Ilya Sterin
-Original Message-
From: Jack McKinney
To: [EMAIL PROTECTED]
Sent: 05/10/2001 7:04 AM
Subject: Re: ODBC connects, but queries fail.
Big Brother tells
Big Brother tells me that Sterin, Ilya wrote:
> Then you need to read perldoc DBD::ODBC to familiarize yourself with the
> syntax.
perldoc DBD::ODBC is extremely short. It just says:
-
NAME
DBD::ODBC - ODBC Driver for D
Then you need to read perldoc DBD::ODBC to familiarize yourself with the
syntax.
Ilya Sterin
-Original Message-
From: Jack McKinney
To: [EMAIL PROTECTED]
Sent: 05/10/2001 7:04 AM
Subject: Re: ODBC connects, but queries fail.
Big Brother tells me that Neil Lunn wrote:
> Jack,
>
> Just a
If you have ActiveState perl, first uninstall the DBD::Oracle driver, then
install DBD::Oracle8 driver. I don't believe you can have both, but maybe
I'm wrong. When using dbi:Oracle:* it needs to know to use the Oracle OCI8
driver. Use ppm to perform above tasks.
Ilya Sterin
-Original Mes
Big Brother tells me that Neil Lunn wrote:
> Jack,
>
> Just as an extra check. What do you get if you fully qualify the DSN in the
> dbi connect string?
> (that is, a DSN'less connection) ie "dbi:ODBC:driver= 'etc'"
I am not familiar with this syntax. I have used MySQL with DBI before,
but
Big Brother tells me that Michael A. Chase wrote:
>
> ### You connected to 'TEST' from isql, not 'TRACK'.
> ### Error checking on connect() is always a good idea, but
> ### didn't do it for prepare() or execute().
> ### Perhaps you should set $db->{RaiseError} = 1;
The TEST/TRACK was a typo.
From: "Kevin Cornmell" <[EMAIL PROTECTED]>
> I need to select * from x, and then insert into y (an
identical table on
> another database), nullvalues are
> causing me grief...
>
> Can somebody explain if you can do this with placeholders.
( if at all ).
>
> The message "Sorry NULLS not allowed u
Its in the fine manual (perldoc DBI). If this is unclear, please submit a
suggestion for improvement.
B
Undefined values, or C, can be used to indicate null values.
However, care must be taken in the particular case of trying to use
null values to qualify a C statement. Consider:
SELECT desc
All the pre-built modules that ActiveState distributes using PPM were built
to run in Win32. The only difference between DBD-Oracle and DBD-Oracle8 is
the OCI version they were compiled against.
--
Mac :})
** I normally forward private database questions to the DBI mail lists. **
Give a hobbit a
Hi - not sure who to direct this at
I've just had a build problem where 'nzt.h' and 'ociextp.h' were missing
during make.
This occured as the find_headers() function in Makefile.PL did not RE match
the files and so does not return 'rdbms/public' as an include path (building
on HPUX11).
I there
Dear all,
I need to select * from x, and then insert into y (an identical table on
another database), nullvalues are
causing me grief...
Can somebody explain if you can do this with placeholders. ( if at all ).
The message "Sorry NULLS not allowed unless TYPE defined" is trying to tell
me some
From: Neil Lunn <[EMAIL PROTECTED]>
To: "'Sterin, Ilya'" <[EMAIL PROTECTED]>,
Neil Lunn <[EMAIL PROTECTED]>,
'Trevor Webster' <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
Subject:RE: Problem with DBI and Access newbie
Date sent:
Subject:Oracle CLOBs through DBI through CGI.pm don't work?
To: [EMAIL PROTECTED]
From: [EMAIL PROTECTED]
Date sent: Wed, 9 May 2001 18:36:12 -0400
jc,
your environment is far beyond my experience, but
>
> DBI v1.14, DBD::Orac
63 matches
Mail list logo
