On 2001-05-23, "Eliu Montoya" <[EMAIL PROTECTED]> wrote:
> Can somebody tell me what can i do to connect my perl program with
> Progress database? The problem is that when Im trying to connect to
> this database with DBI::ODBC and DBI::ADO an error occur and im not
> quite sure what can I do.
Yo
Hi,
you need an account for the other system/user.
Darrell
On Wed, 23 May 2001, Jones Robert Contr 81 CS/SCK wrote:
>
>
> We have Oracle version 8 loaded on Windows NT boxes. We also have
> ActiveState Perl build 522 installed with DBI 1.14 and DBD-Oracle 1.03.
>
> The problem
We have Oracle version 8 loaded on Windows NT boxes. We also have
ActiveState Perl build 522 installed with DBI 1.14 and DBD-Oracle 1.03.
The problem we are having is that on one NT server everything runs
fine. The Perl program does its thing and connects to the Oracle database
an
Can somebody tell me what can i do to connect my perl program with Progress
database?
The problem is that when Im trying to connect to this database with
DBI::ODBC and DBI::ADO an error occur and im not quite sure what can I do.
Any help I will apprecciated so much!
Eliu Montoya M.
Ingeniero de
Same as Perl and DBI. If you do release it in a distribution, drop me a note please.
Tom
On Wed, May 23, 2001 at 11:01:07AM -0400, Paul W. Roach III wrote:
> I was wondering if you could tell me what license DBD::ADO is distributed
> under.
How about putting the -- (space) above this as a sig
I cannot get a persistent connection through my Proxy Server...I thought I had
this fixed by setting a timeout value, but that was evidently a one time thing.
I am Using DBIProxy and DBI:W32ODBC:DBNAME to connect to an MSSQL server.
When attempting to connect I get:
DBI->connect(hostname=eddie;p
I usually code that as:
foreach ( @ar1, $var1, $var2, @ar2 ) { $_ = '' if ! defined $_; }
TMTOWTDI!
The undef values generally don't cause trouble unless you are interpolating
them into a string. Unfortunately, I frequently do that with most
variables, so I generally convert undef to '' for va
Suggestion: "Don't do that." :}b
Read up on %SIG in 'perldoc perlvars'. If you trap the signal and exit from
the signal handler, an END{} block can clean up. It mostly depends on
whether the signal can be trapped.
Without more details it is hard to be more specific.
--
Mac :})
** I normally fo
That answer is fine if you are planning to do other things in the PL/SQL
block beyond the select.
# in a block: (note that '?' type placeholders also work)
# The variable $vbb_ver_nr won't be interpolated inside q{}.
# I replaced it with a placeholder.
my $sth = $dbh->prepare(q{
BEGIN
I don't think anyone helped on this yet...
You should connect with 'RaiseError' set, that
will cause the program to fail with a message if a DBI
error is encountered.
You are not currently doing any checking on your
DBI statements.
See the DBI docs.
-Original Message-
From: Krung Saeng
You don't (well, I don't anyway) get an error, you get a
warning message when warnings (-w or 'use warnings') are
enabled and you print or otherwise try to access the variables
(except in certain ways like with the defined() function or in
boolean context).
If you have an array of values, and you
Greetings-
Has anyone gotten Perl DBI and DBD::Sybase to run successfully under Netscape
Enterprise 3.13 and Solaris 2.5.1? I have tried everything that was suggested to me
but I still get invalid header errors when trying to connect through the web page.
However, when I run the perl script
I am running Oracle 8.0.5, Perl 5.005_03, DBI 1.14, and DBD Oracle 1.06 on
Red Hat Linux 6.2 and that is how it works here. If you have a different
setup, it may work differently.
I have many Perl DBI scripts running against my database, and in every
instance where a null is returned, the Perl v
I changed my dsn to use ALL CAPS on the DBI spec (just as a hunch..although the
man page I have shows dbi: instead of DBI:, and I got further...but I get the
following:
DBI->connect(hostname=eddie;port=3334;;dsn=DBI:W32ODBC:PLAY;) failed:
Constructor didn't return a handl: at /bin/sync_v1.pl l
Rubin, Shari writes:
>
> Does anyone know when/if a production version of DBD:Sybase will be
> released? My sys admins will not let me use DBD:Sybase since the README says
> "BETA".
I expect to have 1.00 released later this year.
In the meantime, if your sysadmins really won't let you inst
Hi -
Does anyone know when/if a production version of DBD:Sybase will be
released? My sys admins will not let me use DBD:Sybase since the README says
"BETA".
Thanks -
because i want to remember un array of nbr lines (of insert) who failed, to correct
them and retry again.
thanks for your interest.
Mohammad Shoja a écrit :
> So why you want to put it in a transaction ?
>
> > I would like to know if it is possible whith DBI/postgresql to begin a transaction,
Hi,
I was wondering if you could tell me what license DBD::ADO is distributed
under.
Thanks!
Paul W. Roach III
Software Architect
WaveShare Communications
703-626-3669
[EMAIL PROTECTED]
This message is intended solely for the designated recipient, may contain
privileged or confidential informa
This is a bit off topic, but I felt I must mention it. Core SQL99 requires a
standard conforming DBMS to implement either embedded SQL or a modul
language (hope this is the technical correct translation of German
"Modulsprache"). The module language must have a "SELECT INTO" command and
the semant
So why you want to put it in a transaction ?
On Wed, 23 May 2001, Hicham BOUZDAD wrote:
> Hi everybody,
>
> I would like to know if it is possible whith DBI/postgresql to begin a transaction,
> do some inserts,
> and commit even if somme of the inserts failed ?
>
> thanks for your help
>
---
Hi everybody,
I would like to know if it is possible whith DBI/postgresql to begin a transaction,
do some inserts,
and commit even if somme of the inserts failed ?
thanks for your help
Yes, MS Access uses "SELECT ... INTO to put the results into another table; I
can't remember for sure, but I think it actually creates the table, like an
Access 'Make Table' query, rather than just inserting into an existing one. And
to add to the confusion, MySQL uses SELECT ... INTO OUTFILE '
It looks like there's some confusion over SQL syntax here. Is there a
database which allows you to effect an insert into a table by doing a
'select ... into ' ?
Oracle certainly doesn't and if Peter's using Oracle then what he suggests
should (and does) work fine. Having said that TIMTOWTDI :) .
Hello peoples,
We are having an interesting problem. We are using DBI-1.14 with
DBD::Oralce 1.06 and when a script is cancelled while there is an active DBI
connection we sometimes end up with cursors left over. We are connecting to
a Oracle-8.1.7 database on Tru64 5.1a. Any hints or help much
What Steve says is exactly what I want, and the code
my $sth = $dbh->prepare(q{
BEGIN select vtr_id into :1 from t_vertraege
where vtr_nr='$vbb_ver_nr';
END;
});
works very well...
-Ursprüngliche Nachricht-
Von:
I think he's trying to use it as a PL/SQL variable -- not
a table name. As in this block of PL/SQL code in the
DBD::Oracle docs:
FUNCTION func_np
RETURN VARCHAR2
IS
ret_val VARCHAR2(20);
BEGIN
SELECT USER INTO ret_val FROM DUAL;
RETURN ret_val;
Wouldn't you want to use a variable here instead of a placeholder ??
my $sth = $dbh->prepare(q{
BEGIN select vtr_id into $cursor from t_vertraege
where vtr_nr='$vbb_ver_nr';
END;
});
-Original Message-
From: Bart Lateur [mailto:[EMAIL PROTECTED]]
Sent: Wednesday
On Wed, 23 May 2001 16:02:00 +0200, [EMAIL PROTECTED] wrote:
>What I wanted is:
>
> my $sth = $dbh->prepare(q{
>BEGIN select vtr_id into :1 from t_vertraege
> where vtr_nr='$vbb_ver_nr';
>END;
> });
You may turn this around as much as you like, but you're still trying to
do somet
What I wanted is:
my $sth = $dbh->prepare(q{
BEGIN select vtr_id into :1 from t_vertraege
where vtr_nr='$vbb_ver_nr';
END;
});
my $vtr_id;
$sth->bind_param_inout(1, \$vtr_id, 10);
$sth->execute;
Thanks for your help,
Peter
-Ursprüngliche Nachricht-
Well, that's not true. This is not C/C++ and an undefined value will print
nothing with no error.
Ilya Sterin
-Original Message-
From: Caraway, Michael
To: '[EMAIL PROTECTED]'; [EMAIL PROTECTED]
Cc: DiGiovanni, Jim
Sent: 05/23/2001 6:39 AM
Subject: RE: Newbie Q. : fetchrow_array.
When
On Wed, May 23, 2001 at 03:49:02PM +0200, [EMAIL PROTECTED] wrote:
> Hmmm Actually I wanted to use the PL/SQL select into statement to get
> the resulting value into a variable... Probably have to use something like
> "BEGIN...END" to indicate it is PL/SQL
You're trying to get the value i
[EMAIL PROTECTED] wrote:
> my $sth = $dbh->prepare("select vtr_id into ? from t_vertraege " .
> "where vtr_nr='$vbb_ver_nr'");
As far as I know, it is simply no possible to bind a table name as a
parameter. You have to write table names literally into the query,
respect
Hmmm Actually I wanted to use the PL/SQL select into statement to get
the resulting value into a variable... Probably have to use something like
"BEGIN...END" to indicate it is PL/SQL
Thanks for your hint,
Peter
Hi
you can't bind table names etc., only values e.g.
Hello,
it seems I am too stupid to properly bind a variable. The docs did not
really help me...
What I want to do, is something like:
my $sth = $dbh->prepare("select vtr_id into ? from t_vertraege " .
"where vtr_nr='$vbb_ver_nr'");
my $vtr_id;
$sth->bind_param_inout(1,
Thank you - problem solved.
- Original Message -
From: "Sterin, Ilya" <[EMAIL PROTECTED]>
To: "Tim Scott" <[EMAIL PROTECTED]>; "DBI Users" <[EMAIL PROTECTED]>
Sent: Wednesday, May 23, 2001 1:20 PM
Subject: RE: :Oracle on Solaris8 / Oracle 8.1.6
> Downgrade to DBI 1.14 and recompile DBD:
When a row of data is returned, some of the fields may be null. If so,
trying to print the field results in an error because you are accessing an
undefined value. Check the values first (if defined) before using them.
Michael
-Original Message-
From: Krung Saengpole [mailto:[EMAIL PROT
In your connect string, connect as the user 'Admin' like so:
$dbh = DBI->connect('dbi:ODBC:myDSN', 'Admin','');
As far as I can recall, Admin is the default user if you haven't done anything
special to secure the database to require users to log on. If you don't log in
as Admin, then you'll ge
Downgrade to DBI 1.14 and recompile DBD::Oracle. It's a know bug.
Ilya Sterin
-Original Message-
From: Tim Scott [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 23, 2001 7:59 AM
To: DBI Users
Subject: DBD::Oracle on Solaris8 / Oracle 8.1.6
Hi,
I'm having troubles with the plsql.t tes
Hi,
I'm having troubles with the plsql.t test #55 (executing a cursor returning
a column to a bound record set).
Does anyone know if this will work on Solaris 8 with Oracle 8.1.6.0.0 ?
Alternatively:
Can anyone spare some time to examine the 25k/610 line output of:-
make realclean
perl Makefil
Add error checking to your code. The easiest way is in the connect
statement:
my $dbh = DBI->connect( 'dbi:ODBC:myDSN, '','', {PrintError => 1,
RaiseError => 1} ) or die $DBI::errstr;
or check each statement.
Suggestion, review perldoc DBI.
Tom
On Wed, May 23, 2001 at 02:46:56PM +0700, Krung
Hello all,
I just start to learn dbi and have a problem with it. I use dbi to connect to Access
database and fetch the data to array 'til end of file.
But it only showed 2 lines of data and error took place. No error code or message
shown the reason why. My code is:
use DBI;
$dbh = DBI->conne
41 matches
Mail list logo
