try //servername/orcl instead of just orcl On Tue, Nov 17, 2009 at 8:29 PM, manav dayal <[email protected]>wrote:
> hi everybody > > my problem is still persisting. > > I am having oracle 11g installed on my machine and I am trying to connect > to a > remote machine also having oracle 11g using the mapguide maestro 1.0.9. > I am opting for new data connection and choosing OSGeo FDO provider for > Oracle. > > Now > When I opt for specified credentials and provide username and password it > gives > the following error on clicking the test connection: > > The remote server returned an error: (559) MgFdoException.: > An exception occurred in FDO component. > ORA-12560: TNS:protocol adapter error > 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 > > > when I provide the orcl in the text box labelled service it gives the > following error; > > 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 > > Connection works fine > when I use the following on the sql prompt: > > username/passw...@orcl > > > > I am using mapguide 2.0 > FDO 3.3 and windows 2003 server. > > Can anybody help! > > Regards > Manav > > > > --- 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, 4:10 PM > > > 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]<http://in.mc941.mail.yahoo.com/mc/[email protected]> > > wrote: > >> I am using mapguide 2.0 >> FDO 3.3 with oracle 11g >> >> >> --- On *Fri, 13/11/09, Simon Pelicon >> <[email protected]<http://in.mc941.mail.yahoo.com/mc/[email protected]> >> >* wrote: >> >> >> From: Simon Pelicon >> <[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: 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://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 > > -- 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://lists.osgeo.org/mailman/listinfo/mapguide-users
