[mapguide-users] Unable to connect to Oracle

[Haris Kurtagic]

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