<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2900.2912" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=200475411-20062006>Hi Han,</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=200475411-20062006></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=200475411-20062006>Looks very much like our pdl code.</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=200475411-20062006></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=200475411-20062006>Have you tried to remove the " around the logon string
i.e. :</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=200475411-20062006></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT><SPAN class=200475411-20062006>database orcl type
oracle open <A
href="mailto:ORACLE@user1@orcl/passwd1">ORACLE@user1@orcl/passwd1</A> owner
dba</SPAN></FONT></DIV><!-- Converted from text/plain format -->
<P><FONT size=2>Mange hilsner / With kind regards<BR><BR>Ole
Hansen<BR><BR>===========================================================<BR>E-mail:
oh@scanconsult.dk Cell Phone:
+45 4040
1150<BR>===========================================================<BR>ScanConsult
IT-Partners ApS
Voice : +45 7734 7474<BR>Jegstrupvej
96A
Fax : +45 8738 1416<BR>DK-8361
Hasselager Support :
support@scanconsult.dk<BR>Denmark
Sales :
sales@scanconsult.dk<BR>
<A
href="http://www.scanconsult.dk/">http://www.scanconsult.dk</A> <BR>=
ParaSuite : A Suite of Air Cargo Handling solutions
=<BR>= Partners : Hewlett-Packard, Cognos, Microsoft and more
=<BR> </FONT> </P>
<DIV> </DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B>
powerh-l-bounces+oh=scanconsult.dk@lists.sowder.com
[mailto:powerh-l-bounces+oh=scanconsult.dk@lists.sowder.com] <B>On Behalf Of
</B>I H LIM<BR><B>Sent:</B> 20. juni 2006 12:30<BR><B>To:</B>
powerh-l@lists.sowder.com<BR><B>Subject:</B> Connection to Oracle DB
failed<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV>Hi everyone,</DIV>
<DIV> </DIV>
<DIV>Server Platform : Oracle 10g in Windows Server 2003</DIV>
<DIV>Client Platform : Powerhouse Windows 8.41D1 running on Windows
XP, Oracle Client 10g</DIV>
<DIV> </DIV>
<DIV>We have try using oracle client "SQL PLUS" with the command </DIV>
<DIV>"sqlplus <A href="mailto:user1/passwd1@orcl">user1/passwd1@orcl</A>", the
connection is ok. </DIV>
<DIV> </DIV>
<DIV>We declare the pdl as below:</DIV>
<DIV> </DIV>
<DIV>create dictionary c:\test\oracle\phd.pdc not preloaded</DIV>
<DIV>database orcl type oracle open "ORACLE@user1@orcl/passwd1" owner
dba</DIV>
<DIV>load<BR></DIV>
<DIV>and we access quiz as below and error appear :</DIV>
<DIV> </DIV>
<DIV>> acc file1 in orcl</DIV>
<DIV>*W* SQL START DBE error (ORCL)<BR>DMS-E-CONNECTREJECT, A connection has
been rejected by the remote interface<BR>during operation 'attach
database'.<BR>ORA-12154: TNS:could not resolve the connect identifier
specified<BR></DIV>
<DIV>*E* The file file1 in orcl wasnt found in data dictionary</DIV>
<DIV> </DIV>
<DIV>></DIV>
<DIV> </DIV>
<DIV>Anyone come across this issue? Please help</DIV>
<DIV> </DIV>
<DIV>Thank You</DIV>
<DIV> </DIV>
<DIV>Regards</DIV>
<DIV>Han</DIV>
<DIV><BR> </DIV>
<P>
<HR SIZE=1>
Yahoo! Messenger with Voice. <A
href="http://us.rd.yahoo.com/mail_us/taglines/postman1/*http://us.rd.yahoo.com/evt=39663/*http://voice.yahoo.com">Make
PC-to-Phone Calls</A> to the US (and 30+ countries) for 2¢/min or
less.</BODY></HTML>