how set cx_Oracle.connect timeout

[984958198]

linux is set sqlnet.ora, How to configure on windows?

windows 7 x64
python2.7
cx_Oracle version = '7.2.2'
instantclient-basic-windows.x64-11.2.0.4.0.zip

[anthony-tuininga]

The simplest approach is to create a directory and put sqlnet.ora in that directory, then set the environment variable TNS_ADMIN to point to that directory. Newer versions of the instant client will create the network/admin subdirectory and you can put sqlnet.ora in that directory instead and not have to set the environment variable.

[cjbj]

For people coming across this thread, config file location is documented in https://cx-oracle.readthedocs.io/en/latest/user_guide/connection_handling.html#optional-oracle-net-configuration-files

You can manually create the subdirectory instantclient_11_2/network/admin and put the files there.

For connection timeout parameters, consider SQLNET.OUTBOUND_CONNECT_TIMEOUT or TCP.CONNECT_TIMEOUT which need to be in the sqlnet.ora file.