Unable to connect to Oracle

[Tobias Stranninge]

Hi Orest,

I checked all my settings as per your suggestions - but nothing. Then I
decided to switch back to the Microsoft Oracle Driver instead of using the
driver provided by Oracle Client, adjusted the TNS service name - and what
do you know - the tables now show up i Studio! This calls for a pint or two,
methinks...

Thanks for your help and have a good weekend! /Tobias


Orest Halustchak wrote:
> 
> 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
> 
> 
> 
> ---------------------------------------------------------------------
> 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#a7526968
Sent from the MapGuide Users mailing list archive at Nabble.com.