Oracle Database Connectivity
Kenn Baynton
bayntonk@ElectionsOntario.on.ca
Tue, 12 Aug 2003 11:03:54 -0400
This is a multi-part message in MIME format.
------_=_NextPart_001_01C360E2.F26934CC
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Ok, guys.. more questions.
I'm trying to connect to an Oracle database using PH 8.41C. I am using =
the following as my connect string.
Database EOMIS &
TYPE Oracle &
Owner EOMIS &
Null Values allowed &
Open ceo1dev@*****/********** =20
Username and password blanked out for security reasons. The =
documentation specifies that I can use a network parameter string, but I =
don't understand the functionality because it's referring to OpenVMS. =
What I have tried for the network parms doesn't have any effect.
Just so that you are aware, I am not connecting to a local database. I =
am attempting to reach a network db. The PH software will not be loaded =
onto the db server in any case, so this issue must be resolved. I can =
reach the db using SQL Plus and can search the database tables =
accordingly utilizing the same login/pass as I use in the connect =
string.
When I compile the dictionary, load it, and then attempt to access the =
files I get this warning and error:
*W* SQL START DBE error (EOMIS)
DMS-E-GENERAL, A general exception has occurred during operation 'attach
database'.
ORA-24327: need explicit attach before authenticating a user
*E* The Record SUPPLIER_PROFILE was not found in the data dictionary.
Do I need to specify in the dictionary every table in the db? My =
understanding is that PH treats the db as a subdictionary. How do I go =
about explicitly attaching the db, if such a step is truly required?
All help greatly appreciated.
Kenn
------_=_NextPart_001_01C360E2.F26934CC
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
6.5.6944.0">
<TITLE>Oracle Database Connectivity</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->
<P><FONT SIZE=3D2 FACE=3D"Arial">Ok, guys.. more questions.</FONT>
</P>
<P><FONT SIZE=3D2 FACE=3D"Arial">I'm trying to connect to an Oracle =
database using PH 8.41C. I am using the following as my connect =
string.</FONT>
</P>
<P><I><FONT SIZE=3D2 FACE=3D"Arial"> Database =
EOMIS =
=
=
=
=
=
=
&</FONT></I>
<BR><I> <FONT SIZE=3D2 =
FACE=3D"Arial">TYPE Oracle =
=
=
=
=
=
&</FONT></I>
<BR><I> <FONT SIZE=3D2 =
FACE=3D"Arial">Owner EOMIS =
=
=
=
=
=
=
&</FONT></I>
<BR><I> <FONT SIZE=3D2 =
FACE=3D"Arial">Null Values allowed =
=
=
=
=
=
&</FONT></I>
<BR><I> <FONT SIZE=3D2 =
FACE=3D"Arial">Open ceo1dev@*****/********** =
</FONT></I> =
=
<FONT SIZE=3D2 =
FACE=3D"Arial"> </FONT>
</P>
<P> <FONT SIZE=3D2 =
FACE=3D"Arial">Username and password blanked out for security =
reasons. The documentation specifies that I can use a network =
parameter string, but I don't understand the functionality because it's =
referring to OpenVMS. What I have tried for the network parms =
doesn't have any effect.</FONT></P>
<P> <FONT SIZE=3D2 =
FACE=3D"Arial">Just so that you are aware, I am not connecting to a =
local database. I am attempting to reach a network db. The =
PH software will not be loaded onto the db server in any case, so this =
issue must be resolved. I can reach the db using SQL Plus and can =
search the database tables accordingly utilizing the same login/pass as =
I use in the connect string.</FONT></P>
<P> <FONT SIZE=3D2 =
FACE=3D"Arial">When I compile the dictionary, load it, and then attempt =
to access the files I get this warning and error:</FONT>
</P>
<P><I><FONT SIZE=3D2 FACE=3D"Arial">*W* SQL START DBE error =
(EOMIS)</FONT></I>
<BR><I><FONT SIZE=3D2 FACE=3D"Arial">DMS-E-GENERAL, A general exception =
has occurred during operation 'attach</FONT></I>
<BR><I><FONT SIZE=3D2 FACE=3D"Arial">database'.</FONT></I>
<BR><I><FONT SIZE=3D2 FACE=3D"Arial">ORA-24327: need explicit attach =
before authenticating a user</FONT></I>
</P>
<P><I><FONT SIZE=3D2 FACE=3D"Arial">*E* The Record SUPPLIER_PROFILE was =
not found in the data dictionary.</FONT></I>
</P>
<P> <FONT SIZE=3D2 =
FACE=3D"Arial">Do I need to specify in the dictionary every table in the =
db? My understanding is that PH treats the db as a =
subdictionary. How do I go about explicitly attaching the db, if =
such a step is truly required?</FONT></P>
<P> <FONT SIZE=3D2 =
FACE=3D"Arial">All help greatly appreciated.</FONT>
</P>
<P><FONT SIZE=3D2 FACE=3D"Arial">Kenn</FONT>
</P>
</BODY>
</HTML>
------_=_NextPart_001_01C360E2.F26934CC--