Connection to Oracle DB failed

[Ole Hansen]

Hi Han,
 
Looks very much like our pdl code.
 
Have you tried to remove the " around the logon string i.e. :
 
database orcl type oracle open ORACLE at user1@orcl/passwd1 owner dba

Mange hilsner / With kind regards

Ole Hansen

===========================================================
E-mail: oh at scanconsult.dk         Cell Phone: +45 4040 1150
===========================================================
ScanConsult IT-Partners ApS         Voice   : +45 7734 7474
Jegstrupvej 96A                     Fax     : +45 8738 1416
DK-8361 Hasselager         Support : support at scanconsult.dk
Denmark                    Sales   :   sales at scanconsult.dk
                 http://www.scanconsult.dk <http://www.scanconsult.dk/>                
= ParaSuite :  A Suite of Air Cargo Handling solutions    =
= Partners  : Hewlett-Packard, Cognos, Microsoft and more =
  

 

________________________________

From: powerh-l-bounces+oh=scanconsult.dk at lists.sowder.com [mailto:powerh-l-bounces+oh=scanconsult.dk at lists.sowder.com] On Behalf Of I H LIM
Sent: 20. juni 2006 12:30
To: powerh-l at lists.sowder.com
Subject: Connection to Oracle DB failed


Hi everyone,
 
Server Platform : Oracle 10g in Windows Server 2003
Client Platform :  Powerhouse Windows 8.41D1 running  on Windows XP, Oracle Client 10g
 
We have try using oracle client "SQL PLUS" with the command 
"sqlplus user1/passwd1 at orcl", the connection is ok. 
 
We declare the pdl as below:
 
create dictionary c:\test\oracle\phd.pdc not preloaded
database orcl type oracle open "ORACLE at user1@orcl/passwd1" owner dba
load

and we access quiz  as below and error appear :
 
> acc file1 in orcl
*W* SQL START DBE error (ORCL)
DMS-E-CONNECTREJECT, A connection has been rejected by the remote interface
during operation 'attach database'.
ORA-12154: TNS:could not resolve the connect identifier specified

*E* The file file1 in orcl wasnt found in data dictionary
 
>
 
Anyone come across this issue? Please help
 
Thank You
 
Regards
Han

 

________________________________

Yahoo! Messenger with Voice. Make PC-to-Phone Calls <http://us.rd.yahoo.com/mail_us/taglines/postman1/*http://us.rd.yahoo.com/evt=39663/*http://voice.yahoo.com>  to the US (and 30+ countries) for 2¢/min or less.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20060620/3eb54a43/attachment.html