I am using PB6.5 (build 444) and I've Installed Oracle client (Net8) 
v8.1.6 to connect to Oracle Server 8.1.6.

I can connect via SQL*Plus; however, When i try to connect thru 
Powerbuilder i get the following message:
"Error while trying to retrieve text for error ORA-12154"


Any help on this matter will be greatly appreciated.

Which driver are you trying to use?  The 7.x drivers require the '@' prefix,
the 8.x drivers don't (and will generate such an error message if you provide
it).

On Wed, 07 Mar 2001 16:40:13 -0500,
 in powersoft.public.powerbuilder.database
Suny <suny0143@netscape.net> wrote: 
>I am using PB6.5 (build 444) and I've Installed Oracle client (Net8) 
>v8.1.6 to connect to Oracle Server 8.1.6.
>
>I can connect via SQL*Plus; however, When i try to connect thru 
>Powerbuilder i get the following message:
>"Error while trying to retrieve text for error ORA-12154"
>
>
>Any help on this matter will be greatly appreciated.
>

Bruce Armstrong [TeamSybase]
http://www.needhim.org

---== Posted via the PFCGuide Web Newsreader ==---
http://www.pfcguide.com/_newsgroups/group_list.asp

To be in synch, how do i determine for sure which driver is being used?
I followed your advice and tried connecting via Oracle7.3 with '@' 
prefix and it worked.  I am not using the '@' prefix with Oracle 8 and i 
still get the error message as listed earlier.

Below are PB Database profiles that i used

// Profile tst
SQLCA.DBMS = "O73 ORACLE 7.3"
SQLCA.LogPass = "*******"
SQLCA.ServerName = "@pwi"
SQLCA.LogId = "system"
SQLCA.AutoCommit = False
SQLCA.DBParm = "PBDBMS=0"

This worked.

// Profile acs
SQLCA.DBMS = "OR8 ORACLE 8.0"
SQLCA.LogPass = "*******"
SQLCA.ServerName = "pwi"
SQLCA.LogId = "system"
SQLCA.AutoCommit = False
SQLCA.DBParm = "PBDBMS=0"

This did not work and i am getting the message "Error while trying to 
retrieve text for error ORA-12154".

How can i solve this error?

Bruce Armstrong [TeamSybase] wrote:

> Which driver are you trying to use?  The 7.x drivers require the '@' prefix,
> the 8.x drivers don't (and will generate such an error message if you provide
> it).
> 
> On Wed, 07 Mar 2001 16:40:13 -0500,
>  in powersoft.public.powerbuilder.database
> Suny <suny0143@netscape.net> wrote: 
> 
>> I am using PB6.5 (build 444) and I've Installed Oracle client (Net8) 
>> v8.1.6 to connect to Oracle Server 8.1.6.
>> 
>> I can connect via SQL*Plus; however, When i try to connect thru 
>> Powerbuilder i get the following message:
>> "Error while trying to retrieve text for error ORA-12154"
>> 
>> 
>> Any help on this matter will be greatly appreciated.
>> 
> 
> 
> Bruce Armstrong [TeamSybase]
> http://www.needhim.org
> 
> ---== Posted via the PFCGuide Web Newsreader ==---
> http://www.pfcguide.com/_newsgroups/group_list.asp

Check the TNSNAMES.ORA file in the Net8 directory to make sure that it contains
a 'PWI' entry like the one in the SQL*NET 2.x does.  Also look at the SQLNET.ORA
file to determine if it is set up to automatically prefix your domain names.
It's most likely that you either don't have the proper entry in the Net8
TNSNAMES.ORA file, or the entry is named different, or that you don't have
the default domain name prefix set and Net8 is expecting a fully qualified
name.

On Thu, 08 Mar 2001 12:10:16 -0500,
 in powersoft.public.powerbuilder.database
