Architecture incompatibility between drive and app

Asked

Viewed 1,857 times

1

I’m trying to access data from a database using pyodbc with this code:

import pyodbc
cnxn = pyodbc.connect("DSN=banco;uid=usuario;pwd=senha")
cursor = cnxn.cursor()

But when I make that mistake:

pyodbc. Error: ('IM014', '[IM014] [Microsoft][ODBC Driver Manager] O DSN specified contains an architecture incompatibility between the Driver and the App (0) (Sqldriverconnect)')

Does anyone know where I can fix this incompatibility?

python-3.x odbc

  • If you understand English, maybe these links help https://dacosta9.wordpress.com/2011/10/27/error-im014-microsoftodbc-driver-manager-the-specified-dsn-contains-an-architecture-mismatch-between-the-driver-and-application/ , http://stackoverflow.com/questions/21395492/error--im014-microsoftodbc-driver-manager-the-specified-dsn-contains-an-Arc

  • 1

    Thanks Miguel. From what I understand, I need to change the obbc32 driver to the 64. On the machine I am using already exists this file: c: windows syswow64 odbcad32.exe, you know tell me where I change this setting?

  • I have no idea, I looked for these links but I never went through it

1 answer

1

I resolved.

The solution was to actually download a 64bit drive (architecture of my machine) and set up a new connection, more or less like this one video.

Browser other questions tagged python-3.x odbc

You are not signed in. Login or sign up in order to post.