on 11-25-2014 9:27 AM
Hi All,
May i know can i connect to SYBASE SQL Anywhere16 from SAP running on kernel 7.42 via dbacockpit (dbco)?
I've followed note 1737415 - Sybase IQ: Enable remote/secondary connect to SAP Sybase IQ & 1532253 - SYB: Remote DB Monitoring for SAP Sybase ASE
but failed.
Where can i find the dbsl and its client for sybase sql anywhere? I only can find SAP ASE and SAP IQ on SMP. Is those compatible with SQL anywhere 16?
Thanks.
Nicholas
I am not aware of any work having been done to enable access to SQL Anywhere databases from dbacockpit.
However, SAP IQ and SQLA share client access drivers, so it could be that the instructions (and dbsl) for IQ will work for SQL Anywhere, but I have not tried it.
What exactly is the error message that you get?
--Jason
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Jason,
the error message is it complains minimun version for SAP IQ is 15.6, however our SQL anywhere is on version 16, above the support version as per note1737415 - Sybase IQ: Enable remote/secondary connect to SAP Sybase IQ
fyi, i'm using the latest sybase dbsl and SAPIQ 16 client.
Any idea or will it works to remotely connect SQL anywhere via dbacockpit?
Thanks,
Nicholas.
It sounds like the dbacockpit is checking for a specific IQ version string from the server, in which case you will not be able to get it working with SQL Anywhere.
I think you are out of luck for now. However, I will speak with the dbacockpit about supporting SQL Anywhere in a future update.
--Jason
SQL Anywhere supports connections from ODBC and JDBC. You can use the IQ drivers, or you can download the (free) SQL Anywhere developer edition, which contains the drivers and tools for connecting to the database and issuing adhoc SQL statements. The developer edition can be found here:
https://global.sap.com/campaign/ne/sybase/sql_anywhere_16_download_program/index.epx?kNtBzmUK9zU
User | Count |
---|---|
87 | |
10 | |
10 | |
9 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.