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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2008-07-24 03:32 PM

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.


0683p000009MChZ.jpg0683p000009MCji.jpg0683p000009MCeP.jpg0683p000009MCjn.jpg0683p000009MCjs.jpg

Labels (4)
Labels
544 Views
0 Likes
8 Replies
Anonymous
Not applicable
‎2008-07-25 03:52 AM
Author

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

544 Views
0 Likes
Anonymous
Not applicable
‎2008-07-30 06:57 AM
Author

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

544 Views
0 Likes
Anonymous
Not applicable
‎2008-07-30 12:57 PM
Author

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

544 Views
0 Likes
Anonymous
Not applicable
‎2008-08-04 08:00 AM
Author

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

544 Views
0 Likes
Anonymous
Not applicable
‎2008-08-04 11:14 AM
Author

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.

544 Views
0 Likes
Anonymous
Not applicable
‎2008-10-06 09:00 AM
Author

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

544 Views
0 Likes
Anonymous
Not applicable
‎2008-10-06 10:50 AM
Author

The bug is resolved in the new TOS 3.0M1 version.
544 Views
0 Likes
Anonymous
Not applicable
‎2008-10-06 11:54 AM
Author

That's a good news.
Thanks

544 Views
0 Likes