try //servername/orcl instead of just orcl<br><br><div class="gmail_quote">On Tue, Nov 17, 2009 at 8:29 PM, manav dayal <span dir="ltr"><<a href="mailto:manav_dayal85@yahoo.co.in">manav_dayal85@yahoo.co.in</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><table border="0" cellpadding="0" cellspacing="0"><tbody><tr><td style="font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-size: inherit; line-height: inherit; font-size-adjust: inherit; font-stretch: inherit;" valign="top">
<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><div class="im">The remote server returned an error: (559) MgFdoException.: <br>An exception occurred in FDO component.<br></div>ORA-12560: TNS:protocol adapter error</div><div class="im">
<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><div><br>when I provide the orcl in the text box labelled service it gives the following error;</div><div class="im">
<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><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" target="_blank">username/password@orcl</a></div>
<div> </div>
<div> </div>
<div> </div>
<div><div class="im">I am using mapguide 2.0<br></div>FDO 3.3 and windows 2003 server.</div>
<div> </div>
<div>Can anybody help!</div>
<div> </div>
<div>Regards</div>
<div>Manav</div><div class="im">
<div> </div>
<div> </div>
<div><br>--- On <b>Fri, 13/11/09, Simon Pelicon <i><<a href="mailto:simon@sl-king.com" target="_blank">simon@sl-king.com</a>></i></b> wrote:<br></div>
</div><blockquote style="border-left: 2px solid rgb(16, 16, 255); padding-left: 5px; margin-left: 5px;"><div class="im"><br>From: Simon Pelicon <<a href="mailto:simon@sl-king.com" target="_blank">simon@sl-king.com</a>><br>
Subject: Re: [mapguide-users] connection with oracle<br>To: "MapGuide Users Mail List" <<a href="mailto:mapguide-users@lists.osgeo.org" target="_blank">mapguide-users@lists.osgeo.org</a>><br></div>Date: Friday, 13 November, 2009, 4:10 PM<div>
<div></div><div class="h5"><br><br>
<div>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">manav_dayal85@yahoo.co.in</a>></span> wrote:<br>
<blockquote style="border-left: 1px solid rgb(204, 204, 204); margin: 0px 0px 0px 0.8ex; padding-left: 1ex;" class="gmail_quote">
<table border="0" cellpadding="0" cellspacing="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">simon@sl-king.com</a>></i></b> wrote:<br></div>
<blockquote style="border-left: 2px solid rgb(16, 16, 255); 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">simon@sl-king.com</a>>
<div><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>
</div>Date: Friday, 13 November, 2009, 1:20 PM
<div>
<div></div>
<div><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: 1px solid rgb(204, 204, 204); 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: 1px solid rgb(204, 204, 204); 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: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;" class="gmail_quote">
<table border="0" cellpadding="0" cellspacing="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: 2px solid rgb(16, 16, 255); 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><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><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">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>_______________________________________________<br>mapguide-users mailing list<br><a href="http://in.mc941.mail.yahoo.com/mc/compose?to=mapguide-users@lists.osgeo.org" target="_blank">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></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/" target="_blank">See your Yahoo! Homepage</a>.</div></div><br>_______________________________________________<br>
mapguide-users mailing list<br>
<a href="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>
<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">http://www.ennoble.com.au</a><br><a href="http://zacster.blogspot.com">http://zacster.blogspot.com</a><br>
+61 405 847 168<br><br><br><br>