-Original Message-
From: NYIMI Jose (BMB) [mailto:[EMAIL PROTECTED]]
Sent: Saturday, August 18, 2001 1:02 AM
To: '[EMAIL PROTECTED]'
Subject: Remote DB Connection
How I can connect to a remote Informix database ?
The database from which I would like to extract
data (a simple SQL
Greetings,
has someone experienced troubles with DBD::Proxy and bind_param function?
I'm trying to switch from DBD::Oracle to DBD::Proxy and everything was OK
but bind_param gives me an exception.
Here is the code snippet:
my $addr_id;
my $sth = $dbh-prepare(q{BEGIN :id :=
How 'bout giving the versions of DBI, DBD::Oracle that you're
using?
Oleg Mechtcheriakov [[EMAIL PROTECTED]] wrote:
Greetings,
has someone experienced troubles with DBD::Proxy and bind_param function?
I'm trying to switch from DBD::Oracle to DBD::Proxy and everything was OK
but
The main problem you might have with most Linux versions is that the Perl
you install as part of an installation kit (RPM with Redhat, I think) might
be compiled in an environment that isn't close enough to your local machine.
When you then try to compile DBI or DBD::Oracle, the compiler settings
OK,
good question.
DBI: 1.19
DBD::Oracle: 1.06 (which actually plays on the DB server side and seems to
be OK)
DBI::ProxyServer: 0.2004
DBD::Proxy: 0.2003
Perl: 5.6.1
Oracle: 8.0.6/Sparc Solaris (DB server)
BTW, it seems to me that the problem is with the way the parameters are
passed. I.e.
It seems that DBD::ODBC module works only with local databases, according to
the following document:
http://search.cpan.org/doc/JWIED/DBD-pNET-0.1003/pNET.pm
What you mean by third party ODBC software ?
Regards,
José
-Original Message-
From: Sterin, Ilya [mailto:[EMAIL PROTECTED]]
Ji, José,
most probably to setup ODBC You need a kind of client software to access
particular DB. For example, if You use Oracle it looks like that: Oracle DB
is running on server, Oracle client software (usially named as SQL*Net or
Net8, delivered with Oracle) is running on Your computer. ODBC
Hi everyone,
I'm trying to run the test program to connect to Oracle database, but it
gave me the following message:
Out of memory during large request for 1073745920 bytes at
/opt/perl5/lib/site_perl/5.6.0/PA-RISC1.1/DBD/Oracle.pm line 262.
Does any one know what causing this?
The query
Which configuration and version(s) of used SW?
Please... :-)
-Original Message-
From: Kong, Alan [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 20, 2001 5:48 PM
To: [EMAIL PROTECTED]
Subject: Does any one know what cause this DBD::Oracle problem?
Hi everyone,
I'm trying
I've run into a peculiar bug when running some code under mod_perl
that doesn't show up outside the mod_perl environment.
I have some insert code that looks like this:
my $sth = $dbh-prepare(q{insert into metadata (id, property, value)
values (?,?,?)}) or die
I'm trying to re-install DBD::Oracle, and on the make command, Im getting
the following error. Doers anyone know what this library is, and/or what I
can do to complete the make successfully? a complete console of the install
attempt follows
ld: fatal: library -lclntsh: not found
I also get
On Mon, Aug 20, 2001 at 02:16:13PM -0230, Chad House wrote:
: I've run into a peculiar bug when running some code under mod_perl
: that doesn't show up outside the mod_perl environment.
:
: I have some insert code that looks like this:
:
:
: my $sth = $dbh-prepare(q{insert into metadata (id,
From DBD::Oracle's Makefile.PL:
# This DBI must be installed before we can build a DBD.
# For those not using Dynamic loading this means building a
# new static perl in the DBI directory by saying 'make perl'
# and then using _that_ perl to make this one.
I did a DBI 1.19 install in my own dir
On Mon, 20 Aug 2001, Philip Molter wrote:
On Mon, Aug 20, 2001 at 02:16:13PM -0230, Chad House wrote:
: I've run into a peculiar bug when running some code under mod_perl
: that doesn't show up outside the mod_perl environment.
:
: I have some insert code that looks like this:
:
:
: my
The perlfaq's don't apply?
How do I keep my own module/library directory?
How do I add a directory to my include path at runtime?
Building DBI with
$ perl Makefile.PL PREFIX=/tmp/perl
and then DBD::Oracle with
$ env PERL5LIB=/tmp/perl/lib/site_perl/5.005/sun4-solaris \
perl Makefile.PL
Dave Halliwill wrote:
I'm trying to use DBI, along with DBD::Oracle to port an application,
and
alter it from using Informix (DBD::Informix, I believe).
When executing the DBI-connect statement, my Netscape Webserver is
giving
the following truncated message:
[17/Aug/2001:11:47:42]
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Fri, Aug 17, 2001 at 03:00:27PM -0400, Jeff Besecker wrote:
I have installed Oracle 9i on a RH 7.1 server. I have done a database
install to make sure I got all of the required files. I can connect to a
remote database using sqlplus. I
Hi,
I got the following error running test.pl after I installed DBI.pm.
test.pl
DBI test application $Revision: 10.6 $
Cannot find blib even in C:/usr/local/lib/../../../../..
DBI object version 1.14 does not match $DBI::VERSION 1.19 at
C:/usr/local/lib/DynaLoader.pm line 219.
BEGIN
I am having problems of reading CLOB data out of Oracle using DBI/DBD. The
following is the environment:
Solaris 2.7
DBI-1.14
DBD-Oracle-1.06
Perl 5.00503
The table and its data:
SQL desc test_clob;
Name Null?Type
Could any provide any
assistance
I am trying to
upgrade my DBI to 1.18 and I kept getting the following error when I run
test.pl:
DBI object version 1.08 does not match $DBI::Version 1.18 at (a
path thatpoints to DynaLoader.pm) at line 185.
When I took at look
at the
Hi,
I wonder!.
Why does my insert depends of the column order??
Do any have any explanation??
In table t3, tt is text, and date is datetime.
I try to insert the following line:
change the '/' to '\' and the 'rm' to 'del' and am trying
(replaced with a teststring)
and a time stamp,
but the
-Original Message-
From: Kristian Knudsen [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 20, 2001 10:23 AM
To: [EMAIL PROTECTED]
Subject: Insert error
Hi,
I wonder!.
Why does my insert depends of the column order??
It doesn't, you can insert in any order you wish as long as
Allen,
It might help if you told people which version of perl you were using and
for which platform.
It seems like you statements though at least say something. You should never
run test.pl.
What you should be doing is:
perl Makefile.PL
make
make test
make install
as per the standard perl
Hi,
Right now, I am working on a dbcc perl script for a Sybase database. I
have noticed that I get a different output with dbi (do(do checkdb ...))
than with isql. What can I do to get the same output with dbi as with
isql. I plan to use the output to check the database for any kind of
I don't use DBI to do this, but this will work, and is how I normally do the
database maintenance jobs on my databases.
open (logfile, e:/tasks/${date}-maint.txt) || die $!;
# put other DB maint stuff here
# Use back-ticks to bring in the output of the command:
$str = `ISQL -Usa -P -QDBCC
This seems to work for me:
require DBI;
@ISA=qw(DBI DBI::db DBI::st);
use Carp;
use strict;
use warnings;
use diagnostics;
sub new {
my $pkg = shift;
my $class = ref($pkg) || $pkg;
my ( $db, $username, $password ) = @_;
my $dbh = $class-SUPER::connect(
'dbi:Oracle:' .
26 matches
Mail list logo