Connecting to Oracle error with oracledb
bnewman-tech opened this issue · 2 comments
What language are you using?
Python
What version are you using?
0.3.2 on a Macbook M1 Max Machine
What database are you using?
Oracle
What dataframe are you using?
Pandas and/or Polars
Can you describe your bug?
I am trying to use oracledb thin mode driver with connector-x without installing the Oracle Client. Is this possible and if so, what I am doing wrong?
Example query / code
import connectorx as cx
ENGINE_PATH = "oracle+oracledb://username:password@host:post/service_name"
query = "select * from table" # query string
cx.read_sql(ENGINE_PATH, query)
What is the error?
[2023-11-01T02:17:30Z ERROR r2d2] DPI Error: DPI-1047: Cannot locate a 64-bit Oracle Client library:
"dlopen(libclntsh.dylib, 0x0001): tried: 'libclntsh.dylib' (no such file),
'/System/Volumes/Preboot/Cryptexes/OSlibclntsh.dylib' (no such file), '/usr/lib/libclntsh.dylib'
'(no such file, not in dyldcache), 'libclntsh.dylib' (no such file), '/usr/lib/libclntsh.dylib'
(no such file, not in dyld cache)". See https://oracle.github.io/odpi/doc/installation.html#macos for help
I'm wondering about the same thing! Any progress?
Good morning,
I wanted to talk a moment to follow up on this and see if it is possible to use the thin driver https://oracle.github.io/python-oracledb/?