Unable to connect to Oracle

[Tobias Stranninge]

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#a7523
>> 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#a7525382
> 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.