[mapguide-users] connection with oracle

Zac Spitzer zac.spitzer at gmail.com
Fri Nov 13 02:01:56 EST 2009


are you using the instant client or a full oracle client?

which version?

z

On Fri, Nov 13, 2009 at 6:00 PM, manav dayal <manav_dayal85 at yahoo.co.in>wrote:

> Error is still persisting. Is there any alternative way.
>
> Do we need to include any value in the King FDO class text box.
>
>
> -- - On *Fri, 13/11/09, Zac Spitzer <zac.spitzer at gmail.com>* wrote:
>
>
> From: Zac Spitzer <zac.spitzer at gmail.com>
> Subject: Re: [mapguide-users] connection with oracle
> To: "MapGuide Users Mail List" <mapguide-users at lists.osgeo.org>
> Date: Friday, 13 November, 2009, 9:46 AM
>
>
> 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 <manav_dayal85 at yahoo.co.in<http://in.mc941.mail.yahoo.com/mc/compose?to=manav_dayal85@yahoo.co.in>>
> 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/password at 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 <zac.spitzer at gmail.com<http://in.mc941.mail.yahoo.com/mc/compose?to=zac.spitzer@gmail.com>>
> wrote:
> >
> > From: Zac Spitzer <zac.spitzer at gmail.com<http://in.mc941.mail.yahoo.com/mc/compose?to=zac.spitzer@gmail.com>
> >
> > Subject: Re: [mapguide-users] connection with oracle
> > To: "MapGuide Users Mail List" <mapguide-users at lists.osgeo.org<http://in.mc941.mail.yahoo.com/mc/compose?to=mapguide-users@lists.osgeo.org>
> >
> > 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 <dejan.gregor at gmail.com<http://in.mc941.mail.yahoo.com/mc/compose?to=dejan.gregor@gmail.com>>
> wrote:
> > >
> > > Do you have an Oracle client installed from where you are connecting?
> > > Dejan
> > >
> > > On Thu, Nov 12, 2009 at 12:58, manav dayal <manav_dayal85 at yahoo.co.in<http://in.mc941.mail.yahoo.com/mc/compose?to=manav_dayal85@yahoo.co.in>>
> 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
> > >> mapguide-users at lists.osgeo.org<http://in.mc941.mail.yahoo.com/mc/compose?to=mapguide-users@lists.osgeo.org>
> > >> http://lists.osgeo.org/mailman/listinfo/mapguide-users
> > >>
> > >
> > >
> > > _______________________________________________
> > > mapguide-users mailing list
> > > mapguide-users at lists.osgeo.org<http://in.mc941.mail.yahoo.com/mc/compose?to=mapguide-users@lists.osgeo.org>
> > > 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
> > mapguide-users at lists.osgeo.org<http://in.mc941.mail.yahoo.com/mc/compose?to=mapguide-users@lists.osgeo.org>
> > http://lists.osgeo.org/mailman/listinfo/mapguide-users
> >
> > ________________________________
> > The INTERNET now has a personality. YOURS! See your Yahoo! Homepage.
> > _______________________________________________
> > mapguide-users mailing list
> > mapguide-users at lists.osgeo.org<http://in.mc941.mail.yahoo.com/mc/compose?to=mapguide-users@lists.osgeo.org>
> > 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
> mapguide-users at lists.osgeo.org<http://in.mc941.mail.yahoo.com/mc/compose?to=mapguide-users@lists.osgeo.org>
> 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
> mapguide-users at lists.osgeo.org
> 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapguide-users/attachments/20091113/2aa3442e/attachment.html


More information about the mapguide-users mailing list