Suny <suny0143@netscape.net> wrote: 
>To be in synch, how do i determine for sure which driver is being used?
>I followed your advice and tried connecting via Oracle7.3 with '@' 
>prefix and it worked.  I am not using the '@' prefix with Oracle 8 and i 
>still get the error message as listed earlier.
>
>Below are PB Database profiles that i used
>
>// Profile tst
>SQLCA.DBMS = "O73 ORACLE 7.3"
>SQLCA.LogPass = "*******"
>SQLCA.ServerName = "@pwi"
>SQLCA.LogId = "system"
>SQLCA.AutoCommit = False
>SQLCA.DBParm = "PBDBMS=0"
>
>This worked.
>
>// Profile acs
>SQLCA.DBMS = "OR8 ORACLE 8.0"
>SQLCA.LogPass = "*******"
>SQLCA.ServerName = "pwi"
>SQLCA.LogId = "system"
>SQLCA.AutoCommit = False
>SQLCA.DBParm = "PBDBMS=0"
>
>This did not work and i am getting the message "Error while trying to 
>retrieve text for error ORA-12154".
>
>How can i solve this error?
>
>Bruce Armstrong [TeamSybase] wrote:
>
>> Which driver are you trying to use?  The 7.x drivers require the '@' prefix,
>> the 8.x drivers don't (and will generate such an error message if you provide
>> it).
>> 
>> On Wed, 07 Mar 2001 16:40:13 -0500,
>>  in powersoft.public.powerbuilder.database
>> Suny <suny0143@netscape.net> wrote: 
>> 
>>> I am using PB6.5 (build 444) and I've Installed Oracle client (Net8) 
>>> v8.1.6 to connect to Oracle Server 8.1.6.
>>> 
>>> I can connect via SQL*Plus; however, When i try to connect thru 
>>> Powerbuilder i get the following message:
>>> "Error while trying to retrieve text for error ORA-12154"
>>> 
>>> 
>>> Any help on this matter will be greatly appreciated.
>>> 
>> 
>> 
>> Bruce Armstrong [TeamSybase]
>> http://www.needhim.org
>> 
>> ---== Posted via the PFCGuide Web Newsreader ==---
>> http://www.pfcguide.com/_newsgroups/group_list.asp
>

Bruce Armstrong [TeamSybase]
http://www.needhim.org

---== Posted via the PFCGuide Web Newsreader ==---
http://www.pfcguide.com/_newsgroups/group_list.asp

Do not use OR8, but O84 driver.  OR8 is for Oracle 803 only.
You need to install PB 651 and than patch it up.  I use build 1264 and it
seems to work quite well.

--
Terry Dykstra (TeamSybase)
Please state PB / OS / DB versions in your post.
MySybase http://my.sybase.com/mysybase
Search Deja: http://www.pfcguide.com/_newsgroups/search.asp

"Suny" <suny0143@netscape.net> wrote in message
news:3AA7BCF8.7030105@netscape.net...
> To be in synch, how do i determine for sure which driver is being used?
> I followed your advice and tried connecting via Oracle7.3 with '@'
> prefix and it worked.  I am not using the '@' prefix with Oracle 8 and i
> still get the error message as listed earlier.
>
> Below are PB Database profiles that i used
>
> // Profile tst
> SQLCA.DBMS = "O73 ORACLE 7.3"
> SQLCA.LogPass = "*******"
> SQLCA.ServerName = "@pwi"
> SQLCA.LogId = "system"
> SQLCA.AutoCommit = False
> SQLCA.DBParm = "PBDBMS=0"
>
> This worked.
>
> // Profile acs
> SQLCA.DBMS = "OR8 ORACLE 8.0"
> SQLCA.LogPass = "*******"
> SQLCA.ServerName = "pwi"
> SQLCA.LogId = "system"
> SQLCA.AutoCommit = False
> SQLCA.DBParm = "PBDBMS=0"
>
> This did not work and i am getting the message "Error while trying to
> retrieve text for error ORA-12154".
>
> How can i solve this error?
>
> Bruce Armstrong [TeamSybase] wrote:
>
> > Which driver are you trying to use?  The 7.x drivers require the '@'
prefix,
> > the 8.x drivers don't (and will generate such an error message if you
provide
> > it).
> >
> > On Wed, 07 Mar 2001 16:40:13 -0500,
> >  in powersoft.public.powerbuilder.database
> > Suny <suny0143@netscape.net> wrote:
> >
> >> I am using PB6.5 (build 444) and I've Installed Oracle client (Net8)
> >> v8.1.6 to connect to Oracle Server 8.1.6.
> >>
> >> I can connect via SQL*Plus; however, When i try to connect thru
> >> Powerbuilder i get the following message:
> >> "Error while trying to retrieve text for error ORA-12154"
> >>
> >>
> >> Any help on this matter will be greatly appreciated.
> >>
> >
> >
> > Bruce Armstrong [TeamSybase]
> > http://www.needhim.org
> >
> > ---== Posted via the PFCGuide Web Newsreader ==---
> > http://www.pfcguide.com/_newsgroups/group_list.asp
>

I am encountering a related problem.
On a Windows2000 machine with PB6.5 app using Net8, I got an ORA-12560 
error 'Unable to connect', when I login with server name as @qa51x. After I 
clicked ok on the message and try again, then it goes through fine.
The sqlnet client trace file indicates following connection that results in 
error :
niotns: Calling address: 
(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oracleORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')))(CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=C:\Program 
Files\D9505.1\Diamond\app_diam.exe)(HOST=W000767)(USER=JAnderson))))
nscall: connecting...
nsopen: opening transport...
nserror: nsres: id=0, op=65, ns=12560, ns2=0; nt[0]=530, nt[1]=0, nt[2]=0
nsopen: unable to open transport
nioqper:  error from nscall
nioqper:    nr err code: 0
nioqper:    ns main err code: 12560
nioqper:    ns (2)  err code: 0
nioqper:    nt main err code: 530
nioqper:    nt (2)  err code: 0
nioqper:    nt OS   err code: 0
niqme:  reporting ns (2) error: (12560) as rdbms err (12560)
niotns: Couldn't connect, returning 12560

