[mapguide-users] connection with oracle

[Zac Spitzer]

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> 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> 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: 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> 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> 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://lists.osgeo.org/mailman/listinfo/mapguide-users
> >>
> >
> >
> > _______________________________________________
> > 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
> _______________________________________________
> mapguide-users mailing list
> mapguide-users at 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://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