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.auhttp://zacster.blogspot.com+61 405 847 168
_______________________________________________
mapguide-users mailing list
[email protected]http://lists.osgeo.org/mailman/listinfo/mapguide-users