[mapguide-users] Unable to connect to Oracle

[Orest Halustchak]

Hi Tobias,

In the Studio ODBC connection dialog, make sure you use credentials (user/pwd) that have access to the tables owned by the user referenced in the DSN. You might see the "No current open database" error if you don't provide credentials with valid user or user that doesn't have access.

Also, in the ODBC driver configuration, enter the user id in upper case.

Thanks,
Orest.

-----Original Message-----
From: Tobias Stranninge [mailto:tobias.stranninge at gmail.com] 
Sent: Friday, November 24, 2006 5:27 AM
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