Open qgib opened 10 years ago
Author Name: Jürgen Fischer (@jef-n)
Did you set the @TNS_ADMIN@ environment variable to the directory where your @tnsnames.ora@ is?
Author Name: Jonathan Moules (Jonathan Moules)
My mistake - this is already in there and no TNS_ADMIN is needed. It's not "SID" that is used, it's SERVICE_NAME. Apologies for my confusion.
If I just fill in the "database" as SERVICE_NAME/GLOBAL_NAME, and leave host blank, then it works fine.
So my feature request changes:
Author Name: Carlo Copat (Carlo Copat)
Good morning, I have a problem with the connection to the spatial data with oracle. When I go to test the connection oracle gives me this error: ORA-12705 Can not access NLS data files or invalid environment specified. Unable to connect. If I run the same connection with SQL Navigator everything is working perfectly. You need to set some specific parameter in QGIS? thanks
Author Name: Jonathan Moules (Jonathan Moules)
Hi Carlo, I don't think that's the same issue. You might want to ask on the QGIS mailing list - http://www.qgis.org/en/site/forusers/support.html#mailing-lists
Author Name: Giovanni Manghi (@gioman)
Author Name: Jürgen Fischer (@jef-n)
Author Name: Jonathan Moules (Jonathan Moules) Original Redmine Issue: 8666
Redmine category:data_provider/oracle
Currently (2.0.1) to connect to Oracle you need to know the Host details (IP and port). This is redundant because it is stored in TNS-names.
In theory all that is required is either SID or SERVICE_NAME/GLOBAL_NAME which can then lookup the details. FME does it this way and it works well, maybe QGIS can do it too.