Hi!<div>for SERVICE NAME enter:</div><div>1. if you use Oracle instant client <span class="Apple-style-span" style="font-family: arial, sans-serif; font-size: 13px; border-collapse: collapse; ">use (as Zac answered) oracle easy connect syntax</span>: <span class="Apple-style-span" style="font-family: arial, sans-serif; font-size: 13px; border-collapse: collapse; ">//servername/orcl </span></div>
<div><span class="Apple-style-span" style="font-family: arial, sans-serif; font-size: 13px; border-collapse: collapse; ">2. if you use Oracle client than enter your oracle Service name specified in client</span></div><div>
<span class="Apple-style-span" style="font-family: arial, sans-serif; font-size: 13px; border-collapse: collapse; "><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><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="mailto:manav_dayal85@yahoo.co.in">manav_dayal85@yahoo.co.in</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;"><table cellspacing="0" cellpadding="0" border="0"><tbody><tr><td valign="top" style="font:inherit"><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="mailto:username/password@orcl" 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="mailto:zac.spitzer@gmail.com" 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="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>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" 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></div></blockquote></td></tr></tbody></table><div class="hm"><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><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></div></div>