Open mellasmpa opened 1 month ago
Hi
I've been having the same problem when using the latest version of connectorx. However, I had an old environement with connectorx==0.3.2
and that version works with MS SQL Server without any issue. Not sure what changed between that version and the latest version. I can't verify with oracle as I have not figured out the oracle syntax for connecting with a tns yet. Hope this helps a little.
What language are you using?
Replace this text with the Python.
What version are you using?
I am using python 3.11.5
What database are you using?
Oracle and Sqlserver
What dataframe are you using?
Pandas
Can you describe your bug?
create_engine(mssql+pyodbc://username:password@ip\EBMV1PRO/CISBackOffice?driver=ODBC+Driver+17+for+SQL+Server)
. I would be glad to a connectorx uri version.What are the steps to reproduce the behavior?
If possible, please include a minimal simple example including:
Database setup if the error only happens on specific data or data type
Table schema and example data
Example query / code
What is the error?
RuntimeError: timed out waiting for connection: OCI Error: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor