Thanks Julien for your suggestions. I don't think I managed to make it work
like that.
Is there anyone who has connected QGIS to an Oracle DB with a proxy user?
Il giorno mar 14 nov 2023 alle ore 08:56 Julien Cabieces <
julien.cabie...@oslandia.com> ha scritto:
>
> In order to set the environment
In order to set the environment variable, you can follow this procedure
[0]
Regarding the Oracle client version, It is either oci-19-8 or oci-19-11
[1], but I would say that both has to work the same way.
[0]
https://www.howtogeek.com/787217/how-to-edit-environment-variables-on-windows-10-or-1
Yes I have also tried using the tnsnames.ora alternative, byut in that case
I have a doubt about where to set the TNS_ADMIN, in case of a standard Win
11 QGis installation. Could you suggest ? Also, what is the Oracle client /
version used by QGis? Thanks
Il giorno lun 13 nov 2023 alle ore 10:33 J
Hi,
Did you try to use a tnsnames.ora file ?
You can then set the environment variable TNS_ADMIN to point to the
directory which contains the file and then refer to the connexion in
QGIS with the "database name" (dbname in QGIS uri), no host and port
specified.
I have no expertise in configuri
Hi,
I have to connect to Oracle DBs for my work with a "proxy" user (security
requirements) and I normally make it with SQLDeveloper, setting it up like:
username: MY_USER[DB_USER]
password: << MY_USER password >>
connection type: Base
host: << DB host address >>
port: << DB port >>
service: << D
