Hello,
I am using PostgreSQL in one of my Server.
But, now I need to communicate it with a Oracle
database via SQLNet (I think this is what I was
told of).
I have _very_ little (close to no) experience with
Oracle. So, how do I install Oracle's DBD* in my
Linux box, thus able to do some dat
Hi,
I am trying to call the DBI routines of perl from a C-program. Like this
eval_pv("use DBI;my $dbh =
DBI->connect('DBI:Oracle:mydatabase','scott','tiger')",TRUE);
It gives the following error while executing (compilation successful)
Error:
...
Can't load module DBI, dynamic loadin
-- Stephen Clouse <[EMAIL PROTECTED]>
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> On Wed, Oct 24, 2001 at 10:23:19PM -0500, [EMAIL PROTECTED] wrote:
>> Should be fairly simple: Configure a few locations w/in the
>> section of httpd.conf.
> [snip]
>
> Perhaps you're looking for [EMAIL
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wed, Oct 24, 2001 at 10:23:19PM -0500, [EMAIL PROTECTED] wrote:
> Should be fairly simple: Configure a few locations w/in the section
> of httpd.conf.
[snip]
Perhaps you're looking for [EMAIL PROTECTED]? This is the dbi-users list.
- --
Stephe
Should be fairly simple: Configure a few locations w/in the section
of httpd.conf. The code seems to run, exept that naming the first section
"/cdr/Data" gives me the output from Cdr::Welcome, rather than the Cdr::Data
module. Changing the name from "cdr/Data" to "cdr/Foo" in the config file
f
More info on the oraus.msb problem.
I saw this on dbi-dev about two years ago:
FROM: Tim BunceDATE: 10/28/1999 13:01:42SUBJECT: RE: oraus.msb being
reopened repeatedly *** From dbi-dev -- To unsubscribe, see the end of
this message. ***
On Thu, Oct 28, 1999 at 11:47:43AM -0400, Greg Stark
In article
<[EMAIL PROTECTED]>,
[EMAIL PROTECTED] (Ilya Sterin) wrote:
> Well post the script and we can look. Please eliminate the parts that are
> not relevant if you script is big.
it's about 255 lines of code incuding comments.. I'll remove the
comments from the file to shorten it a bit.
In article <[EMAIL PROTECTED]>,
[EMAIL PROTECTED] (Stephen Clouse) wrote:
> Having said all that, is this really on topic for dbi-users?
indeed it is, since the script in question is banking heavily upon DBI
and DBD::mysql to do the work.
--
Scott R. Godin| e-mail : [EMAIL PROTEC
Well post the script and we can look. Please eliminate the parts that are
not relevant if you script is big.
These benchmarks are a bunch of crap. There are 900 times more bytes
transfered. The files look way to much different in sizes. So we are yet
to see an exact comparison:-)
Ilya
-
Well I'm not a web developer, never used mod_perl, there is
the article on Perl.com describing how they built e-toys with
mod_perl. I think at the time it was the 3rd busiest web site
at the time. I don't know if the hardware even compares, but
you can take a look, if you haven't already.
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wed, Oct 24, 2001 at 05:25:12PM -0400, Scott R. Godin wrote:
> Document Path: /testbed/news2.php?executesearch=1
> Document Length:769 bytes
[snip]
> Document Path: /cgi-bin/simplesearch.cgi?searchfor=c
> Document Length:
In article
<[EMAIL PROTECTED]>,
[EMAIL PROTECTED] (Ilya Sterin) wrote:
> As much as I shouldn't say this, but run the script without the -w to get
> rid of this message, or define a __WARN__ handler.
>
> Ilya
or use
local $^W;
within the loop
--
Scott R. Godin| e-mail
here's a missive fired off by the site admin after he "benchmarked" two
scripts, one written in php and one written in perl/cgi
>
> First of all.
>
> Dude. you're out of your mind. Im serious.
>
> The WHOLE point about why PHP is faster than Perl is because the
> interpreter is compiled int
here's a missive fired off by the site admin after he "benchmarked" two
scripts, one written in php and one written in perl/cgi
>
> First of all.
>
> Dude. you're out of your mind. Im serious.
>
> The WHOLE point about why PHP is faster than Perl is because the
> interpreter is compiled int
How can I make calls to the odbc driver to tell it what encoding the client
is. So when perl dbi runs it will make the connection, it knows already
what the content encoding is, and needs to make a call to the odbc driver
what to convert the data to so odbc does not default to the locale setting.
Correction. Not every row - just once at the end of retrieving
all the rows. Still - how can I avoid it?
-Paul
> -Original Message-
> From: Paul G. Weiss
> Sent: Wednesday, October 24, 2001 2:30 PM
> To: '[EMAIL PROTECTED]'
> Subject: File read for every record retrie
I'm using DBD::Oracle to read records from an Oracle database.
It's Oracle 8.1.6.2, DBI version 1.15, DBD::Oracle version 1.07.
The platform is Solaris 2.7.
When trussing my Perl process, I've noticed the following lines
between every record retrieved:
open("/usr/oracle/product/8.1.6/rdbms/mesg/
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tue, Oct 23, 2001 at 11:46:41AM -0600, Sterin, Ilya wrote:
> Exactly why I am even having this issue. I can ofcourse switch to using one
> space, though varchar will still trim it. This is an annoying standard I
> must say:-)
>
> You are correct
As much as I shouldn't say this, but run the script without the -w to get
rid of this message, or define a __WARN__ handler.
Ilya
-Original Message-
From: Pierre Gilbert
To: [EMAIL PROTECTED]
Sent: 10/24/01 10:20 AM
Subject: Unwanted error message with DBD::CSV
Hello,
sub readDataObje
Hello,
sub readDataObject {
my $dir = shift;
my $table = shift;
my $dbh = DBI->connect("DBI:CSV:f_dir=$dir");
$dbh->{"csv_tables"}->{"$table"} =
{'eol'=>"\n",'file'=>"$table.csv"};
my $sth = $dbh->prepare("SELECT * FROM $table");
my $rv = $sth->execute;
return $sth;
}
I get the
> From: Wilson, Doug [mailto:[EMAIL PROTECTED]]
>
> It looks like Postgres has a bug with regard to placeholders
^^^ (I mean DBD::Pg)
> in the execute subroutine. it only checks for matching numbers
> of placeholders & arguments supplied IF you supply arguments
> to execute()
> From: Terrence Brannon [mailto:[EMAIL PROTECTED]]
> and have it $sth->execute(@ARGV)
>
> but I am able to get DBI to force an instructive error message when I
> forget to supply command-line arguments. Instead I get
> my $connect = 'dbi:Pg:dbname=mydb';
It looks like Postgres has a bug wit
sub valida_user
{
use DBI;
use DBD::Oracle qw(ORA_VARCHAR2);
my($db, $sth);
$ENV{ORACLE_HOME} = "/u1/oracle/product/8.0.5";
$db = DBI->connect("dbi:Oracle:host=my_ip;sid=fty", "hmo", "hmo")
or die "Unable to connect: $DBI::errstr";
$db->{RaiseError} = 1;
my $user=$_[0];
my
On Wed, Oct 24, 2001 at 12:38:50PM +0200, Bart Lateur wrote:
> On Wed, 24 Oct 2001 11:01:25 +0200, Wolfgang Weisselberg wrote:
>
> >insert into bar (foo,baz) values ('NULL', 'inserted string NULL');
> >insert into bar (foo,baz) values ( NULL , 'inserted (undefined) NULL');
> >
> >sele
I am trying to write something which opens this file called abstract.sql:
select city, date from weather where temp_lo < ?
and have it $sth->execute(@ARGV)
but I am able to get DBI to force an instructive error message when I
forget to supply command-line arguments. Instead I get
Databas
Hi Jonathan,
I have got your e-mail adres from the readme file from the
DBI::package.
We are using the Online DS 7.2 and the Dynamic Server 2000 on a
HP-UX 10.20/11.0 system. I'm also using perl in combination with
the DBI::package on the HP-UX system. This is all working fine.
Only now I wa
There is still my "Out of Memory" Problem using DBI 1.18, DBD 1.06 at
HP-UX 11.0. I've tried to reduce the ammount of selected data, but it's
exactly the same. Also the change of RowCacheSize doesn't effect the
result. Here is a short script to visualize whats going on:
---
use DBI
Hello
I am having problems compiling DBI v1.20 in Solaris 2.6. I am using gcc
compiler 3.0.1. I have attached a file which contains the output of my
attempt. Any help on how to solve the problem would be most welcome.
<>
(:=)Think Globally Act Locally(=:)
(-:
On Wed, 24 Oct 2001 11:01:25 +0200, Wolfgang Weisselberg wrote:
>insert into bar (foo,baz) values ('NULL', 'inserted string NULL');
>insert into bar (foo,baz) values ( NULL , 'inserted (undefined) NULL');
>
>select * from bar where foo = ?
>Try binding
>my $bindvar = "NULL";
>an
I notice from the docs that come with DBD-mysql-2.0902, and in
particular the Makefile.PL there is the warning:
print <<"MSG";
This is an experimental version of DBD::mysql. For production
environments you should prefer the Msql-Mysql-modules.
MSG
...and I notice that the last update was in
Sterin, Ilya <[EMAIL PROTECTED]> wrote:
> Within the where clause of the query that is prepared...'
> where foo = ?
> When binding an undef value when executing, this executes "where foo =
> NULL". In Oracle there is a difference between foo = NULL and foo is NULL.
> This also kind of disallow
31 matches
Mail list logo