[mapguide-users] connection with oracle

Fri Nov 13 05:40:14 EST 2009

Did you use *Oracle Instant Client* or *Oracle Client *version of provider*?
*

On Fri, Nov 13, 2009 at 10:07 AM, manav dayal <manav_dayal85 at yahoo.co.in>wrote:

> I am using mapguide 2.0
> FDO 3.3 with oracle 11g
>
>
> --- On *Fri, 13/11/09, Simon Pelicon <simon at sl-king.com>* wrote:
>
>
> From: Simon Pelicon <simon at sl-king.com>
>
> Subject: Re: [mapguide-users] connection with oracle
> To: "MapGuide Users Mail List" <mapguide-users at lists.osgeo.org>
> Date: Friday, 13 November, 2009, 1:20 PM
>
>
> Yes, oracle provider support also 11g.
>
> Manav:
> I would like do know version of MapGuide Server and version of provider
> used?
> For FDO 3.3 there are two kind of providers, for instant oracle client and
> for oracle client.
>
>
>
> On Fri, Nov 13, 2009 at 8:27 AM, Zac Spitzer <zac.spitzer at gmail.com<http://in.mc941.mail.yahoo.com/mc/compose?to=zac.spitzer@gmail.com>
> > wrote:
>
>> Simon,
>>
>> does king oracle work with 11g client, or just 10g?
>>
>> z
>>
>>
>> On Fri, Nov 13, 2009 at 6:25 PM, Simon Pelicon <simon at sl-king.com<http://in.mc941.mail.yahoo.com/mc/compose?to=simon@sl-king.com>
>> > wrote:
>>
>>> 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<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<http://in.mc941.mail.yahoo.com/mc/compose?to=username/password@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<http://in.rd.yahoo.com/tagline_yyi_1/*http://in.yahoo.com/>
>>>> .
>>>>
>>>> _______________________________________________
>>>> 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
>>
>>
>
> -----Inline Attachment Follows-----
>
>
> _______________________________________________
> 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/478ab27c/attachment.html