Unable to connect to Oracle

[Tobias Stranninge]

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#a7523785
> 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.