Consultor Eletrônico



Kbase 16107: Documentation Error for Connection to ORACLE with SQL*Net
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   6/8/2005
Status: Unverified

FACT(s) (Environment):

Progress 7.x
Progress 8.x

SYMPTOM(s):

Documentation error for connection to ORACLE with SQL*Net

ORACLE DataServer Guide for V7 and V8

FIX:

The ORACLE DataServer Guide for V7 and V8 is incorrect in describing how to connect to an ORACLE database with SQL*Net V1.1 or V2.

This documentation error is seen in topics 3.5.3, 4.3.2, and 5.2 for the Version 8 ORACLE DataServer Guide, and in topics 3.6.3, 4.4.2, and 5.2 for the Version 7 ORACLE DataServer Guide.

You should follow the general syntax (regardless of SQL*Net, Progress Networking or local connection).

pro schema-holder-name -1/-RO <other schema holder params>
-db ora-dbname -dt ORACLE -U oracle-userid -P oracle-password
<other connection parameters to ORACLE>

-1/-RO means you should use -1 if you intend to change the schema
holder, or -RO if you just want to use the schema holder.

If you want to use SQL*Net use:

-U oracle-userid@connection-string -P oracle-password,

where the connection-string is the SQL*Net connection string appropriate to your SQL*Net configuration.