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

Haris Kurtagic haris at sl-king.com
Fri Nov 24 06:59:59 EST 2006


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





More information about the Mapguide_users mailing list