SAP IQ Version 16.1 - Sybase database

Dissuss issues not related to other forums

SAP IQ Version 16.1 - Sybase database

Postby Tech Support » Fri Apr 24, 2020 6:41 am

User support request:

Since migrating to Automize 12, Database SQL tasks were failing. Saw a note on the forum to reach out to you to get the required JDBC driver. The database we are using is SAP IQ Version 16.1. Can you please provide us with the connection parameters.

Thank you
Tech Support
Site Admin
 
Posts: 1276
Joined: Thu May 25, 2006 11:12 am

Re: SAP IQ Version 16.1 - Sybase database

Postby Tech Support » Fri Apr 24, 2020 6:42 am

1) You likely were using the SQL Anywhere JDBC-ODBC driver. This will no longer work.
2) You will need to use the jConnect driver. Download the jConnect driver at http://www.sybase.com/products/allprodu ... t/jconnect.
3) jConnect is supplied as a JAR file named jconn4.jar. This file is located in your jConnect install location.
4) Copy jconn4.jar to Automize12 folder and restart Automize UI and engine.
5) Try these settings in Database SQL tasks.
Driver class name: com.sybase.jdbc4.jdbc.SybDriver
Database URL: jdbc:sybase:Tds:server-name:server-port
server-port normally = 4100
Tech Support
Site Admin
 
Posts: 1276
Joined: Thu May 25, 2006 11:12 am

Re: SAP IQ Version 16.1 - Sybase database

Postby Tech Support » Fri Apr 24, 2020 6:43 am

User reply:
Thank you for the quick response. All good.
Tech Support
Site Admin
 
Posts: 1276
Joined: Thu May 25, 2006 11:12 am


Return to Other

Who is online

Users browsing this forum: No registered users and 1 guest

cron