Pages: 1

Post reply

  • Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » [resolved] Metadata - Db Connections - Sybase ASE & Generic ODBC connection issue

#1 2008-07-24 20:32:24

strpdsnk
Member
Registered: 2008-03-25
Posts: 328

[resolved] Metadata - Db Connections - Sybase ASE & Generic ODBC connection issue

Tags: [database, error, sybase, tis2.4.1]

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: [DataDirect][ODBC Sybase Wire Protocol driver]Invalid descriptor index.


Uploaded Images

Last edited by strpdsnk (2008-07-24 20:35:50)

Offline

#2 2008-07-25 08:52:18

Krp
Member
Registered: 2008-07-08
Posts: 31

Re: [resolved] 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

Offline

#3 2008-07-30 11:57:50

bal75
New member
Registered: 2008-06-16
Posts: 7

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

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

Offline

#4 2008-07-30 17:57:27

strpdsnk
Member
Registered: 2008-03-25
Posts: 328

Re: [resolved] 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????

Last edited by strpdsnk (2008-07-31 18:45:31)

Offline

#5 2008-08-04 13:00:47

Omar
New member
Registered: 2008-08-04
Posts: 1

Re: [resolved] 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).

Offline

#6 2008-08-04 16:14:48

bal75
New member
Registered: 2008-06-16
Posts: 7

Re: [resolved] 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.

Offline

#7 2008-10-06 14:00:53

NicolasP
Member
Registered: 2006-09-20
Posts: 41

Re: [resolved] 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

Offline

#8 2008-10-06 15:50:20

strpdsnk
Member
Registered: 2008-03-25
Posts: 328

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

bal75 wrote:

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

Offline

#9 2008-10-06 16:54:28

NicolasP
Member
Registered: 2006-09-20
Posts: 41

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

That's a good news.
Thanks

Offline

Post reply

Pages: 1

  • Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » [resolved] Metadata - Db Connections - Sybase ASE & Generic ODBC connection issue

Board footer

Powered by FluxBB