Hi,
I am having some issues with the DBD::Oracle.
I'm running Perl 5.8.7 build 813 from active state on a win2k3 server.
I installed Oracle 9.2.0 client.
I then installed DBI and DBD::Oracle (1.16), which installs the oci.dll
as well as oraociei10.dll.
I can connect using sqlplus manually
the 9.2.0 client is set up correctly.
But the DBD:Oracle is using the 10g oci/client files. So now sure how
it's getting it's configuration information.
L
-Original Message-
From: Kong, Alan [mailto:[EMAIL PROTECTED]
Sent: Friday, December 30, 2005 12:02 PM
To: Mitchell, Louise M; dbi-users
Typo below...
'now sure' should be 'not sure'
L
-Original Message-
From: Mitchell, Louise M
Sent: Friday, December 30, 2005 12:03 PM
To: Kong, Alan
Cc: dbi-users@perl.org
Subject: RE: :Oracle - with ora10g oci.dll
I can connect via sqlplus and sqlplusw.
We don't use tnsnames.ora
the TNS_ADMIN env variable.
I'll look that env variable up (not familiar with that one) and set it
appropriately and see if that helps.
L
-Original Message-
From: Reidy, Ron [mailto:[EMAIL PROTECTED]
Sent: Friday, December 30, 2005 1:34 PM
To: Mitchell, Louise M; dbi-users@perl.org
Subject
Did anyone figure this one out? I am having the same issue, but don't
see a response to this initial posting.
I have oracle 8.1.7 client installed and the following:
Windows Server 2003
ActivePerl 5.8.7 build 813
DBI 1.49
DBD-Oracle 1.16
BTW, is anyone else having issues with PPM? Seems like
, 2005 2:19 AM
To: Mitchell, Louise M
Cc: Trivedi, Dhirendra; dbi-users@perl.org
Subject: Re: Perl-Oracle DBI module
On Tue, Sep 20, 2005 at 07:18:25PM -0700, Mitchell, Louise M wrote:
Oracle has some environment variables that are critical, such as
ORACLE_HOME, NLS_LANG, etc. It appears
Oracle has some environment variables that are critical, such as
ORACLE_HOME, NLS_LANG, etc. It appears that these are not set for the
user that is doing the install. Check with your Oracle DBA if you're
not familiar with these.
L
-Original Message-
From: Trivedi, Dhirendra
for any help,
Louise Mitchell
-Original Message-
From: Jeff Urlwin [mailto:[EMAIL PROTECTED]
Sent: Saturday, August 27, 2005 8:54 AM
To: Mitchell, Louise M; dbi-users@perl.org
Subject: RE: error string being lost in DBD::ODBC
Try checking your second $sth for more_results. It may
Hi All,
I'm following up on this problem since it's now my problem.
Does anyone have any ideas? I'm butting my head against a wall on this
one.
Thanks,
Louise Mitchell
**
The most recent code below:
#!d:\apps\perl\bin\perl.exe
use DBI;
use DBD::ODBC;
-Original Message-
From: Martin J. Evans [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 30, 2003 10:01 AM
To: Mitchell, Louise M
Subject: RE: [dbi] RE: succint view of problem - getting results from
DBCC INDEXDEFRAG - DBD::ODBC
Louise,
Martin, et.al.,
I seemed to be the only one in the list.
I
All,
Several days ago, I learned how to use the odbc_err_handler subroutine
provided by DBD::ODBC... in order to capture the 'message' spit out for
non-DDL/DML commands in a SQL Server, such as 'backup' or 'dbcc'.
The first batch of commands tested were a variety of backup commands and
then DBCC
:[EMAIL PROTECTED]
Sent: Thursday, December 11, 2003 11:19 AM
To: Mitchell, Louise M
Cc: [EMAIL PROTECTED]
Subject: Re: DBD::ODBC - SQL Server - odbc_err_handler - inconsistent
results
Louise,
[EMAIL PROTECTED] wrote:
All,
Several days ago, I learned how to use the odbc_err_handler subroutine
All,
I've posted bits of this earlier, but here is the problem in a
nutshell... the code below executes DBCC INDEXDEFRAG in a MS SQL
Server... I did some research on the 'invalid cursor state' that you'll
see below in the output... this command returns a result set, so I
realized I needed to
;
}
});
-Original Message-
From: Jenda Krynicky [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 09, 2003 05:36 AM
To: [EMAIL PROTECTED]
Subject: Re: SQL Server- DBD::ODBC - getting results not rows - question
about earlier post
From: Mitchell, Louise M [EMAIL PROTECTED
All,
In an earlier post inquiring about how to get the results ( such as from
a backup or dbcc ), rather than rows, the response pasted below
indicated a solution however, when I try this, I find that the
actual results are returning in STDERR, not in the variable $text
In my code, I
Well... this is not going to work... because the array will return the list, but
the sql requires commas between column names...
Are you sure this is the exact code... if the @array is in double quotes, you
should be okay..
See my little test script and results below...
#!/apps/perl/bin/perl
David,
I see now that the error references 'inc_sf' but your code references 'inc_re'
But still look at the other things I pointed out..You can use the join function
to add the commas.
L
-Original Message-
From: David Jacobowitz [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 26,
It's
this:
$dbh-func(dbms_output_enable);
Regards,
L
-Original Message-From: Loo, Peter # PHX
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, February 20, 2001
12:02 PMTo: [EMAIL PROTECTED]Subject: SET SERVEROUTPUT
ON
Hi
All,
I want to
set this environment on so
In Oracle, use database links...
L
-Original Message-
From: Dan Hopkins [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 12, 2001 8:30 AM
To: '[EMAIL PROTECTED]'
Subject: Hetrogenous joins
This may have an extremely obvious answer :) but I can't see it. Is it
possible to do
Jason,
The problem is not with the DBI, but with your Oracle connectivity.
The error you received means that your sqlnet configuration cannot figure out
what 'mingus' is... if you are using a tnsnames.ora, check that your entry for
that db is in place...if you are using names, check that the
20 matches
Mail list logo