The specified DSN contains an architecture mismatch between the Driver and Application. Error for new project, existing projects have no issue with the database config

Hello all,

I have a new project where Im encountering this error “The specified DSN contains an architecture mismatch between the Driver and Application”

Im confused as to why this is occurring, I have a handful of automations using the same environment variables/odbc connection that are able to connect to my database with no issue, its just a problem with this new project.

The only difference I see is that my old projects are windows legacy
image

Whereas my new project just say windows
image

Could this be the issue?

@Muslimani_Benjamin_USA

Welcome to forums

Can you check which ODBC you are connected to i.e., 32 bit or 64 bit

If not working on 32 bit try to see 64 bit

Thanks,
Srini

its 32 bit, i cant set up 64 bit because the database driver i need isnt available (oracle in oracle_odbc).

why would UiPath suddenly have issues with my odbc config if i have other automations using the same connection? I’m only having this issue with a new project I made

The problem is caused by 64Bit-32Bit ODBC difference… E.g. UiPath requires 64Bit, you use 32Bit on your machine, and this creates mismatch.

Also check your projects Target Framework in project.json file; If it is Legacy, 32Bit ODBC Driver expected. If it is Windows, 64Bit ODBC Driver expected.

The Windows-Legacy project (application) uses a 32-bit Driver DSN connection.

The Windows or Cross-Platform project (application) uses a 64-bit Driver DSN connection.

So, if it worked in a Windows-Legacy project, you need to recreate the DSN connection using a 64-bit Database Driver and use it in the Connection Wizard in the Connect to database activity.

image