Clever Geek Handbook

Connecting to Oracle ODBC via Pyodbc (32-bit or 64-bit)

I know similar questions have been asked before and I still can't seem to solve my problem by looking at these Qs and their A. Here's a similar problem.

This is my problem. At work, I have the following:

  • Windows machine (64 bit)
  • Python (64 bit)
  • Pyodbc module (64 bit)
  • Oracle ODBC Driver (32 bit, only 32 bit can be used here)

When I execute the following line:

cnxn = pyodbc.connect(driver='{____}', dsn='____', uid='____', pwd='____')

I am getting the following error

Error: ('IM014', '[IM014] [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application (0) (SQLDriverConnect)')

I looked at the file odbcad32.exe

in the System32 and SysWOW64 folders. Both files contain the same information as both exe files show the 32-bit Oracle driver.

What else can I do?

+3


source to share


1 answer


As suggested by Brian Ergl, above, keep windows 64bit, but do the rest all 64bit or 32bit. I have Python, Pyodbc and Oracle ODBC all in 32-bit and now they are talking to each other.



+1


source






More articles:


All Articles