[mapguide-users] connection with oracle

[Simon Pelicon]

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