I am still trying to get a running (working) native JDBC database connection to a SQL Anywhere 17 database. I tried with the following URL and Driver settings on Windows Server (2008 R2) and OS X 10.11.5. On both platforms, a SQL Anywhere version 126.96.36.1999 is running. It's a standard install done by the installer (wizard). Unfortunately I have no success on making a connection on either OS.
In the database server connection fields URL and Driver, I use:
This settings are based on my older thread about JDBC database connections. Read thread here if appropriate: http://sqlanywhere-forum.sap.com/questions/16414/jdbc-driver-for-oracle-data-modeler
Using following settings works with jconn3.jar on both platforms:
What settings and driver files are other people using? Where are they located?
I still have hope to get the native connection run. The motivation for me is that as far as I understood it is a (much) faster connection.
asked 02 Nov '16, 11:17
Your use of DSN= is incorrect. That should probably be DBN= given you are specifying a database name.
If you have a working ODBC DataSource (DSN) you can use DSN= to pick that up (and all the settings saved in the ODBC.ini registry under that will get picked up as well; ie. with that you may not need anything else)
If Links= is giving you a problem you can switch to HOST= instead now.
answered 02 Nov '16, 12:03
Nick Elson S...
Make sure the JDBC driver is in your classpath (Windows example here).
If you are writing the JDBC app, your connection code should look something like this (add/replace whatever connection parameters you like).
answered 03 Nov '16, 10:39