# ODBC with Zookeeper Quorum **URL:** \ **Category:** Uncategorized\ **Created:** [February 24, 2020, 3:05pm UTC](https://community.dremio.com/t/odbc-with-zookeeper-quorum/5100 "2020-02-24T15:05:04Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![jamescheng](https://avatars.discourse-cdn.com/v4/letter/j/b77776/32.png) [@jamescheng](https://community.dremio.com/u/jamescheng)\ **Post date:** [February 24, 2020, 3:05pm UTC](https://community.dremio.com/t/odbc-with-zookeeper-quorum/5100/1 "2020-02-24T15:05:04Z")
Hi, I configured 2-node Dremio coordinator with external ZooKeeper, and I can use JDBC with ZooKeeper Quorum to connect Dremio, but I got connection fail with ODBC ZooKeeper Quorum. Here are my settings dremio.conf ( I have multiple Dremio clusters in same ZooKeeper so I configured the path) zookeeper: “[host1.aa.com:2181/ho/ha/dremio,host2.aa.com:2181/ho/ha/dremio,host3.aa.com:2181/ho/ha/dremio,host4.aa.com:2181/ho/ha/dremio,host5.aa.com:2181/ho/ha/dremio](http://host1.aa.com:2181/ho/ha/dremio,host2.aa.com:2181/ho/ha/dremio,host3.aa.com:2181/ho/ha/dremio,host4.aa.com:2181/ho/ha/dremio,host5.aa.com:2181/ho/ha/dremio)” JDBC connection (connect success !!! ) jdbc:dremio:zk=[host1.aa.com:2181/ho/ha/dremio,host2.aa.com:2181/ho/ha/dremio,host3.aa.com:2181/ho/ha/dremio,host4.aa.com:2181/ho/ha/dremio,host5.aa.com:2181/ho/ha/dremio](http://host1.aa.com:2181/ho/ha/dremio,host2.aa.com:2181/ho/ha/dremio,host3.aa.com:2181/ho/ha/dremio,host4.aa.com:2181/ho/ha/dremio,host5.aa.com:2181/ho/ha/dremio) ODBC connection (throw error) Quorm: [host1.aa.com:2181](http://host1.aa.com:2181),[host2.aa.com:2181](http://host2.aa.com:2181),[host3.aa.com:2181](http://host3.aa.com:2181),[host4.aa.com:2181](http://host4.aa.com:2181),[host5.aa.com:2181](http://host5.aa.com:2181) Cluster ID:/ho/ha/dremio/coordinator I wonder if i use correct cluster id for ODBC. I already tested below value, but still got error /ho/ha/dremio/ /ho/ha/ /ho/ The ODBC driver is the latest windows 64-bit driver Thanks, James ---
**Author:** ![ben](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/ben/32/1367_2.png) [@ben](https://community.dremio.com/u/ben)\ **Post date:** [February 24, 2020, 4:17pm UTC](https://community.dremio.com/t/odbc-with-zookeeper-quorum/5100/2 "2020-02-24T16:17:54Z")
@jamescheng, What error does the ODBC connection throw with the quorum? Can you supply the error stack? ---
**Author:** ![jamescheng](https://avatars.discourse-cdn.com/v4/letter/j/b77776/32.png) [@jamescheng](https://community.dremio.com/u/jamescheng)\ **Post date:** [February 24, 2020, 9:37pm UTC](https://community.dremio.com/t/odbc-with-zookeeper-quorum/5100/3 "2020-02-24T21:37:02Z")
## Hi @ben The error message is FAILED! ## [Dremio][Connector] (10) Failure occurred while trying to connect to [zk:2181=host1.aa.com](http://zk:2181=host1.aa.com),[host2.aa.com:2181](http://host2.aa.com:2181),[host3.aa.com:2181](http://host3.aa.com:2181),[host4.aa.com:2181](http://host4.aa.com:2181),[host5.aa.com:2181/ho/ha/dremio/coordinator](http://host5.aa.com:2181/ho/ha/dremio/coordinator) Thanks, James ---
**Author:** ![ben](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/ben/32/1367_2.png) [@ben](https://community.dremio.com/u/ben)\ **Post date:** [February 25, 2020, 5:08pm UTC](https://community.dremio.com/t/odbc-with-zookeeper-quorum/5100/4 "2020-02-25T17:08:12Z")
@jamescheng, Based on the error, it seems that the ODBC driver is maybe parsing the connection string incorrectly. Assuming that you have a ZKnode for one of the cluster coordinators at `/ho/ha/dremio/coordinator` can you try pointing to just one member of the quorum? If you are using the windows ODBC configurator that would look like: ```auto Quorum: host1.aa.com:2181 Cluster ID: /ho/ha/dremio/coordinator ``` ---
**Author:** ![jamescheng](https://avatars.discourse-cdn.com/v4/letter/j/b77776/32.png) [@jamescheng](https://community.dremio.com/u/jamescheng)\ **Post date:** [February 26, 2020, 2:18am UTC](https://community.dremio.com/t/odbc-with-zookeeper-quorum/5100/5 "2020-02-26T02:18:17Z")
@ben, I tried to use just one member of quorum, but it still threw error. FAILED! [Dremio][Connector] (10) Failure occurred while trying to connect to [zk:2181=host1.aa.com/ho/ha/dremio/coordinator](http://zk:2181=host1.aa.com/ho/ha/dremio/coordinator) The only one can be success is that if I use /dremio/coordinator as cluster id. However, the /dremio/coordinator is my another Dremio cluster. ( I have multiple Dremio cluster that using same zookeeper) Thanks, James ---
**Author:** ![ben](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/ben/32/1367_2.png) [@ben](https://community.dremio.com/u/ben)\ **Post date:** [February 28, 2020, 4:14am UTC](https://community.dremio.com/t/odbc-with-zookeeper-quorum/5100/6 "2020-02-28T04:14:26Z")
@jamescheng, do you have access to ZK shell? Can you confirm the path in Zookeeper to the other Dremio coordinator in the other cluster? ---
**Author:** ![jamescheng](https://avatars.discourse-cdn.com/v4/letter/j/b77776/32.png) [@jamescheng](https://community.dremio.com/u/jamescheng)\ **Post date:** [March 4, 2020, 1:06am UTC](https://community.dremio.com/t/odbc-with-zookeeper-quorum/5100/7 "2020-03-04T01:06:55Z")
@ben Here is the path of my one Dremio Cluster (only 1 coordinator). This is working for JDBC and ODBC that using ZooKeeper Quorum [zk: [host1.aa.com:2181](http://host1.aa.com:2181)(CONNECTED) 9] ls /dremio [semaphore, leader-latch, coordinator, executor, master] [zk: [host1.aa.com:2181](http://host1.aa.com:2181)(CONNECTED) 10] ls /dremio/coordinator [cc86c318-c6dd-4547-8b79-d4473154dc76] Here is the path of Dremio Cluster (2 coordinators). This is working for JDBC(with ZK Quorum), but not working with ODBC (with ZK Quorum) [zk: [host1.aa.com:2181](http://host1.aa.com:2181)(CONNECTED) 6] ls /ho [ha] [zk: [host1.aa.com:2181](http://host1.aa.com:2181)(CONNECTED) 7] ls /ho/ha [dremio,[host2.aa.com:2181](http://host2.aa.com:2181)] [zk: [host1.aa.com:2181](http://host1.aa.com:2181)(CONNECTED) 8] ls /ho/ha/dremio,[host2.aa.com:2181](http://host2.aa.com:2181) [ho] After the comparison, I can see this is different. I wonder if it is regarding the ZooKeeper setting in dremio.conf. I put the path at each node in dremio.conf, should I put the path only at the last ZK node ? my current setting “[host1.aa.com:2181/ho/ha/dremio,host2.aa.com:2181/ho/ha/dremio,host3.aa.com:2181/ho/ha/dremio,host4.aa.com:2181/ho/ha/dremio,host5.aa.com:2181/ho/ha/dremio”](http://host1.aa.com:2181/ho/ha/dremio,host2.aa.com:2181/ho/ha/dremio,host3.aa.com:2181/ho/ha/dremio,host4.aa.com:2181/ho/ha/dremio,host5.aa.com:2181/ho/ha/dremio%E2%80%9D) should i configure it ? I remember it can’t work “[host1.aa.com:2181](http://host1.aa.com:2181),[host2.aa.com:2181](http://host2.aa.com:2181),[host3.aa.com:2181](http://host3.aa.com:2181),[host4.aa.com:2181](http://host4.aa.com:2181),[host5.aa.com:2181/ho/ha/dremio”](http://host5.aa.com:2181/ho/ha/dremio%E2%80%9D)