[mapguide-users] RE: RE: Unable to connect to Oracle

[Haris Kurtagic]

Sometimes you are not allowed to add tables/geometries in original Oracle database,
but than free Oracle XE comes in very handy.
You can use Oracle XE to store geometry and create database link to Oracle database with attributes.

Haris

-----Original Message-----
From: Tobias Stranninge [mailto:tobias.stranninge at gmail.com] 
Sent: 24. november 2006 13:03
To: users at mapguide.osgeo.org
Subject: [mapguide-users] RE: RE: Unable to connect to Oracle


Allright, I see. I guess I could always use Fdo2Fdo to move the geometry to Oracle.
 Many thanks for helping us out with this one, Haris!

Tobias


haris kurtagic wrote:
> 
> 
> King.Oracle provider will display tables with geometry in tables.
> 
> If you are trying to use it just for attribute tables, I suspect 
> provider will not be useful ( I am not sure I never tried "join" in MapGuide).
> BTW: My approach would be to move points in Oracle (of course if it is 
> possible..).
> 
> Haris
> 
> -----Original Message-----
> From: Tobias Stranninge [mailto:tobias.stranninge at gmail.com]
> Sent: 24. november 2006 12:49
> To: users at mapguide.osgeo.org
> Subject: [mapguide-users] RE: Unable to connect to Oracle
> 
> 
> Thanks Haris,
> 
> I have managed now to connect to the database with the King provider 
> (by adjusting the server name). Unfortunately, no tables show up. In 
> fact, there isn't even a field for the table, instead I have 'Data 
> file:' in the Studio interface ('Configure a feature resource using 
> the Generic Editor'). What am I doing wrong?
> 
> Cheers,
> 
> Tobias
> 
> 
> 
> haris kurtagic wrote:
>> 
>> Hi,
>> 
>> 
>> 4. This means that ServiceName is not set correctly. 
>>    It can be set like: //MachineName/OracleInstanceName
>>    or if you are using standrad client it can be just tns name.
>> 
>> 
>> Haris
>> 
>> -----Original Message-----
>> From: Tobias Stranninge [mailto:tobias.stranninge at gmail.com]
>> Sent: 24. november 2006 11:27
>> To: users at mapguide.osgeo.org
>> Subject: [mapguide-users] Unable to connect to Oracle
>> 
>> 
>> Hello!
>> 
>> I´m tring to connect to an Oracle database (version 10i) via a System 
>> DSN.
>> This database holds attribut data only, which I plan to join with a 
>> point feature source in my map.
>> 
>> 1. I´ve set up a System DSN in Administrative Tool/ Data Sources.
>> Configuring and testing
>> the connection here using the Oracle ODBC Driver works fine.
>> 
>> 2. In MapGuide Studio, however, using the same System DSN when 
>> configuring and testing an ODBC Database Connection yields the 
>> following
>> error:
>> 
>> "An exception occurred in FDO component.
>> RDBMS: [Oracle][ODBC][Ora]ORA-00922: missing or invalid option"
>>  
>> 3. If I instead configure a System DSN with Microsoft´s Oracle 
>> Driver, and test the connection in Studio  I get the following error message:
>> 
>> "An exception occurred in FDO component.
>> RDBMS: No current open database."
>> 
>> 4. I have also tried using the King.Oracle provider. This gives yet 
>> another error code:
>> 
>> "ORA-12514: TNS:listener does not currently know of service requested 
>> in connect descriptor"
>> 
>>  
>> Any suggestions as to what is casuing these errors?
>> 
>> I have googled and read up about these errror codes, but I afraid I 
>> can't make much sense of it!
>> 
>> FYI: I'm using Mapguide Open Source on Windows XP Pro.
>> 
>> 
>> Many thanks,
>> 
>> Tobias Stranninge
>> --
>> View this message in context:
>> http://www.nabble.com/Unable-to-connect-to-Oracle-tf2697730.html#a752
>> 3
>> 785 Sent from the MapGuide Users mailing list archive at Nabble.com.
>> 
>> 
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: users-unsubscribe at mapguide.osgeo.org
>> For additional commands, e-mail: users-help at mapguide.osgeo.org
>> 
>> 
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: users-unsubscribe at mapguide.osgeo.org
>> For additional commands, e-mail: users-help at mapguide.osgeo.org
>> 
>> 
>> 
> 
> --
> View this message in context:
> http://www.nabble.com/Unable-to-connect-to-Oracle-tf2697730.html#a7525
> 382 Sent from the MapGuide Users mailing list archive at Nabble.com.
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe at mapguide.osgeo.org
> For additional commands, e-mail: users-help at mapguide.osgeo.org
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe at mapguide.osgeo.org
> For additional commands, e-mail: users-help at mapguide.osgeo.org
> 
> 
> 

--
View this message in context: http://www.nabble.com/Unable-to-connect-to-Oracle-tf2697730.html#a7525511
Sent from the MapGuide Users mailing list archive at Nabble.com.


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe at mapguide.osgeo.org
For additional commands, e-mail: users-help at mapguide.osgeo.org