# Getting connection error using 'Arrow Flight SQL ODBC Driver' in LINUX machine
**URL:** https://community.dremio.com/t/getting-connection-error-using-arrow-flight-sql-odbc-driver-in-linux-machine/10312
**Category:** Uncategorized
**Created:** [February 20, 2023, 1:54pm UTC](https://community.dremio.com/t/getting-connection-error-using-arrow-flight-sql-odbc-driver-in-linux-machine/10312 "2023-02-20T13:54:17Z")
**Posts on this page:** 9
**Page:** 1
### Author:  [@samarapalli](https://community.dremio.com/u/samarapalli)
#### Post date: [February 20, 2023, 1:54pm UTC](https://community.dremio.com/t/getting-connection-error-using-arrow-flight-sql-odbc-driver-in-linux-machine/10312/1 "2023-02-20T13:54:17Z")
Hi All,
I’m trying to integrate the DB connection of Dremio into Informatica Powercenter. I found an infromatica KB article mentioned ‘ **Dremio is not certified/supported on PowerCenter. ODBC support statement is provided as the user must engage Dremio vendor support directly to obtain third party ODBC drivers and setup through vendor**.’
So i tried looking for how to ODBC can engage with Dremio. And i found a setup the ‘Arrow Flight SQL ODBC Driver’ in LINUX machine from the below link :
[https://docs.dremio.com/software/drivers/arrow-flight-sql-odbc-driver/#downloading-and-installing-on-linux](https://docs.dremio.com/software/drivers/arrow-flight-sql-odbc-driver/#downloading-and-installing-on-linux)
[https://docs.dremio.com/software/drivers/arrow-flight-sql-odbc-driver/#configuring-on-linux](https://docs.dremio.com/software/drivers/arrow-flight-sql-odbc-driver/#configuring-on-linux)
When testing **libarrow-odbc.so.0.9.1.168** by running below command **ddtestlib …/lib/libarrow-odbc.so** in linux terminal, it throws an error :
**Load of …/lib/libarrow-odbc.so.0.9.1.168 failed: …/lib/libarrow-odbc.so.0.9.1.168: undefined symbol: krb5\_auth\_con init**
Please let me know how we can resolve this issue, if anyone challenged this earlier.
---
### Author:  [@balaji.ramaswamy](https://community.dremio.com/u/balaji.ramaswamy)
#### Post date: [February 28, 2023, 12:19am UTC](https://community.dremio.com/t/getting-connection-error-using-arrow-flight-sql-odbc-driver-in-linux-machine/10312/2 "2023-02-28T00:19:21Z")
@samarapalli you are trying to connect to Dremio from Powercenter using flight?
---
### Author:  [@samarapalli](https://community.dremio.com/u/samarapalli)
#### Post date: [March 2, 2023, 5:26am UTC](https://community.dremio.com/t/getting-connection-error-using-arrow-flight-sql-odbc-driver-in-linux-machine/10312/3 "2023-03-02T05:26:15Z")
Yes @balaji.ramaswamy , the above issue is faced while using the library file ‘libarrow-odbc.so. **0.9.1**.168’ , I think this library file having some issue connecting to the Dremio Build
23.1.0-202211250136090978-a79618c7 .
But, If I using the earlier version of the library file arrow-flight-sql-odbc-driver- **0.9.0**.116-1.x86\_64 then it got resolved and connection got succeeded.
I’m facing one more issue, while I’m trying to connect through the ODBC Data Source 64 Bit. I provided the required as shown below, then its throwing an error ‘ **Flight returned unavailable error…** ’
Can you please help on this how to resolve the issue.
---
### Author:  [@balaji.ramaswamy](https://community.dremio.com/u/balaji.ramaswamy)
#### Post date: [March 6, 2023, 5:05am UTC](https://community.dremio.com/t/getting-connection-error-using-arrow-flight-sql-odbc-driver-in-linux-machine/10312/4 "2023-03-06T05:05:42Z")
@samarapalli I have requested someone to look into this and they will get back to you this week
---
### Author:  [@Rajan\_Santhanam](https://community.dremio.com/u/Rajan_Santhanam)
#### Post date: [March 6, 2023, 5:28pm UTC](https://community.dremio.com/t/getting-connection-error-using-arrow-flight-sql-odbc-driver-in-linux-machine/10312/5 "2023-03-06T17:28:41Z")
@samarapalli
Do you have SSL enabled ? If not please ensure the useEncryption option is unchecked in Advanced Tab.
Also could you please provide a screenshot of the Advanced tab ?
We do have a known issue with Dremio 23.1 as per [Dremio](https://docs.dremio.com/software/release-notes/240-release/) ( \* In some cases, with the Arrow Flight SQL ODBC driver, users were getting an error when testing the connection to Microsoft Excel in the ODBC Administrator on Windows.)
---
### Author:  [@Rajan\_Santhanam](https://community.dremio.com/u/Rajan_Santhanam)
#### Post date: [March 6, 2023, 6:51pm UTC](https://community.dremio.com/t/getting-connection-error-using-arrow-flight-sql-odbc-driver-in-linux-machine/10312/6 "2023-03-06T18:51:22Z")
The fix is available in Dremio versions below
- 23.1.2
- 24.0.0
---
### Author:  [@samarapalli](https://community.dremio.com/u/samarapalli)
#### Post date: [March 7, 2023, 4:16am UTC](https://community.dremio.com/t/getting-connection-error-using-arrow-flight-sql-odbc-driver-in-linux-machine/10312/7 "2023-03-07T04:16:53Z")
Hi @Rajan_Santhanam , thanks for the response.
Yes, I Unchecked the useEncryption option in Advanced tab and getting the error. Here is the attachement.
---
### Author:  [@samarapalli](https://community.dremio.com/u/samarapalli)
#### Post date: [March 7, 2023, 12:24pm UTC](https://community.dremio.com/t/getting-connection-error-using-arrow-flight-sql-odbc-driver-in-linux-machine/10312/8 "2023-03-07T12:24:29Z")
Hi @Rajan_Santhanam ,
Yes, it worked after installing the Dremio Version 24.0.0
---
### Author:  [@samarapalli](https://community.dremio.com/u/samarapalli)
#### Post date: [March 8, 2023, 5:48am UTC](https://community.dremio.com/t/getting-connection-error-using-arrow-flight-sql-odbc-driver-in-linux-machine/10312/9 "2023-03-08T05:48:46Z")
hi @Rajan_Santhanam , @balaji.ramaswamy
Informatica Designer supports only 32-bit ODBC Data Source to Import the tables from Database, but the ArrowFlightSQLODBC driver is supported only 64-bit.
Is there a possible way to configure the ArrowFlightSQLODBCDSN into Informatica Designer ODBC 32-bit (i.e; how to fetch the tables from Dremio space into Informatica Designer)?
Need your suggestion on this.
Thanks,
Satish