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="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>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="mailto:simon@sl-king.com" target="_blank">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="mailto:simon@sl-king.com" target="_blank">simon@sl-king.com</a>><div class="im"><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, 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" 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></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>