JDBC Connection for Sybase SQL Anywhere 11

[Former Member]

Hi Experts,

In our scenario, client is using Sybase SQL Anywhere 11 as the receiver system, i wonder how to configured the JDBC channel for connection to Sybase SQL Anywhere 11.

1. where to download the driver file and how to deploy it to PI server, is there any refference?

2. what class name should we give in the JDBC Driver field of our JDBC receiver channel?

3. what is the format of the connection URL we need to specify in the our receiver channel?

Any input will be appreciated.

Best Regards,

Wayne Jiang

[Former Member]

Hi Aditya,

The latest driver available on Sybase website is jconn4.jar

You have to download this file from the website and ask basis team to deploy it. Other details of the JDBC channel should be provided by the market. 😛

Regards.....

[former_member207622]

Please check this thread check thed river name and connection url

you have to put that in the receiver adapter

http://iablog.sybase.com/hinsperg/2009/10/connecting-to-sql-anywhere-using-jdbc/

Please take help of basis and download this driver from sybase itself

check this link for jar file

http://www.fanaticzine.com/index.php/tag/sybase-sql-anywhere/

thanks

Ninad

Edited by: Ninad Sane on Aug 22, 2011 11:44 AM

[Former Member]

Hi Ninad,

thanks for your reply

Regards,

Edited by: Aditya Mutyala on Aug 22, 2011 11:53 AM

Edited by: Aditya Mutyala on Aug 22, 2011 11:57 AM

[former_member207622]

version -11.0.1 JDBC jar file to include in classpath-- %SQLANY11%\java\sajdbc.jar Driverclass name- sybase.jdbc.sqlanywhere.IDriver connection url--- jdbc:sqlanywhere:uid=DBA;pwd =sql;eng=demo

link is same im not sure why not opening i have copied the content from link above

http://iablog.sybase.com/hinsperg/2009/10/connecting-to-sql-anywhere-using-jdbc/

thanks

Ninad

[Former Member]

Hi Ninad,

Actually i don't really get it, as our client informed they are using Sybase SQL Anywhere 11.

based on the link you gave, we should use jdbc:ianywhere:Driver=SQL Anywhere 10;DSN= SQL Anywhere 11 Sample as the Connection URL.

Let's say the target end DB has "11.222.333.44" as the server ip, "1353" as the port, "DBName" as for the database name, now how shall we organize our connection url in our receiver JDBC channel?

Kindly let me know.

Best Regards,

[former_member207622]

Please try this from the second link I provided to you

jdbc:sybase:Tds:<HOST ADDRESS>:<PORT NUMBER>/<DB NAME>

enter host address as your IP address , enter port and enter database name

I have never connected this so I am not sure about this

Please try and let me kno the results

thanks

Ninad