SQL Anywhere

The ODBC connection via SQL Anywhere does not work.
What is the possibility of supporting a native driver for this product?

3 comments
Comment actions Permalink

Hello.

At the moment SQL Anywhere is not supported (at least, we did not test it yet). You can try to download a JDBC driver for this database, if any, and define this custom driver in Data Sources dialog.

Regards,
Alexander.

0
Comment actions Permalink

Alex -- thanks for the quick response..


After reading your email I remembered that SQLAnywhere supplies JDBC drivers as part of the product.
They provide both a JDBC 3 and JDBC 4 driver, and there is an article here regarding how to set them up.

I followed the instructions and was able to make a successful connection. However I did receive "driver not capable"
errors from the getTables functionality. I experienced this with both of the vendor supplied drivers.

Having worked similar problems before, I am certain the problem is not in the JDBC drivers, but rather the particular sql
code you are executing through them.

If you will send me the sql used for your selections in the various sections of this product I will be glad to rework it
to the SQLAnywhere dialect. Since you probably don't have SQLAnywhere specific sql code, it is usually best to start with the sql for the latest
version of SQL Server.

I have attached images of the setup for the driver, the datasource and the error I received when trying to sync.



Attachment(s):
Error.pdf
DataSource.pdf
Driver.pdf
0
Comment actions Permalink

Currently we do not compose the SQL statements on our own, just call JDBC metadata API, implemented by the driver. So the question is just find the driver supporting all necessary methods, like getTables().

Regards,
Alexander.

0

Please sign in to leave a comment.