[mapguide-users] connection with oracle

[manav dayal]

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