Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

TOS & Sybase SQL Anywhere 10

Hello everybody,
I´m new to Talend (TOS). An interesting product.
I´m trying to create a repository Item, Db Connection, using a a sample databsae (demo10) on a running Sybase SQL Anywhere 10 (Personal Server).
As "BD Type" I select the only available Sybase product ?Sybase ASE? from the list and as Database the ?demo10? . Herewith the "Connection String" is:
jdbc:sybase:Tds:localhost:5001/demo10
Connection can´t be setup (cuz IOException: ConnectionException: Connection refused)
I´m sure the connection URL is wrong, but I´m also new to Sybase DBMS and can´t find help on it´s extensive online docs.
Please help. Thanks in Advance.
Aski

PS:
The Database Server must be up, to become able (within TOS) to create a Connection to a database managed by this Database Server? Or TOS initiates it, if the server is down?
Where can I read about low-level functionality of TOS?
I just noticed: Thread at 1898 indicates that Sybase SQL Anywhere 10 is not supported!!! (I´m using TOS 2.3.2)
Does it help if I update to the newest version of TOS?
Labels (4)
13 Replies
Anonymous
Not applicable
Author

Hi
Good news!
Can you please sharing your settings of connecting to sybase SQL anywhere from Talend to communty! It will be very helpful for other users.
Thank you!
Anonymous
Not applicable
Author

Hi
Good news!
Can you please sharing your settings of connecting to sybase SQL anywhere from Talend to communty! It will be very helpful for other users.
Thank you!

hi
ok i will share can you tell me what is this error.
Connection failure. You must change the Database Settings.
java.lang.UnsatisfiedLinkError: Native Library C:\Program Files\SQL Anywhere 12\Bin32\dbjdbc12.dll already loaded in another classloader

this error now i am getting, i should stop something or what it is.
thanks.
Anonymous
Not applicable
Author

hi

Connection failure. You must change the Database Settings.
java.lang.UnsatisfiedLinkError: Native Library C:\Program Files\SQL Anywhere 12\Bin32\dbjdbc12.dll already loaded in another classloader

this error now i am getting, i should stop something or what it is.
thanks.
Anonymous
Not applicable
Author

hi
i am able to connect to the sql anywhere from talend using sajdbc4.jar
but when i used jconn3.jar in my connection string its giving me this error
error: Connection failure. You must change the Database Settings.
java.sql.SQLException: JZ006: Caught IOException: java.net.ConnectException: Connection refused: connect

please please help me for this it's very urgent for me.
i am waiting for your reply.
thanks in advanced.