cancel
Showing results for 
Search instead for 
Did you mean: 

Getting DSN error for ODBC connection

KarishmaDalal2
Level 3
We are trying to provide automation to business and they have Dremio application where Blue prism is required to connect via ODBC. Have been able to create a DSN which is a 64 bit dsn that Dremio provides. When tried to connect using the Connector for ODBC Utility Blue Prism - 1.0.0 and gave the error ERROR [IM014] [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application.
Is this related to 32 bit & 64 bit mismatch ? or please assist in getting the BP connected to 64bit DSN? 
4 REPLIES 4

ewilson
Staff
Staff

Hello @KarishmaDalal

You cannot use a 64-bit DSN with Blue Prism as the BP Automate.exe application is 32-bit. This is actually documented within the VBO as a precondition (see screenshot below). Does Dremio have a 32-bit driver they can provide? A 64-bit version of Blue Prism (v7.2) is on the roadmap, but I don't believe it will ship before end of April.

35414.png

Cheers,

Eric

KarishmaDalal2
Level 3

hi @ewilson 

Thank you for confirming that currently BP doesnt support 64 bit ODBC version. 

Dremio only provides 64 bit ODBC DSN so unfortunately its a blocker now for us to connect BP to Dremio via ODBC. 

Hopefully BP comes up with a version that supports 64 bit version soon. 

Many thanks 

@Karishma Dalal 

ewilson
Staff
Staff

@KarishmaDalal

Do you have to connect to Dremoi via ODBC? What about using OLEDB?

Cheers,

Eric

KarishmaDalal2
Level 3

@ewilson 

Yes, only ODBC driver available. Hopefully v7.2 has this compatibility for 64 bit. 
For now we are moving forward to use the API.
Thanks for all your help.