Oracle connection string with TNS

sfu-db / connector-x

Fastest library to load data from DB to DataFrames in Rust and Python

https://sfu-db.github.io/connector-x

MIT License

1.99k stars 161 forks source link

Oracle connection string with TNS #484

Open yxiao315 opened 1 year ago

yxiao315 commented 1 year ago

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?

mondjef commented 3 months ago

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