# DBVisualizer connection Issue

**URL:** <https://community.dremio.com/t/dbvisualizer-connection-issue/10157>\
**Category:** Uncategorized\
**Created:** [January 10, 2023, 8:50am UTC](https://community.dremio.com/t/dbvisualizer-connection-issue/10157 "2023-01-10T08:50:06Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![dolphinlei](https://avatars.discourse-cdn.com/v4/letter/d/e47c2d/32.png) [@dolphinlei](https://community.dremio.com/u/dolphinlei)\
**Post date:** [January 10, 2023, 8:50am UTC](https://community.dremio.com/t/dbvisualizer-connection-issue/10157/1 "2023-01-10T08:50:06Z")

</div>

Hi Team, we countered some connection issue when using Dremio jdbc Driver.

In dremio.conf file, the exact zookeeper line is as below:  
zookeeper: “[hostd00025.company.com:1234](http://hostd00025.company.com:1234),[hoste00026.company.com:1234](http://hoste00026.company.com:1234),[hostf00027.company.com:1234/DremioEE](http://hostf00027.company.com:1234/DremioEE)”

And it does not work for the Database URL that exactly same as the zookeeper configure in Dremio.conf file like below  
jdbc:dremio:zk=[hostd00025.company.com:1234](http://hostd00025.company.com:1234),[hoste00026.company.com:1234](http://hoste00026.company.com:1234),[hostf00027.company.com:1234/DremioEE](http://hostf00027.company.com:1234/DremioEE)

But the connection works if we config like below:  
jdbc:dremio:zk=[hostd00025.company.com:1234](http://hostd00025.company.com:1234),[hoste00026.company.com:1234](http://hoste00026.company.com:1234),[hostf00027.company.com:1234/dremio](http://hostf00027.company.com:1234/dremio)

Can you please let me know why? And Why we cannot use the exact zookeeper line config in DBVisualizer connection？

---

<div class="post-metadata">

**Author:** ![dolphinlei](https://avatars.discourse-cdn.com/v4/letter/d/e47c2d/32.png) [@dolphinlei](https://community.dremio.com/u/dolphinlei)\
**Post date:** [January 10, 2023, 8:51am UTC](https://community.dremio.com/t/dbvisualizer-connection-issue/10157/2 "2023-01-10T08:51:44Z")

</div>

Seems the JDBC connection is like below:  
jdbc:dremio:direct=[dremioxxxx.company.com:12345](http://dremioxxxx.company.com:12345)  
What is the difference and which one is better. Thanks.

---

<div class="post-metadata">

**Author:** ![balaji.ramaswamy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/balaji.ramaswamy/32/843_2.png) [@balaji.ramaswamy](https://community.dremio.com/u/balaji.ramaswamy)\
**Post date:** [January 15, 2023, 12:57am UTC](https://community.dremio.com/t/dbvisualizer-connection-issue/10157/3 "2023-01-15T00:57:55Z")

</div>

@dolphinlei Couple of things,

Do you have multiple coordinators connecting to the same ZK Quorum? If not then you can simply use the below in both dremio.conf and DBVisualizer

```auto
services.coordinator.master.embedded-zookeeper.enabled: false
zookeeper: "<host1>:2181,<host2>:2181"

```

Also, the last word on the path needs to be `/dremio`, your dremio.conf is probably just connecting to your root and DBeaver is not handling it

```auto
zookeeper: "<host1>:2181,<host2>:2181,<host3>:2181/path/to/dremio"

```

Try one of the below

```auto
zookeeper: "<host1>:2181,<host2>:2181,<host3>:2181/path/to/dremio"

```

(OR)

```auto
services.coordinator.master.embedded-zookeeper.enabled: false
zookeeper: "<host1>:2181,<host2>:2181"

```