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/passw...@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 <[email protected]> wrote:
From: Simon Pelicon <[email protected]>
Subject: Re: [mapguide-users] connection with oracle
To: "MapGuide Users Mail List" <[email protected]>
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 <[email protected]> wrote:
I am using mapguide 2.0
FDO 3.3 with oracle 11g
--- On Fri, 13/11/09, Simon Pelicon <[email protected]> wrote:
From: Simon Pelicon <[email protected]>
Subject: Re: [mapguide-users] connection with oracle
To: "MapGuide Users Mail List" <[email protected]>
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 <[email protected]> wrote:
Simon,
does king oracle work with 11g client, or just 10g?
z
On Fri, Nov 13, 2009 at 6:25 PM, Simon Pelicon <[email protected]> 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 <[email protected]> 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/passw...@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 <[email protected]> wrote:
From: Zac Spitzer <[email protected]>
Subject: Re: [mapguide-users] connection with oracle
To: "MapGuide Users Mail List" <[email protected]>
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 <[email protected]> wrote:
>
> Do you have an Oracle client installed from where you are connecting?
> Dejan
>
> On Thu, Nov 12, 2009 at 12:58, manav dayal <[email protected]> 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
>> [email protected]
>> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>>
>
>
> _______________________________________________
> mapguide-users mailing list
> [email protected]
> 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
[email protected]
http://lists.osgeo.org/mailman/listinfo/mapguide-users
The INTERNET now has a personality. YOURS! See your Yahoo! Homepage.
_______________________________________________
mapguide-users mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/mapguide-users
_______________________________________________
mapguide-users mailing list
[email protected]
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
[email protected]
http://lists.osgeo.org/mailman/listinfo/mapguide-users
-----Inline Attachment Follows-----
_______________________________________________
mapguide-users mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/mapguide-users
The INTERNET now has a personality. YOURS! See your Yahoo! Homepage.
_______________________________________________
mapguide-users mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/mapguide-users
-----Inline Attachment Follows-----
_______________________________________________
mapguide-users mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/mapguide-users
The INTERNET now has a personality. YOURS! See your Yahoo! Homepage.
http://in.yahoo.com/_______________________________________________
mapguide-users mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/mapguide-users
