<table cellspacing="0" cellpadding="0" border="0" ><tr><td valign="top" style="font: inherit;"><DIV>hi everybody</DIV>
<DIV> </DIV>
<DIV>my problem is still persisting.</DIV>
<DIV> </DIV>
<DIV>I am having oracle 11g installed on my machine and I am trying to connect to a</DIV>
<DIV>remote machine also having oracle 11g using the mapguide maestro 1.0.9.</DIV>
<DIV>I am opting for new data connection and choosing OSGeo FDO provider for Oracle.</DIV>
<DIV> </DIV>
<DIV>Now</DIV>
<DIV>When I opt for specified credentials and provide username and password it gives</DIV>
<DIV>the following error on clicking the test connection:</DIV>
<DIV> </DIV>
<DIV>The remote server returned an error: (559) MgFdoException.: <BR>An exception occurred in FDO component.<BR>ORA-12560: TNS:protocol adapter error</DIV>
<DIV>Exception occurred in method MgFdoConnectionManager.Open at line 858 in file d:\build\mapguide_open_source_v2.0\build_30.11\mgdev\server\src\common\manager\FdoConnectionManager.cpp</DIV>
<DIV> </DIV>
<DIV><BR>when I provide the orcl in the text box labelled service it gives the following error;</DIV>
<DIV> </DIV>
<DIV>The remote server returned an error: (559) MgFdoException.: <BR>An exception occurred in FDO component.<BR>ORA-12154: TNS:could not resolve the connect identifier specified</DIV>
<DIV>Exception occurred in method MgFdoConnectionManager.Open at line 858 in file d:\build\mapguide_open_source_v2.0\build_30.11\mgdev\server\src\common\manager\FdoConnectionManager.cpp</DIV>
<DIV> </DIV>
<DIV>Connection works fine </DIV>
<DIV>when I use the following on the sql prompt:</DIV>
<DIV> </DIV>
<DIV><A href="mailto:username/password@orcl">username/password@orcl</A></DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV>I am using mapguide 2.0<BR>FDO 3.3 and windows 2003 server.</DIV>
<DIV> </DIV>
<DIV>Can anybody help!</DIV>
<DIV> </DIV>
<DIV>Regards</DIV>
<DIV>Manav</DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV><BR>--- On <B>Fri, 13/11/09, Simon Pelicon <I><simon@sl-king.com></I></B> wrote:<BR></DIV>
<BLOCKQUOTE style="BORDER-LEFT: rgb(16,16,255) 2px solid; PADDING-LEFT: 5px; MARGIN-LEFT: 5px"><BR>From: Simon Pelicon <simon@sl-king.com><BR>Subject: Re: [mapguide-users] connection with oracle<BR>To: "MapGuide Users Mail List" <mapguide-users@lists.osgeo.org><BR>Date: Friday, 13 November, 2009, 4:10 PM<BR><BR>
<DIV id=yiv1575752355>Did you use <B>Oracle Instant Client</B> or <B>Oracle Client </B>version of provider<B>?</B><BR><BR>
<DIV class=gmail_quote>On Fri, Nov 13, 2009 at 10:07 AM, manav dayal <SPAN dir=ltr><<A href="http://in.mc941.mail.yahoo.com/mc/compose?to=manav_dayal85@yahoo.co.in" rel=nofollow target=_blank ymailto="mailto:manav_dayal85@yahoo.co.in">manav_dayal85@yahoo.co.in</A>></SPAN> wrote:<BR>
<BLOCKQUOTE style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex" class=gmail_quote>
<TABLE border=0 cellSpacing=0 cellPadding=0>
<TBODY>
<TR>
<TD vAlign=top>
<DIV>I am using mapguide 2.0<BR>FDO 3.3 with oracle 11g</DIV>
<DIV> </DIV>
<DIV><BR>--- On <B>Fri, 13/11/09, Simon Pelicon <I><<A href="http://in.mc941.mail.yahoo.com/mc/compose?to=simon@sl-king.com" rel=nofollow target=_blank ymailto="mailto:simon@sl-king.com">simon@sl-king.com</A>></I></B> wrote:<BR></DIV>
<BLOCKQUOTE style="BORDER-LEFT: rgb(16,16,255) 2px solid; PADDING-LEFT: 5px; MARGIN-LEFT: 5px"><BR>From: Simon Pelicon <<A href="http://in.mc941.mail.yahoo.com/mc/compose?to=simon@sl-king.com" rel=nofollow target=_blank ymailto="mailto:simon@sl-king.com">simon@sl-king.com</A>>
<DIV class=im><BR>Subject: Re: [mapguide-users] connection with oracle<BR>To: "MapGuide Users Mail List" <<A href="http://in.mc941.mail.yahoo.com/mc/compose?to=mapguide-users@lists.osgeo.org" rel=nofollow target=_blank ymailto="mailto:mapguide-users@lists.osgeo.org">mapguide-users@lists.osgeo.org</A>><BR></DIV>Date: Friday, 13 November, 2009, 1:20 PM
<DIV>
<DIV></DIV>
<DIV class=h5><BR><BR>
<DIV>Yes, oracle provider support also 11g.<BR>
<DIV>
<DIV><BR></DIV>
<DIV>Manav:</DIV>
<DIV>I would like do know version of MapGuide Server and version of provider used?</DIV>
<DIV>For FDO 3.3 there are two kind of providers, for instant oracle client and for oracle client.</DIV>
<DIV><BR></DIV>
<DIV><BR></DIV>
<DIV><BR>
<DIV class=gmail_quote>On Fri, Nov 13, 2009 at 8:27 AM, Zac Spitzer <SPAN dir=ltr><<A href="http://in.mc941.mail.yahoo.com/mc/compose?to=zac.spitzer@gmail.com" rel=nofollow target=_blank>zac.spitzer@gmail.com</A>></SPAN> wrote:<BR>
<BLOCKQUOTE style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex" class=gmail_quote>Simon,<BR><BR>does king oracle work with 11g client, or just 10g?<BR><FONT color=#888888><BR>z</FONT>
<DIV>
<DIV></DIV>
<DIV><BR><BR>
<DIV class=gmail_quote>On Fri, Nov 13, 2009 at 6:25 PM, Simon Pelicon <SPAN dir=ltr><<A href="http://in.mc941.mail.yahoo.com/mc/compose?to=simon@sl-king.com" rel=nofollow target=_blank>simon@sl-king.com</A>></SPAN> wrote:<BR>
<BLOCKQUOTE style="BORDER-LEFT: rgb(204,204,204) 1px solid; MARGIN: 0pt 0pt 0pt 0.8ex; PADDING-LEFT: 1ex" class=gmail_quote>Hi!
<DIV>for SERVICE NAME enter:</DIV>
<DIV>1. if you use Oracle instant client <SPAN style="BORDER-COLLAPSE: collapse; FONT-FAMILY: arial, sans-serif; FONT-SIZE: 13px">use (as Zac answered) oracle easy connect syntax</SPAN>: <SPAN style="BORDER-COLLAPSE: collapse; FONT-FAMILY: arial, sans-serif; FONT-SIZE: 13px">//servername/orcl </SPAN></DIV>
<DIV><SPAN style="BORDER-COLLAPSE: collapse; FONT-FAMILY: arial, sans-serif; FONT-SIZE: 13px">2. if you use Oracle client than enter your oracle Service name specified in client</SPAN></DIV>
<DIV><SPAN style="BORDER-COLLAPSE: collapse; FONT-FAMILY: arial, sans-serif; FONT-SIZE: 13px"><BR></SPAN></DIV>
<DIV>
<DIV>SCHEMA (optional parameter)</DIV>
<DIV><FONT size=2>"OracleSchema" determines if all raws from ALL_SDO_GEOM_METADATA will be used or just rows with Owner equal to "OracleSchema"</FONT></DIV>
<DIV><BR></DIV>
<DIV><FONT size=2></FONT>KINGFDOCLASS (optional parameter)</DIV>
<DIV>if you want that provider uses additional Oracle Table to describe FDO classes.</DIV>
<DIV><BR></DIV>
<DIV>To connect you need username,password and valid service name.</DIV>
<DIV>
<DIV></DIV>
<DIV>
<DIV><BR></DIV>
<DIV><BR><BR>
<DIV class=gmail_quote>On Fri, Nov 13, 2009 at 5:06 AM, manav dayal <SPAN dir=ltr><<A href="http://in.mc941.mail.yahoo.com/mc/compose?to=manav_dayal85@yahoo.co.in" rel=nofollow target=_blank>manav_dayal85@yahoo.co.in</A>></SPAN> wrote:<BR>
<BLOCKQUOTE style="BORDER-LEFT: rgb(204,204,204) 1px solid; MARGIN: 0pt 0pt 0pt 0.8ex; PADDING-LEFT: 1ex" class=gmail_quote>
<TABLE border=0 cellSpacing=0 cellPadding=0>
<TBODY>
<TR>
<TD style="FONT-FAMILY: inherit; font-size-adjust: inherit; font-stretch: inherit" vAlign=top>
<DIV>When i opt for new dataconnection using oracle provider in maestro, a new source window opens. On this window I opt for specified credentials and pass the username and password.</DIV>
<DIV> </DIV>
<DIV>when i use sql prompt, it works fine with <A href="http://in.mc941.mail.yahoo.com/mc/compose?to=username/password@orcl" rel=nofollow target=_blank>username/password@orcl</A>.</DIV>
<DIV> </DIV>
<DIV>I need to know what should be written inside the text boxes for service,</DIV>
<DIV>schema and king FDO class or do i need to make any other connection settings.</DIV>
<DIV><BR><BR>--- On <B>Thu, 12/11/09, Zac Spitzer <I><<A href="http://in.mc941.mail.yahoo.com/mc/compose?to=zac.spitzer@gmail.com" rel=nofollow target=_blank>zac.spitzer@gmail.com</A>></I></B> wrote:<BR></DIV>
<BLOCKQUOTE style="BORDER-LEFT: rgb(16,16,255) 2px solid; PADDING-LEFT: 5px; MARGIN-LEFT: 5px"><BR>From: Zac Spitzer <<A href="http://in.mc941.mail.yahoo.com/mc/compose?to=zac.spitzer@gmail.com" rel=nofollow target=_blank>zac.spitzer@gmail.com</A>><BR>Subject: Re: [mapguide-users] connection with oracle<BR>To: "MapGuide Users Mail List" <<A href="http://in.mc941.mail.yahoo.com/mc/compose?to=mapguide-users@lists.osgeo.org" rel=nofollow target=_blank>mapguide-users@lists.osgeo.org</A>><BR>Date: Thursday, 12 November, 2009, 6:04 PM<BR><BR>
<DIV>it is purely a error with the service name<BR><BR>ORA-12154: TNS:could not resolve the connect identifier specified<BR><BR>is a native error code from oracle<BR><BR>what are your connection settings?<BR><BR>z<BR><BR><BR><BR>On Thu, Nov 12, 2009 at 11:01 PM, Dejan Gregor <<A href="http://in.mc941.mail.yahoo.com/mc/compose?to=dejan.gregor@gmail.com" rel=nofollow target=_blank>dejan.gregor@gmail.com</A>> wrote:<BR>><BR>> Do you have an Oracle client installed from where you are connecting?<BR>> Dejan<BR>><BR>> On Thu, Nov 12, 2009 at 12:58, manav dayal <<A href="http://in.mc941.mail.yahoo.com/mc/compose?to=manav_dayal85@yahoo.co.in" rel=nofollow target=_blank>manav_dayal85@yahoo.co.in</A>> wrote:<BR>>><BR>>><BR>>> I am using maestro1.0 and trying to connect to the remote database server.<BR>>> When I choose to make a new data connection with OSGeo.KingOracle.3.3 as
the<BR>>> provider for oracle.<BR>>><BR>>> Following error is being thrown when I try to test the connection.<BR>>><BR>>><BR>>> The remote server returned an error: (559) MgFdoException.:<BR>>> An exception occurred in FDO component.<BR>>> ORA-12154: TNS:could not resolve the connect identifier specified<BR>>> Exception occurred in method MgFdoConnectionManager.Open at line 858 in file d:\build\mapguide_open_source_v2.0\build_30.11\mgdev\server\src\common\manager\FdoConnectionManager.cpp<BR>>><BR>>> kindly help asap.<BR>>> Regards.<BR>>><BR>>> ________________________________<BR>>> The INTERNET now has a personality. YOURS! See your Yahoo! Homepage.<BR>>> _______________________________________________<BR>>> mapguide-users mailing list<BR>>> <A href="http://in.mc941.mail.yahoo.com/mc/compose?to=mapguide-users@lists.osgeo.org" rel=nofollow
target=_blank>mapguide-users@lists.osgeo.org</A><BR>>> <A href="http://lists.osgeo.org/mailman/listinfo/mapguide-users" rel=nofollow target=_blank>http://lists.osgeo.org/mailman/listinfo/mapguide-users</A><BR>>><BR>><BR>><BR>> _______________________________________________<BR>> mapguide-users mailing list<BR>> <A href="http://in.mc941.mail.yahoo.com/mc/compose?to=mapguide-users@lists.osgeo.org" rel=nofollow target=_blank>mapguide-users@lists.osgeo.org</A><BR>> <A href="http://lists.osgeo.org/mailman/listinfo/mapguide-users" rel=nofollow target=_blank>http://lists.osgeo.org/mailman/listinfo/mapguide-users</A><BR>><BR><BR><BR><BR>--<BR>Zac Spitzer<BR>Solution Architect / Director<BR>Ennoble Consultancy Australia<BR><A href="http://www.ennoble.com.au/" rel=nofollow target=_blank>http://www.ennoble.com.au</A><BR><A href="http://zacster.blogspot.com/" rel=nofollow target=_blank>http://zacster.blogspot.com</A><BR>+61 405 847
168<BR>_______________________________________________<BR>mapguide-users mailing list<BR><A href="http://in.mc941.mail.yahoo.com/mc/compose?to=mapguide-users@lists.osgeo.org" rel=nofollow target=_blank>mapguide-users@lists.osgeo.org</A><BR><A href="http://lists.osgeo.org/mailman/listinfo/mapguide-users" rel=nofollow target=_blank>http://lists.osgeo.org/mailman/listinfo/mapguide-users</A><BR></DIV></BLOCKQUOTE></TD></TR></TBODY></TABLE>
<DIV><BR>
<HR SIZE=1>
The INTERNET now has a personality. YOURS! <A href="http://in.rd.yahoo.com/tagline_yyi_1/*http://in.yahoo.com/" rel=nofollow target=_blank>See your Yahoo! Homepage</A>.</DIV><BR>_______________________________________________<BR>mapguide-users mailing list<BR><A href="http://in.mc941.mail.yahoo.com/mc/compose?to=mapguide-users@lists.osgeo.org" rel=nofollow target=_blank>mapguide-users@lists.osgeo.org</A><BR><A href="http://lists.osgeo.org/mailman/listinfo/mapguide-users" rel=nofollow target=_blank>http://lists.osgeo.org/mailman/listinfo/mapguide-users</A><BR><BR></BLOCKQUOTE></DIV><BR></DIV></DIV></DIV></DIV><BR>_______________________________________________<BR>mapguide-users mailing list<BR><A href="http://in.mc941.mail.yahoo.com/mc/compose?to=mapguide-users@lists.osgeo.org" rel=nofollow target=_blank>mapguide-users@lists.osgeo.org</A><BR><A href="http://lists.osgeo.org/mailman/listinfo/mapguide-users" rel=nofollow
target=_blank>http://lists.osgeo.org/mailman/listinfo/mapguide-users</A><BR><BR></BLOCKQUOTE></DIV><BR><BR clear=all><BR>-- <BR>Zac Spitzer <BR>Solution Architect / Director<BR>Ennoble Consultancy Australia<BR><A href="http://www.ennoble.com.au/" rel=nofollow target=_blank>http://www.ennoble.com.au</A><BR><A href="http://zacster.blogspot.com/" rel=nofollow target=_blank>http://zacster.blogspot.com</A><BR>+61 405 847 168<BR><BR><BR><BR></DIV></DIV><BR>_______________________________________________<BR>mapguide-users mailing list<BR><A href="http://in.mc941.mail.yahoo.com/mc/compose?to=mapguide-users@lists.osgeo.org" rel=nofollow target=_blank>mapguide-users@lists.osgeo.org</A><BR><A href="http://lists.osgeo.org/mailman/listinfo/mapguide-users" rel=nofollow target=_blank>http://lists.osgeo.org/mailman/listinfo/mapguide-users</A><BR><BR></BLOCKQUOTE></DIV><BR></DIV></DIV></DIV><BR></DIV></DIV>-----Inline Attachment Follows-----
<DIV class=im><BR><BR>
<DIV>_______________________________________________<BR>mapguide-users mailing list<BR><A href="http://in.mc941.mail.yahoo.com/mc/compose?to=mapguide-users@lists.osgeo.org" rel=nofollow target=_blank>mapguide-users@lists.osgeo.org</A><BR><A href="http://lists.osgeo.org/mailman/listinfo/mapguide-users" rel=nofollow target=_blank>http://lists.osgeo.org/mailman/listinfo/mapguide-users</A><BR></DIV></DIV></BLOCKQUOTE></TD></TR></TBODY></TABLE>
<DIV>
<DIV></DIV>
<DIV class=h5><BR>
<HR SIZE=1>
The INTERNET now has a personality. YOURS! <A href="http://in.rd.yahoo.com/tagline_yyi_1/*http://in.yahoo.com/" rel=nofollow target=_blank>See your Yahoo! Homepage</A>.</DIV></DIV><BR>_______________________________________________<BR>mapguide-users mailing list<BR><A href="http://in.mc941.mail.yahoo.com/mc/compose?to=mapguide-users@lists.osgeo.org" rel=nofollow target=_blank ymailto="mailto:mapguide-users@lists.osgeo.org">mapguide-users@lists.osgeo.org</A><BR><A href="http://lists.osgeo.org/mailman/listinfo/mapguide-users" rel=nofollow target=_blank>http://lists.osgeo.org/mailman/listinfo/mapguide-users</A><BR><BR></BLOCKQUOTE></DIV><BR></DIV><BR>-----Inline Attachment Follows-----<BR><BR>
<DIV class=plainMail>_______________________________________________<BR>mapguide-users mailing list<BR><A href="http://in.mc941.mail.yahoo.com/mc/compose?to=mapguide-users@lists.osgeo.org" ymailto="mailto:mapguide-users@lists.osgeo.org">mapguide-users@lists.osgeo.org</A><BR><A href="http://lists.osgeo.org/mailman/listinfo/mapguide-users" target=_blank>http://lists.osgeo.org/mailman/listinfo/mapguide-users</A><BR></DIV></BLOCKQUOTE></td></tr></table><br>
<!--1--><hr size=1></hr>
The INTERNET now has a personality. YOURS! <a href="http://in.rd.yahoo.com/tagline_yyi_1/*http://in.yahoo.com/" target="_blank">See your Yahoo! Homepage</a>.