One Star

Metadata - Db Connections - Sybase ASE & Generic ODBC connection issue

I'm trying to connect to our development Sybase database and I'm having trouble doing so.
I tried doing a Sybase ASE DB connection (pic 1), and got this error

Connection failure. You must change the Database Settings.
com.sybase.jdbc3.jdbc.SybSQLException: '""' is not a valid type name.


Then I tried setting up an ODBC connection through Windows, and that worked (pic 2-4).
But when I tried to connect to that ODBC connection using a Generic ODBC connection (pic 5), I got this error:

Connection failure. You must change the Database Settings.
java.sql.SQLException: Invalid descriptor index.


8 REPLIES
One Star Krp
One Star

Re:Metadata - Db Connections - Sybase ASE & Generic ODBC connection issue

For ODBC I reported a similar bug : http://www.talendforge.org/bugs/view.php?id=4614
Best regards

One Star

Re:Metadata - Db Connections - Sybase ASE & Generic ODBC connection issue

The bug is resolved in the new TOS 3.0M1 version.

One Star

Re:Metadata - Db Connections - Sybase ASE & Generic ODBC connection issue

When will 5.0 be out?
And I'm working in TIS and need to actually be able to connect to a Sybase database now... so what other options/solutions are there so I can do that????

One Star

Re:Metadata - Db Connections - Sybase ASE & Generic ODBC connection issue

unable to connect to sybase server as Sybase ASE while i can connect to the same server by ODBC.
i think Character set is the cause of this problem , how can i define connection Character set
error Message
Connection failure. You must change the Database Settings.
JZ00L: Login failed. Examine the SQLWarnings chained to this exception for the reason(s).

One Star

Re:Metadata - Db Connections - Sybase ASE & Generic ODBC connection issue

This problem with sybase happens when you check the connection or when you try to retrieve the metadata.
In these cases you get the following message :
"Connection failure. You must change the Database Settings.
com.sybase.jdbc3.jdbc.SybSQLException: '""' is not a valid type name."
But this problem doesn't happen when you run a job, so in spite of the bug you can retrieve your data from a Sybase table.

One Star

Re:Metadata - Db Connections - Sybase ASE & Generic ODBC connection issue

Hi
Is there a correction of this bug (Sybase DB Connection). It don't work on TOS 2.4.
Thank you

One Star

Re:Metadata - Db Connections - Sybase ASE & Generic ODBC connection issue

The bug is resolved in the new TOS 3.0M1 version.
One Star

Re: Metadata - Db Connections - Sybase ASE & Generic ODBC connection issue

That's a good news.
Thanks