[mapguide-users] connection with oracle
Zac Spitzer
zac.spitzer at gmail.com
Tue Nov 17 05:30:21 EST 2009
try //servername/orcl instead of just orcl
On Tue, Nov 17, 2009 at 8:29 PM, manav dayal <manav_dayal85 at yahoo.co.in>wrote:
> hi everybody
>
> my problem is still persisting.
>
> I am having oracle 11g installed on my machine and I am trying to connect
> to a
> remote machine also having oracle 11g using the mapguide maestro 1.0.9.
> I am opting for new data connection and choosing OSGeo FDO provider for
> Oracle.
>
> Now
> When I opt for specified credentials and provide username and password it
> gives
> the following error on clicking the test connection:
>
> The remote server returned an error: (559) MgFdoException.:
> An exception occurred in FDO component.
> ORA-12560: TNS:protocol adapter error
> 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
>
>
> when I provide the orcl in the text box labelled service it gives the
> following error;
>
> 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
>
> Connection works fine
> when I use the following on the sql prompt:
>
> username/password at orcl
>
>
>
> I am using mapguide 2.0
> FDO 3.3 and windows 2003 server.
>
> Can anybody help!
>
> Regards
> Manav
>
>
>
> --- 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, 4:10 PM
>
>
> 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<http://in.mc941.mail.yahoo.com/mc/compose?to=manav_dayal85@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<http://in.mc941.mail.yahoo.com/mc/compose?to=simon@sl-king.com>
>> >* wrote:
>>
>>
>> From: Simon Pelicon <simon at sl-king.com<http://in.mc941.mail.yahoo.com/mc/compose?to=simon@sl-king.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: 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://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
>
>
--
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/20091117/f23748e5/attachment.html
More information about the mapguide-users
mailing list