I'm having a problem utilizing the perl DBI::Proxy to go between a
UNIX (Solaris)
and a Windows SQL server. We started getting an error message
Error while reading socket: Connection reset by peer at
/usr/local/lib/perl5/site_perl/5.6.1/RPC/PlServer/Comm.pm line 110.
that I can't seem to
Hello again,
I still have the problem to build a ODBC-Driver for Adabas.
I got a last chance to manage it with perl, next week I have to do it with c.
Im sure this has something to do with the bad installation of Adabas, but the
person who made this, is no longer available. So I have to fix it.
Jochen Wiedmann wrote:
I'm having a problem utilizing the perl DBI::Proxy to go between a
UNIX (Solaris)
and a Windows SQL server. We started getting an error message
Error while reading socket: Connection reset by peer at
/usr/local/lib/perl5/site_perl/5.6.1/RPC/PlServer/Comm.pm
I got somethink new,
a hint whats the fault with my odbc-driver.
The parser stops at:
typedef void FAR* PTR;
( /REFDB_HOME/referenz/adabas_d/include/isql.h:10: error: parse error before
'*' token
/REFDB_HOME/referenz/adabas_d/include/isql.h:10: warning: data definition has
no
H.
Is the resolved in 5.8 ?
Perl 5.6.1 on Win32 leaks socket handles - maybe that's the reason.
Windows Server - $VERSION = '1.012';
Unix Machine - $VERSION = '2.08';
-Original Message-
From: Steffen Goeldner [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 17, 2004 8:58 AM
To:
Hello,
I am working on a small script that pulls user metrics from databases on a number of
different servers and pushes them into a 'metrics warehouse' of sorts for use in trend
analysis among other things. I am having trouble with my insert statement and would
like some help from all of
Bart Kersteter [mailto:[EMAIL PROTECTED] wrote:
I am using this statement to try and insert the data:
*---
my ($userid, $year, $week, $cpu, $io);
$source_sth-bind_columns(\$userid, \$year, \$week, \$cpu, \$io);
my $insert_sql = qq{ insert
In the DBD::Oracle docs it states this:
==
If you use the host=$host;sid=$sid style syntax, for example:
$dbh = DBI-connect(dbi:Oracle:host=myhost.com;sid=ORCL, $user,
$passwd);then DBD::Oracle will construct a full connection descriptor string
for you and Oracle will not need to consult
Here's the full main loop script, I'm still relatively new to DBI, so I
may have messed things up a bit. I have gone through the perldocs a few
times.
my $db_list = new IO::File( /home/oracle/utils/metrics_db_list.txt)
or die Can't open oratab file;
while ($db_list) {
my @db_info =
I don't see anything glaringly wrong, and in fact I don't know why it's
not working for you. Maybe I'm just overlooking something, but why not
include the $orasid and $server as bind variables? Like this:
my $insert_sql = qq { insert into user_history_stats (database,
server, year, week,
On Tue, 17 Aug 2004, Bart Kersteter wrote:
Here's the full main loop script, I'm still relatively new to DBI,
so I may have messed things up a bit. I have gone through the
perldocs a few times.
Your understanding of DBI looks pretty good to me. I'm not sure
what's causing the bound variable
Naim Haldeda wrote:
Hi,
Thank you very much for the explanations,
No problem. In the future though, please reply to the mailing list
rather than to an individual - that way more people can learn from the
answers, and others are more likely to know about DBD::Oracle than I am.
I have 2 more
On Tue, Aug 17, 2004 at 10:24:00AM -0400, Robert wrote:
In the DBD::Oracle docs it states this:
==
If you use the host=$host;sid=$sid style syntax, for example:
$dbh = DBI-connect(dbi:Oracle:host=myhost.com;sid=ORCL, $user,
$passwd);then DBD::Oracle will construct a full connection
On Fri, Aug 13, 2004 at 11:17:51PM +0100, Alan Burlison wrote:
Tim Bunce wrote:
Does the binary protocol allow the link to be used for other actions while
there are still rows being sent to the client?
If not use result can't be the default as too much existing code would
break.
My
On Tue, Aug 10, 2004 at 12:01:48PM +0200, Leandro C. Hermida wrote:
Hello,
I am not sure if this is a bug but I have used DBI and DBD::Oracle
for a long time without any probllem and I am almost certain that
something might be wrong. Both modules are awesome and this is the
first time that
Thanks to all for your suggestions... I've finally gotten things working. The
following is a working example. The one issue I have left to handle is to add some
error chceking and parameterize a few things to make the script more transportable.
One little glitch is that the final fetch for
Taken of dbi-dev list as that's not the appropriate place.
I got somethink new,
a hint whats the fault with my odbc-driver.
The parser stops at:
typedef void FAR* PTR;
( /REFDB_HOME/referenz/adabas_d/include/isql.h:10: error:
parse error before
'*' token
Hi all- hopefully I'm not just repeating a problem everyone knows about, had
a search but not found much- anyhow:
Installing DBD::Oracle fails for me on generating the Makefile- it's related
to some manual modification of libclntsh required, which I believe I've done
correctly. Session and output
On Tue, 17 Aug 2004, Bart Kersteter wrote:
Thanks to all for your suggestions... I've finally gotten things
working. The following is a working example. The one issue I
have left to handle is to add some error chceking and parameterize
a few things to make the script more transportable.
I'm working on a PERL project at work, but my boss wants me to do just
enough in Pro*C that it won't integrate with my PERL designs.
Is anyone aware of any PERL/C extentions that allow Pro*C functions to
be called by PERL?
Thanks,
Ian
From: Bart Kersteter [EMAIL PROTECTED]
Date: 2004/08/17 Tue PM 03:06:53 GMT
my $db_list = new IO::File( /home/oracle/utils/metrics_db_list.txt)
or die Can't open oratab file;
while ($db_list) {
my @db_info = split(/:/);
my $orasid = $db_info[0];
my $server = $db_info[1];
May
Tim Bunce [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
On Tue, Aug 17, 2004 at 10:24:00AM -0400, Robert wrote:
In the DBD::Oracle docs it states this:
==
If you use the host=$host;sid=$sid style syntax, for example:
$dbh =
Howdy,
I have a script (attached) that creates an Access 2K database,
connects to it, creates a table, and pops some data into it. It all
works, no problem. However, I'm getting the following messages
on the console (CMD prompt):
Use of uninitialized value in subroutine entry at
From: amonotod [EMAIL PROTECTED]
Date: 2004/08/17 Tue PM 08:25:11 GMT
Use of uninitialized value in subroutine entry at C:/Perl/site/lib/DBI.pm line 595.
DBD::ADO::dr connect warning: at C:/Perl/site/lib/DBI.pm line 595.
Sorry, I didn't mean to forget:
OS: Windows 2000, SP4
Perl:
OCI::Oracle
--
Ron Reidy
Sr DBA
Array BioPharma, Inc
-Original Message-
From: Ian Harisay [mailto:[EMAIL PROTECTED]
Sent: Tue 8/17/2004 12:26 PM
To: [EMAIL PROTECTED]
Cc:
Subject:DBI, Oracle and Pro*C
I'm working on a PERL project at work, but my boss wants me to do
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Well it has finally happened. PG is native on Windows. Does anyone know if
DBD::PgPP will work with it or do I need to wait for an updated DBD?
DBD::Pg will work just fine against 8.0, although the soon-to-be-released
version (1.33) will have
Greg Sabino Mullane wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Well it has finally happened. PG is native on Windows. Does anyone know if
DBD::PgPP will work with it or do I need to wait for an updated DBD?
DBD::Pg will work just fine against 8.0, although the soon-to-be-released
On Aug 9, 2004, at 8:01 PM, Rudy Lippan wrote:
On Sat, 7 Aug 2004, Patrick Galbraith wrote:
As far as use_result vs. store result, the server prepared statements
(mysql 4.1 and greater) will always use 'store result', as this has no
affect on performance as per the API documentation.
I plan, if
I recently encountered some new info to add to an old thread to which I contributed.
Old Thread
Briefly I responded to a query someone made about generalizing WHERE clauses so that
you could use either NULL or non-NULL values to bind to parameterized ?'s. In other
words, you construct a
29 matches
Mail list logo