Sybase SQL Anywhere connection

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.

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

1 Like

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?

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.

1 Like