/php_troubleshooting_faq.html
which may help you.
cheers
- Original Message - From: "Darrell Oresky" <[EMAIL PROTECTED]>
To:
Sent: Wednesday, September 12, 2007 8:46 PM
Subject: DBD-Oracle Connection Problem
I am having a problem using DBD-Oracle.
Basic problem - I can only get a
OTECTED]>
To:
Sent: Wednesday, September 12, 2007 8:46 PM
Subject: DBD-Oracle Connection Problem
I am having a problem using DBD-Oracle.
Basic problem - I can only get a connect to work when I fully
specify the connect string, i.e.
"dbi:oracle:host=xxx;port=yyy;sid='zzz'
I am having a problem using DBD-Oracle.
Basic problem - I can only get a connect to work when I fully
specify the connect string, i.e.
"dbi:oracle:host=xxx;port=yyy;sid='zzz'
Environment:
Remote connection
Server side - Solaris 9, Oracle 9.2.0.4.0
Client side - Solaris 10 i86pc, Oracle
On 02/02/07 19:50, Terry Maragakis wrote:
I am having a problem establishing a connection with my database.
The following connection specification in my program
$dbh = DBI->connect("DBI:Oracle:D102L",'scott/tiger','');
Is giving me the error:
DBI connect('D102L','scott/tiger',...) failed: O
]
Sent: Friday, February 02, 2007 3:44 PM
To: Terry Maragakis; dbi-users@perl.org
Subject: RE: DBD Oracle connection problem
I saw the warnings, but I don't think they are a problem.
Are you the same user when you execute the Perl program and the sqlplus
command? If not, do you have
riday, February 02, 2007 1:16 PM
To: Reidy, Ron; dbi-users@perl.org
Subject: RE: DBD Oracle connection problem
I am confused too.
My tnsnames.ora file is fine. I did try sqlplus and tnsping, they both
work. Also, if I do not specify the database name (ORACLE_SID is set to
'D102L') the
t;DBI:Oracle:",'[EMAIL PROTECTED]','tiger');
I did get a warning during compilation (see my original email) that may
be related to the problem.
-Original Message-
From: Reidy, Ron [mailto:[EMAIL PROTECTED]
Sent: Friday, February 02, 2007 2:01 PM
To: Terry Maragakis;
y, February 02, 2007 12:50 PM
To: dbi-users@perl.org
Subject: DBD Oracle connection problem
I am having a problem establishing a connection with my database.
The following connection specification in my program
$dbh = DBI->connect("DBI:Oracle:D102L",'scott/tiger',
"Terry Maragakis" <[EMAIL PROTECTED]>
To:
Sent: Friday, February 02, 2007 2:50 PM
Subject: DBD Oracle connection problem
I am having a problem establishing a connection with my database.
The following connection specification in my program
$dbh = DBI->connect("DBI:
I am having a problem establishing a connection with my database.
The following connection specification in my program
$dbh = DBI->connect("DBI:Oracle:D102L",'scott/tiger','');
Is giving me the error:
DBI connect('D102L','scott/tiger',...) failed: ORA-12154: TNS:could not
resolve th
Hello,
Does anybody have any ideas on the following problem? If not, does
anybody know where I could look for a solution?
Thanks,
Brandon
-Original Message-
From: Brandon Day
Sent: Thursday, August 25, 2005 10:27 AM
To: dbi-users@perl.org
Subject: DBD: db_login/SQLConnect err=-1 with u
I am experiencing an annoying problem getting an DBD::ODBC connection
(via unixODBC) working from a client machine A (Suse linux) to a an
ADABAS-D-11 database running on a remote machine (B, also Suse linux)
-- Machine A (client)
Linux 2.6.8-2
Perl: 5.0080
Hi All,
Thanks for all the information.
d7_bilab03 is actually an net alias on a development m/c to database
instance on bilab03 (test machine).
Initially, we thought our problem may have been because of up gradation
from oracle 8i to oracle 9i (this was on a development machine), but we
were not s
Hi All,
Thanks for all the information.
d7_bilab03 is actually an net alias on a development m/c to database
instance on bilab03 (test machine).
Initially, we thought our problem may have been because of up gradation
from oracle 8i to oracle 9i (this was on a development machine), but we
were n
Hi,
I'm trying the access oracle through perl, but am getting the error
"ERROR OCIEnvInit".
My perl script is:
-
use DBI;
$ENV{ORACLE_HOME}='/data/oracle/product/9.2.0';
my $dbh = DBI->connect("dbi:Oracle:d7_bilab03","hpbi_ow
:07 AM
To: [EMAIL PROTECTED]
Cc: Sandeep Warikoo; DBI-Users
Subject: Re: Oracle-Perl Connection Problem
This discussion belongs on the DBI users list (dbi-users@perl.org), so
I'm sending this response there instead of to oracle-oci.
> On Tuesday 04 January 2005 09:47, Sandeep Warikoo wro
This discussion belongs on the DBI users list (dbi-users@perl.org), so
I'm sending this response there instead of to oracle-oci.
On Tuesday 04 January 2005 09:47, Sandeep Warikoo wrote:
I'm trying the access oracle through perl, but am getting the error
"ERROR OCIEnvInit".
My perl script is:
-
"Andy Hassall" <[EMAIL PROTECTED]> writes:
> David Sacks wrote:
>
> > The short - there is not a DBD:Oracle client that currently works
> > with the 9i Oracle drivers, however you the current DBD:Oracle still
> That's not really true. DBD-Oracle does work with 9i client libraries, I've
> been ru
David Sacks wrote:
> The short - there is not a DBD:Oracle client that currently works
> with the 9i Oracle drivers, however you the current DBD:Oracle still
> works with the Oracle 8i client drivers with are fully compatible
> with talking with a 9i server.
That's not really true. DBD-Oracle doe
Ressegger
-Original Message-
From: David Sacks [mailto:[EMAIL PROTECTED]
Sent: Monday, June 02, 2003 1:19 PM
To: [EMAIL PROTECTED]; 'Michael A Chase'; [EMAIL PROTECTED]
Subject: RE: Connection Problem
Naveed,
The short - there is not a DBD:Oracle client that currently works with t
'Michael A Chase'; [EMAIL PROTECTED]
Subject: RE: Connection Problem
Hi Mac,
Thanks for your reply. But we've re-installed DBD::Oracle 1.14 and still
getting the same error. Could you tell me which version of DBD will work
with Oracle9i
Thanks and Regards
Naveed
-Original Me
ne 02, 2003 2:47 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: Connection Problem
On Mon, 2 Jun 2003 12:35:48 +0500 Naveed Anwer <[EMAIL PROTECTED]>
wrote:
> Recently we shifted to Oracle9i from Oracle8.1.7 on Solaris platform.
> We
> have some perl scripts which connec
On Mon, 2 Jun 2003 12:35:48 +0500 Naveed Anwer <[EMAIL PROTECTED]> wrote:
> Recently we shifted to Oracle9i from Oracle8.1.7 on Solaris platform.
> We
> have some perl scripts which connects with the database using DBI. After
> migration to Oracle9i perl scripts fail to connect using DBI and giv
Hi,
Recently we shifted to Oracle9i from Oracle8.1.7 on Solaris platform. We
have some perl scripts which connects with the database using DBI. After
migration to Oracle9i perl scripts fail to connect using DBI and give
following error "DBI->connect() failed: ERROR OCIEnvInit". I've checked all
Answered my own question.
>$dbh = DBI->connect("dbi:Oracle:dbdev1.mydomain.com:",
The colon at the end was a typo. When fixed, "ORA-12154" showed up.
> $ENV{ORACLE_HOME} = "C:\oracle\ora81";
Big duh. Those backslashes were escaping ("\o") twice.
Lessons learned: turn on warnings, and don't
On WinNT (service pack 6) I've installed:
ActiveState Perl 5.8 (805)
DBI 1.32 and DBD Oracle 1.12 from the ppd's at http://xmlproj.com/PPM/
When running a test connection script (see below) I get "Error while
trying to retrieve test for error ORA-06401"
I'm running against Oracle 8i (8.1.7). Whe
Your connection string does notappear to be DBI friendly. You might want
to try something like this:
$ENV{"ORACLE_HOME"}="/path/to/your/oracle/home";
$dbh=DBI->connect("DBI:Oracle:host=oraclehost.yourdomain.com;sid=database","username","password");
that connect string works for under activestate'
I have perl installed under Windows 2000.
The following command works under SQLPLUS:
SQL> connect user/psswrd@(DESCRIPTION = (ADDRESS_LIST = (ADDRESS =
(PROTOCOL = TCP)(HOST = srvr.domain.com)(PORT = 1521)))(CONNECT_DATA =
(SERVICE_NAME = db1dev.domain.com)))
Connected.
SQL>
However, connections
[snip]
>
> C:\Inetpub\scripts\brian\lbc>perl mx.pl id=123
> DBI connect('driver={SQL
> Server};Server=XXX.XXX.XXX.XXX,1433;database=LBC_research_
> test;uid=NALD_Admin;pwd=XX;','',...) failed:
> [Microsoft][ODBC SQL Server Driver]Client unable to
> establish connection (SQL-08001) [Mi
DBI::dr=HASH(0x1c9f2d0) ignored (inner handle gone)
--- END ---
Can anyone decipher those messages? =)
Thanks again for your help!
-Brian
> -Original Message-
> From: PARLEY,THUNDER (HP-MountainView,ex1) [mailto:[EMAIL PROTECTED]]
> Sent: Monday, January 13, 2003 5:05 PM
> To: '[EMAIL PROTECTED]'
> Subject: RE: Odd Connection problem with DBD::ODBC, MS SQL 2000 and
IIS on
> Win2k
>
> Hi Brian,
>
> I recommend you turn on the tracing in the DBI (see the docs) and try
> running from the command line on the production box.
>
> --Thunder
http://www.gordano.com - Messaging for educators.
>
> Hello all,
>
> Sadly, I don't like how this question goes, but I'm at the
> end of my rope -- please bear with me :)
>
> I've created a simple script, which uses a DSN-less
> connection to grab some data from an MS SQL 2000 server and
> display it as XML. No big deal. I've installed Perl,
Hello all,
Sadly, I don't like how this question goes, but I'm at the end of my
rope -- please bear with me :)
I've created a simple script, which uses a DSN-less connection to grab
some data from an MS SQL 2000 server and display it as XML. No big deal.
I've installed Perl, DBI, DBD::ODBC and II
HI all:
When I am trying to connect to oracle by
my $dbh = DBI->connect("dbi:Oracle:test", "scott", "tiger");, I get the
following error
DBI->connect(gldba) failed: ERROR OCIEnvInit at db_connect.plx line 10
What does this mean? Can anybody help me out.
Thanx
Viji
On Fri, May 24, 2002 at 05:07:45PM +, Will K. wrote:
> They are just 500 Errors, but I C&P'd them below anyway.
>
> Internal Server Error
>
> [snip]
>
> More information about this error may be available in the server error log.
Ah. We will need the actual error messages, from the server
They are just 500 Errors, but I C&P'd them below anyway.
Internal Server Error
The server encountered an internal error or misconfiguration and was unable
to complete your request.
Please contact the server administrator, will and inform them of the time
the error occurred, and anything you m
On Fri, May 24, 2002 at 04:43:10PM +, Will K. wrote:
>
> I am trying to get an online database set up and running, but I keep getting
> error messages at login.
It would be much easier for us to help you if you provided us with the
error messages.
Ronald
Greets Folks,
I am trying to get an online database set up and running, but I keep getting
error messages at login.
Here are two sample scripts I have been running (both are from Paul DuBois'
book MySQL and Perl for the Web).
## SCRIPT 1 ##
#! /usr/bin/perl -w
# intro4.pl - generate
: Tuesday, February 05, 2002 8:15 AM
To: Fisher, James; '[EMAIL PROTECTED]'
Subject: RE: Oracle DBD connection problem...
If you are using DBI with Oracle on Windows machines you do not need to do
anything with environment variables. What you may want to do is check PPM
first and se
their
version 8. If this is the case then you will also need to install
DBD-Oracle8 to connect.
-Original Message-
From: Fisher, James [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 04, 2002 4:35 PM
To: '[EMAIL PROTECTED]'
Subject: Oracle DBD connection problem...
Hello
, James"
<[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, February 04, 2002 18:56
Subject: RE: Oracle DBD connection problem...
My path includes c:\oracle\ora9\bin
- Original Message -
From: "Fisher, James" <[EMAIL PROTECTED]>
To: <[EMAIL PROTEC
I knew I would leave out an obvious piece of information...
My path includes c:\oracle\ora9\bin
JF
-Original Message-
From: Michael A Chase
To: Fisher, James; [EMAIL PROTECTED]
Sent: 2/4/02 5:52 PM
Subject: Re: Oracle DBD connection problem...
What's in PATH?
--
Mac :})
** I nor
From: "Fisher, James" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, February 04, 2002 14:35
Subject: Oracle DBD connection problem...
I am having difficulty connecting to Oracle with DBI. Here is the
background info. I am running Windows 2000 client and server.
Hello all,
I am having difficulty connecting to Oracle with DBI. Here is the
background info. I am running Windows 2000 client and server. I am able to
connect fine to the oracle database via sqlplus. A tnsping also comes back
with the proper info. The oracle database also shows up fine when
Hi Jaswant-
I have attached my diffs against Apache::DBI v0.88. However, I do not
believe this will
fix your problem. There may be 2 sources of your problem that I can think
of. One is
that you specified a very long ping time out with
Apache::DBI::setPingTimeOut for your
oracle connection. Yo
Hi Craig,
I saw the following message on the DBI mailing list from you.
I have the same problem. I two connections to different databases - one
to oracle & other to MySQL. When the Oracle DB goes down, DBI never refreshes
the Oracle $dbh after the Oracle db come back up. I'm using persistent
45 matches
Mail list logo