I am using sqlalchemy 1.4.22 and cx oracle 8.2.1 to connect to production and development environments that each host a similar copy of the same schema.
The connection string that I use is the same for each excluding the password: oracle+cx_oracle://user:pass@MyTNS Dev works without a problem, but prod throws an Oracle error: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor We can connect using sqlplus with the same credentials and tns id, any idea why it may not work for one environment? Thanks, jlc -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See http://stackoverflow.com/help/mcve for a full description. --- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/sqlalchemy/d7c9617c-b749-4149-9439-1212c72455dfn%40googlegroups.com.