The second try, however, uses the correct entry in tnsnames :
nnfotran: Checking local tnsnames.ora file
nncpldf_load_addrfile: initial load of names file 
c:\oracle\ora81\network\admin\tnsnames.ora
nncpldf_load_addrfile: success
nnftqnm: Using tnsnames.ora address (DESCRIPTION = (ADDRESS_LIST = (ADDRESS 
= (COMMUNITY = tcp.world) (PROTOCOL = TCP) (Host = zoe) (Port = 1522))) 
(CONNECT_DATA = (SID = qa51X))) for name qa51x.world

I tried using service name without prefix @, but to no avail.

Sqlnet file is pretty standard :
AUTOMATIC_IPC = OFF
SQLNET.EXPIRE_TIME = 2147483647
trace_level_client = off
trace_file_client = sqlnet
trace_directory_client=C:\ORACLE\ORA81\network\trace
log_file_client = sqlnet
log_directory_client=C:\ORACLE\ORA81\network\log
names.default_domain = world
name.default_zone = world

There is no problem running sqlplus with the same settings.
Any idea on what may cause the problem ?
Thanks,
Philip Hoi,
philip.hoi@ps.net 

 

I make it a habit of adding the tnsnames_admin entry in the registry.  It
solves a lot of pathing issues.  Mine looks like this:

[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE]
"TNS_ADMIN"="I:\\ORANT\\NETWORK\\ADMIN"

If you are not using the Names service, comment out the 'names' lines in the
sqlnet.ora file:
names.default_domain = world
name.default_zone = world

--
Terry Dykstra (TeamSybase)
Please state PB / OS / DB versions in your post.
MySybase http://my.sybase.com/mysybase
Search Deja: http://www.pfcguide.com/_newsgroups/search.asp

<Philip_Hoi> wrote in message
news:62DF1007C3B6ED2B008379D285256A0E.0058ED0B85256A0A@webforums...
> I am encountering a related problem.
> On a Windows2000 machine with PB6.5 app using Net8, I got an ORA-12560
> error 'Unable to connect', when I login with server name as @qa51x. After
I
> clicked ok on the message and try again, then it goes through fine.
> The sqlnet client trace file indicates following connection that results
in
> error :
> niotns: Calling address:
>
(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=ora
cleORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')))(CONNECT
_DATA=(SID=ORCL)(CID=(PROGRAM=C:\Program
> Files\D9505.1\Diamond\app_diam.exe)(HOST=W000767)(USER=JAnderson))))
> nscall: connecting...
> nsopen: opening transport...
> nserror: nsres: id=0, op=65, ns=12560, ns2=0; nt[0]=530, nt[1]=0, nt[2]=0
> nsopen: unable to open transport
> nioqper:  error from nscall
> nioqper:    nr err code: 0
> nioqper:    ns main err code: 12560
> nioqper:    ns (2)  err code: 0
> nioqper:    nt main err code: 530
> nioqper:    nt (2)  err code: 0
> nioqper:    nt OS   err code: 0
> niqme:  reporting ns (2) error: (12560) as rdbms err (12560)
> niotns: Couldn't connect, returning 12560
>
> The second try, however, uses the correct entry in tnsnames :
> nnfotran: Checking local tnsnames.ora file
> nncpldf_load_addrfile: initial load of names file
> c:\oracle\ora81\network\admin\tnsnames.ora
> nncpldf_load_addrfile: success
> nnftqnm: Using tnsnames.ora address (DESCRIPTION = (ADDRESS_LIST =
(ADDRESS
> = (COMMUNITY = tcp.world) (PROTOCOL = TCP) (Host = zoe) (Port = 1522)))
> (CONNECT_DATA = (SID = qa51X))) for name qa51x.world
>
> I tried using service name without prefix @, but to no avail.
>
> Sqlnet file is pretty standard :
> AUTOMATIC_IPC = OFF
> SQLNET.EXPIRE_TIME = 2147483647
> trace_level_client = off
> trace_file_client = sqlnet
> trace_directory_client=C:\ORACLE\ORA81\network\trace
> log_file_client = sqlnet
> log_directory_client=C:\ORACLE\ORA81\network\log
> names.default_domain = world
> name.default_zone = world
>
> There is no problem running sqlplus with the same settings.
> Any idea on what may cause the problem ?
> Thanks,
> Philip Hoi,
> philip.hoi@ps.net
>
>