<div>Did try that earlier but still hit the same error message!</div> <div> </div> <div>Regards,</div> <div>Han<BR><BR><B><I>powerh-l-request@lists.sowder.com</I></B> wrote:</div> <BLOCKQUOTE class=replbq style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid">Send powerh-l mailing list submissions to<BR>powerh-l@lists.sowder.com<BR><BR>To subscribe or unsubscribe via the World Wide Web, visit<BR>http://lists.sowder.com/mailman/listinfo/powerh-l<BR>or, via email, send a message with subject or body 'help' to<BR>powerh-l-request@lists.sowder.com<BR><BR>You can reach the person managing the list at<BR>powerh-l-owner@lists.sowder.com<BR><BR>When replying, please edit your Subject line so it is more specific<BR>than "Re: Contents of powerh-l digest..."<BR><BR><BR>Today's Topics:<BR><BR>1. Connection to Oracle DB failed (I H LIM)<BR>2. RE:Connection to Oracle DB failed (Ole
Hansen)<BR><BR><BR>----------------------------------------------------------------------<BR><BR>Message: 1<BR>Date: Tue, 20 Jun 2006 03:07:12 -0700 (PDT)<BR>From: I H LIM <INFOJENAMA@YAHOO.COM><BR>Subject: Connection to Oracle DB failed<BR>To: powerh-l@lists.sowder.com<BR>Message-ID: <20060620100712.57779.qmail@web32404.mail.mud.yahoo.com><BR>Content-Type: text/plain; charset="iso-8859-1"<BR><BR>Hi everyone,<BR><BR>Server Platform : Oracle 10g in Windows Server 2003<BR>Client Platform : Powerhouse Windows 8.41D1 running on Windows XP, Oracle Client 10g<BR><BR>We have try using oracle client "SQL PLUS" with the command <BR>"sqlplus user1/passwd1@orcl", the connection is ok. <BR><BR>We declare the pdl as below:<BR><BR>create dictionary c:\test\oracle\phd.pdc not preloaded<BR>database orcl type oracle open "ORACLE@user1@orcl/passwd1" owner dba<BR>load<BR><BR>and we access quiz as below and error appear :<BR><BR>> acc file1 in orcl<BR>*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><BR>*E* The file file1 in orcl wasnt found in data dictionary<BR><BR>><BR><BR>Anyone come across this issue? Please help<BR><BR>Thank You<BR><BR>Regards<BR>Han<BR><BR><BR><BR><BR>---------------------------------<BR>Yahoo! Messenger with Voice. Make PC-to-Phone Calls to the US (and 30+ countries) for 2¢/min or less.<BR>-------------- next part --------------<BR>An HTML attachment was scrubbed...<BR>URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20060620/6a13d4a4/attachment.html<BR><BR>------------------------------<BR><BR>Message: 2<BR>Date: Tue, 20 Jun 2006 13:58:17 +0200<BR>From: "Ole Hansen" <OH@SCANCONSULT.DK><BR>Subject: RE: Connection to Oracle DB failed<BR>To: "I H LIM" <INFOJENAMA@YAHOO.COM>,
<POWERH-L@LISTS.SOWDER.COM><BR>Message-ID:<BR><283E7941B032C94CB56F2FDEE33845FC0A9D62@scserver100.scanconsult03.local><BR><BR>Content-Type: text/plain; charset="iso-8859-1"<BR><BR>Hi Han,<BR><BR>Looks very much like our pdl code.<BR><BR>Have you tried to remove the " around the logon string i.e. :<BR><BR>database orcl type oracle open ORACLE@user1@orcl/passwd1 owner dba<BR><BR>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>http://www.scanconsult.dk <HTTP: www.scanconsult.dk /><BR>= ParaSuite : A Suite of Air Cargo Handling solutions =<BR>= Partners : Hewlett-Packard, Cognos, Microsoft and more
=<BR><BR><BR><BR><BR>________________________________<BR><BR>From: powerh-l-bounces+oh=scanconsult.dk@lists.sowder.com [mailto:powerh-l-bounces+oh=scanconsult.dk@lists.sowder.com] On Behalf Of I H LIM<BR>Sent: 20. juni 2006 12:30<BR>To: powerh-l@lists.sowder.com<BR>Subject: Connection to Oracle DB failed<BR><BR><BR>Hi everyone,<BR><BR>Server Platform : Oracle 10g in Windows Server 2003<BR>Client Platform : Powerhouse Windows 8.41D1 running on Windows XP, Oracle Client 10g<BR><BR>We have try using oracle client "SQL PLUS" with the command <BR>"sqlplus user1/passwd1@orcl", the connection is ok. <BR><BR>We declare the pdl as below:<BR><BR>create dictionary c:\test\oracle\phd.pdc not preloaded<BR>database orcl type oracle open "ORACLE@user1@orcl/passwd1" owner dba<BR>load<BR><BR>and we access quiz as below and error appear :<BR><BR>> acc file1 in orcl<BR>*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><BR>*E* The file file1 in orcl wasnt found in data dictionary<BR><BR>><BR><BR>Anyone come across this issue? Please help<BR><BR>Thank You<BR><BR>Regards<BR>Han<BR><BR><BR><BR>________________________________<BR><BR>Yahoo! Messenger with Voice. Make PC-to-Phone Calls <HTTP: evt="39663/*http://voice.yahoo.com" us.rd.yahoo.com *http: postman1 taglines mail_us>to the US (and 30+ countries) for 2¢/min or less.<BR>-------------- next part --------------<BR>An HTML attachment was scrubbed...<BR>URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20060620/3eb54a43/attachment-0001.html<BR><BR>------------------------------<BR><BR>-- <BR>= = = = = = = = = = = = = = = = = = = = = = = = = = = =<BR>Mailing list: powerh-l@lists.sowder.com<BR>Subscribe: "subscribe" in message body to powerh-l-request@lists.sowder.com<BR>Unsubscribe: "unsubscribe <password>" in message
body to powerh-l-request@lists.sowder.com<BR>http://lists.sowder.com/mailman/listinfo/powerh-l<BR>This list is closed, thus to post to the list you must be a subscriber.<BR>Add 'site:lists.sowder.com powerh-l' to your search terms to search the list archive at Google.<BR><BR>End of powerh-l Digest, Vol 13, Issue 14<BR>****************************************<BR></BLOCKQUOTE><BR><p> 
<hr size=1>How low will we go? Check out Yahoo! Messenger’s low <a href="http://us.rd.yahoo.com/mail_us/taglines/postman8/*http://us.rd.yahoo.com/evt=39663/*http://voice.yahoo.com"> PC-to-Phone call rates.