[mapguide-users] connection with oracle

[Simon Pelicon]

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 <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<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<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
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapguide-users/attachments/20091113/109b448e/attachment.html