are you using the instant client or a full oracle client?<br><br>which version?<br><br>z<br><br><div class="gmail_quote">On Fri, Nov 13, 2009 at 6:00 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>Error is still persisting. Is there any alternative way.</div>
<div> </div>
<div>Do we need to include any value in the King FDO class text box.<div class="im"><br><br>-- - On <b>Fri, 13/11/09, Zac Spitzer <i><<a href="mailto:zac.spitzer@gmail.com" target="_blank">zac.spitzer@gmail.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: Zac Spitzer <<a href="mailto:zac.spitzer@gmail.com" target="_blank">zac.spitzer@gmail.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, 9:46 AM<div>
<div></div><div class="h5"><br><br>
<div>try using the oracle easy connect syntax<br><br>//BIGSERVER/DEV01<br><br>which in your case will be<br><br>//servername/orcl<br><br>z<br><br>On Fri, Nov 13, 2009 at 3:06 PM, manav dayal <<a href="http://in.mc941.mail.yahoo.com/mc/compose?to=manav_dayal85@yahoo.co.in" target="_blank">manav_dayal85@yahoo.co.in</a>> wrote:<br>
><br>> 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.<br>><br>> when i use sql prompt, it works fine with username/password@orcl.<br>
><br>> I need to know what should be written inside the text boxes for service,<br>> schema and king FDO class or do i need to make any other connection settings.<br>><br>> --- On Thu, 12/11/09, Zac Spitzer <<a href="http://in.mc941.mail.yahoo.com/mc/compose?to=zac.spitzer@gmail.com" target="_blank">zac.spitzer@gmail.com</a>> wrote:<br>
><br>> From: Zac Spitzer <<a href="http://in.mc941.mail.yahoo.com/mc/compose?to=zac.spitzer@gmail.com" 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" target="_blank">mapguide-users@lists.osgeo.org</a>><br>> Date: Thursday, 12 November, 2009, 6:04 PM<br>
><br>> 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" 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" 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" 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>> >><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" 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>
> ><br>><br>><br>><br>> --<br>> Zac Spitzer<br>> Solution Architect / Director<br>> Ennoble Consultancy Australia<br>> <a href="http://www.ennoble.com.au/" target="_blank">http://www.ennoble.com.au</a><br>
> <a href="http://zacster.blogspot.com/" 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" 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>><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" 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>><br><br><br><br>--<br>Zac Spitzer<br>Solution Architect / Director<br>
Ennoble Consultancy Australia<br><a href="http://www.ennoble.com.au/" target="_blank">http://www.ennoble.com.au</a><br><a href="http://zacster.blogspot.com/" 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" 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>