Getting DSN error for ODBC connection

[karishma.dalal]

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? 

[ewilson]

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.

Cheers,

Eric

[karishma.dalal]

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]

@KarishmaDalal

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

Cheers,

Eric

[karishma.dalal]

@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.