[mapguide-users] connection with oracle

[Zac Spitzer]

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