sfu-db/connector-x

Oracle connection string with TNS

yxiao315 opened this issue · 1 comments

By using conn = 'oracle://username:password@server:port/database' I can connect to Oracle , but How I can use TNS entry name in connectorx? for example, in cx_Oracle, it can be done like this: conn = cx_Oracle.connect(dsn="the_tns_entry_name"). Is there similar way to do it in connectorx? Since in my tns entry, it doesn't need user id and password, seems like Windows Authentication.

Or how to use connectorx connect to Oracle by Window authentication?

also wondering how to use TNS.... I have been able to connect using cx_Oracle with TNS but have been unsuccessful getting connectorX to connect to same oracle db. I have tried various combinations of connection string based on info in the tnsnames.ora file