Python to Oracle Conn Issue

[chvsnarayana]

Hi All,

In my Windows 10 64 Bit OS, installed Oracle 10g database of 32 Bit and Python 3.7.9 version of 64 Bit.

When I am trying to connect Oracle Db from Python, I am facing below error.

cx_Oracle.DatabaseError: DPI-1047: Cannot locate a 64-bit Oracle Client library: "F:\oracle\product\10.2.0\db_1\bin\oci.dll is not the correct architecture".


Whether is it possible to connect from Python 64 Bit to Oracle database 10g 32 Bit? Is there any way to resolve the issue?

Or I need to install Oracle database of 64 Bit?

Thanks in advance.
Satyam

[oradba4u]

just curious if you can connect to Oracle thru ODBC

https://www.devart.com/odbc/oracle/docs/python.htm

[Larz60+]

Sqlalchemy makes connecting to many databases a pleasure.
Works with most DBMS platforms including: Oracle, Sqlite, Postgresql, MySql, Microsoft SQL server
see: https://docs.sqlalchemy.org/en/13/dialects/
Changing from one DBMS to another is normally a change to just one line (Model may have to be modified some for data type differences)

Key Features of SQLAlchemy: https://www.sqlalchemy.org/features.html

if I've got you interested, I also have a tutorial on this forum here: https://python-forum.io/Thread-SqlAlchem...-Data-Load