Did you use *Oracle Instant Client* or *Oracle Client *version of provider*? *
On Fri, Nov 13, 2009 at 10:07 AM, manav dayal <[email protected]>wrote: > I am using mapguide 2.0 > FDO 3.3 with oracle 11g > > > --- On *Fri, 13/11/09, Simon Pelicon <[email protected]>* wrote: > > > From: Simon Pelicon <[email protected]> > > Subject: Re: [mapguide-users] connection with oracle > To: "MapGuide Users Mail List" <[email protected]> > Date: Friday, 13 November, 2009, 1:20 PM > > > Yes, oracle provider support also 11g. > > Manav: > I would like do know version of MapGuide Server and version of provider > used? > For FDO 3.3 there are two kind of providers, for instant oracle client and > for oracle client. > > > > On Fri, Nov 13, 2009 at 8:27 AM, Zac Spitzer > <[email protected]<http://in.mc941.mail.yahoo.com/mc/[email protected]> > > wrote: > >> Simon, >> >> does king oracle work with 11g client, or just 10g? >> >> z >> >> >> On Fri, Nov 13, 2009 at 6:25 PM, Simon Pelicon >> <[email protected]<http://in.mc941.mail.yahoo.com/mc/[email protected]> >> > wrote: >> >>> Hi! >>> for SERVICE NAME enter: >>> 1. if you use Oracle instant client use (as Zac answered) oracle easy >>> connect syntax: //servername/orcl >>> 2. if you use Oracle client than enter your oracle Service name specified >>> in client >>> >>> SCHEMA (optional parameter) >>> "OracleSchema" determines if all raws from ALL_SDO_GEOM_METADATA will be >>> used or just rows with Owner equal to "OracleSchema" >>> >>> KINGFDOCLASS (optional parameter) >>> if you want that provider uses additional Oracle Table to describe FDO >>> classes. >>> >>> To connect you need username,password and valid service name. >>> >>> >>> >>> On Fri, Nov 13, 2009 at 5:06 AM, manav dayal >>> <[email protected]<http://in.mc941.mail.yahoo.com/mc/[email protected]> >>> > wrote: >>> >>>> 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. >>>> >>>> when i use sql prompt, it works fine with >>>> username/passw...@orcl<http://in.mc941.mail.yahoo.com/mc/compose?to=username/passw...@orcl> >>>> . >>>> >>>> I need to know what should be written inside the text boxes for service, >>>> schema and king FDO class or do i need to make any other connection >>>> settings. >>>> >>>> >>>> --- On *Thu, 12/11/09, Zac Spitzer >>>> <[email protected]<http://in.mc941.mail.yahoo.com/mc/[email protected]> >>>> >* wrote: >>>> >>>> >>>> From: Zac Spitzer >>>> <[email protected]<http://in.mc941.mail.yahoo.com/mc/[email protected]> >>>> > >>>> Subject: Re: [mapguide-users] connection with oracle >>>> To: "MapGuide Users Mail List" >>>> <[email protected]<http://in.mc941.mail.yahoo.com/mc/[email protected]> >>>> > >>>> Date: Thursday, 12 November, 2009, 6:04 PM >>>> >>>> it is purely a error with the service name >>>> >>>> ORA-12154: TNS:could not resolve the connect identifier specified >>>> >>>> is a native error code from oracle >>>> >>>> what are your connection settings? >>>> >>>> z >>>> >>>> >>>> >>>> On Thu, Nov 12, 2009 at 11:01 PM, Dejan Gregor >>>> <[email protected]<http://in.mc941.mail.yahoo.com/mc/[email protected]>> >>>> wrote: >>>> > >>>> > Do you have an Oracle client installed from where you are connecting? >>>> > Dejan >>>> > >>>> > On Thu, Nov 12, 2009 at 12:58, manav dayal >>>> > <[email protected]<http://in.mc941.mail.yahoo.com/mc/[email protected]>> >>>> wrote: >>>> >> >>>> >> >>>> >> I am using maestro1.0 and trying to connect to the remote database >>>> server. >>>> >> When I choose to make a new data connection with >>>> OSGeo.KingOracle.3.3 as the >>>> >> provider for oracle. >>>> >> >>>> >> Following error is being thrown when I try to test the connection. >>>> >> >>>> >> >>>> >> The remote server returned an error: (559) MgFdoException.: >>>> >> An exception occurred in FDO component. >>>> >> ORA-12154: TNS:could not resolve the connect identifier specified >>>> >> 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 >>>> >> >>>> >> kindly help asap. >>>> >> Regards. >>>> >> >>>> >> ________________________________ >>>> >> The INTERNET now has a personality. YOURS! See your Yahoo! Homepage. >>>> >> _______________________________________________ >>>> >> mapguide-users mailing list >>>> >> [email protected]<http://in.mc941.mail.yahoo.com/mc/[email protected]> >>>> >> http://lists.osgeo.org/mailman/listinfo/mapguide-users >>>> >> >>>> > >>>> > >>>> > _______________________________________________ >>>> > mapguide-users mailing list >>>> > [email protected]<http://in.mc941.mail.yahoo.com/mc/[email protected]> >>>> > http://lists.osgeo.org/mailman/listinfo/mapguide-users >>>> > >>>> >>>> >>>> >>>> -- >>>> Zac Spitzer >>>> Solution Architect / Director >>>> Ennoble Consultancy Australia >>>> http://www.ennoble.com.au >>>> http://zacster.blogspot.com >>>> +61 405 847 168 >>>> _______________________________________________ >>>> mapguide-users mailing list >>>> [email protected]<http://in.mc941.mail.yahoo.com/mc/[email protected]> >>>> http://lists.osgeo.org/mailman/listinfo/mapguide-users >>>> >>>> >>>> ------------------------------ >>>> The INTERNET now has a personality. YOURS! See your Yahoo! >>>> Homepage<http://in.rd.yahoo.com/tagline_yyi_1/*http://in.yahoo.com/> >>>> . >>>> >>>> _______________________________________________ >>>> mapguide-users mailing list >>>> [email protected]<http://in.mc941.mail.yahoo.com/mc/[email protected]> >>>> http://lists.osgeo.org/mailman/listinfo/mapguide-users >>>> >>>> >>> >>> _______________________________________________ >>> mapguide-users mailing list >>> [email protected]<http://in.mc941.mail.yahoo.com/mc/[email protected]> >>> http://lists.osgeo.org/mailman/listinfo/mapguide-users >>> >>> >> >> >> -- >> Zac Spitzer >> Solution Architect / Director >> Ennoble Consultancy Australia >> http://www.ennoble.com.au >> http://zacster.blogspot.com >> +61 405 847 168 >> >> >> >> >> _______________________________________________ >> mapguide-users mailing list >> [email protected]<http://in.mc941.mail.yahoo.com/mc/[email protected]> >> http://lists.osgeo.org/mailman/listinfo/mapguide-users >> >> > > -----Inline Attachment Follows----- > > > _______________________________________________ > mapguide-users mailing list > [email protected]<http://in.mc941.mail.yahoo.com/mc/[email protected]> > http://lists.osgeo.org/mailman/listinfo/mapguide-users > > > ------------------------------ > The INTERNET now has a personality. YOURS! See your Yahoo! > Homepage<http://in.rd.yahoo.com/tagline_yyi_1/*http://in.yahoo.com/> > . > > _______________________________________________ > mapguide-users mailing list > [email protected] > http://lists.osgeo.org/mailman/listinfo/mapguide-users > >
_______________________________________________ mapguide-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapguide-users
