topic Getting DSN error for ODBC connection in Digital Exchange

Getting DSN error for ODBC connection

karishma.dalal — Thu, 23 Mar 2023 14:25:08 GMT

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?

Re: Getting DSN error for ODBC connection

ewilson — Thu, 23 Mar 2023 18:23:52 GMT

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

Re: Getting DSN error for ODBC connection

karishma.dalal — Fri, 24 Mar 2023 06:36:03 GMT

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

Re: Getting DSN error for ODBC connection

ewilson — Fri, 24 Mar 2023 14:05:52 GMT

@KarishmaDalal

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

Cheers,

Eric

Re: Getting DSN error for ODBC connection

karishma.dalal — Wed, 29 Mar 2023 08:54:47 GMT

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