try using the oracle easy connect syntax //BIGSERVER/DEV01
which in your case will be //servername/orcl z On Fri, Nov 13, 2009 at 3:06 PM, manav dayal <[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. > > 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]> wrote: > > From: Zac Spitzer <[email protected]> > Subject: Re: [mapguide-users] connection with oracle > To: "MapGuide Users Mail List" <[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]> 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]> > > 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://lists.osgeo.org/mailman/listinfo/mapguide-users > >> > > > > > > _______________________________________________ > > 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 > > ________________________________ > The INTERNET now has a personality. YOURS! See your Yahoo! Homepage. > _______________________________________________ > 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
