[mapguide-users] connection with oracle

[manav dayal]

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> 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> 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> 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://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




The INTERNET now has a personality. YOURS! See your Yahoo! Homepage.
_______________________________________________
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



-----Inline Attachment Follows-----


_______________________________________________
mapguide-users mailing list
mapguide-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapguide-users



      The INTERNET now has a personality. YOURS! See your Yahoo! Homepage. http://in.yahoo.com/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapguide-users/attachments/20091113/a6d9209f/attachment.html