topic Re: Metadata - Db Connections - Sybase ASE & Generic ODBC connection issue in Talend Studio

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

Anonymous — Sat, 16 Nov 2024 14:16:59 GMT

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.

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

Anonymous — Fri, 25 Jul 2008 07:52:18 GMT

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

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

Anonymous — Wed, 30 Jul 2008 10:57:50 GMT

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

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

Anonymous — Wed, 30 Jul 2008 16:57:27 GMT

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????

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

Anonymous — Mon, 04 Aug 2008 12:00:47 GMT

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).

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

Anonymous — Mon, 04 Aug 2008 15:14:48 GMT

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.

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

Anonymous — Mon, 06 Oct 2008 13:00:53 GMT

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

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

Anonymous — Mon, 06 Oct 2008 14:50:20 GMT

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

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

Anonymous — Mon, 06 Oct 2008 15:54:28 GMT

That's a good news.
Thanks