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?