# Sybase SQL Anywhere connection

**URL:** <https://forum.inductiveautomation.com/t/sybase-sql-anywhere-connection/15957>\
**Category:** Ignition\
**Tags:** database\
**Created:** [November 10, 2017, 3:57am UTC](https://forum.inductiveautomation.com/t/sybase-sql-anywhere-connection/15957 "2017-11-10T03:57:22Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![nathanmcbride](https://avatars.discourse-cdn.com/v4/letter/n/b5a626/32.png) [@nathanmcbride](https://forum.inductiveautomation.com/u/nathanmcbride)\
**Post date:** [November 10, 2017, 3:57am UTC](https://forum.inductiveautomation.com/t/sybase-sql-anywhere-connection/15957/1 "2017-11-10T03:57:22Z")

</div>

Does anyone have experience connecting to SQL Anywhere database. I have proprietary HMI using Sybase database and need to connect to it.  
I have tried creating the driver with jconn4.jar and jtds-1.3.1.jar.  
I am not really sure how to build the connection string correctly, so I don’t know for sure if either of these drivers are working.

---

<div class="post-metadata">

**Author:** ![ktran](https://avatars.discourse-cdn.com/v4/letter/k/ecae2f/32.png) [@ktran](https://forum.inductiveautomation.com/u/ktran)\
**Post date:** [December 5, 2018, 7:04pm UTC](https://forum.inductiveautomation.com/t/sybase-sql-anywhere-connection/15957/2 "2018-12-05T19:04:04Z")

</div>

I realize this is an older post, but just in case other find it useful, use the following settings with the jconn4.jar (jConnect Driver) to connect to a SQL Anywhere database.

Classname: com.sybase.jdbc4.jdbc.SybDriver  
Connect URL: jdbc:sybase:Tds:host:port

---

<div class="post-metadata">

**Author:** ![Joe\_Bonhage1](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/joe_bonhage1/32/48220_2.png) [@Joe\_Bonhage1](https://forum.inductiveautomation.com/u/Joe_Bonhage1)\
**Post date:** [June 14, 2023, 12:17am UTC](https://forum.inductiveautomation.com/t/sybase-sql-anywhere-connection/15957/3 "2023-06-14T00:17:34Z")

</div>

Using the information above I've connected to a Sybase SQL Anywhere 11 database using jconn4.jar. In the database query brower the table schemas get pulled in (I'm connected!) but for I cannot get any kind of query to work. Starting simple with a SELECT but always get the follow error with syntax error near WHERE clause... but there isn't a WHERE statement, any ideas?

 ![sqlanywhere11_sybase](https://us1.discourse-cdn.com/inductiveautomation/original/3X/d/4/d45e319d890005786027b29458eb3b1bc384ff66.png)

---

<div class="post-metadata">

**Author:** ![Joe\_Bonhage1](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/joe_bonhage1/32/48220_2.png) [@Joe\_Bonhage1](https://forum.inductiveautomation.com/u/Joe_Bonhage1)\
**Post date:** [June 14, 2023, 4:06am UTC](https://forum.inductiveautomation.com/t/sybase-sql-anywhere-connection/15957/4 "2023-06-14T04:06:26Z")

</div>

Answer: I used jconn3.jar (classname: com.sybase.jdbc3.jdbc.SybDriver)  
Then ran the query from the 'Named Queries' section of Ignition with 'Sybase' build syntax.  
I can now query the data, good to go.

 ![answer](https://us1.discourse-cdn.com/inductiveautomation/original/3X/f/f/ffee0a4485da76b8c86613836bbd824b06c7c6b4.jpeg)