| Sybase connection [message #10421] |
Sun, 09 April 2006 08:44  |
Eclipse User |
|
|
|
Originally posted by: ian.kingham.btinternet.com
Hi,
I am tying to create a db connection to an instance of Sybase on my local
machine
the Sybase ini file contains
[KINGHAMW9SR51G]
master=NLWNSCK,kingham-w9sr51g,5000
query=NLWNSCK,kingham-w9sr51g,5000
so I'm using in the JBDC Connection Properties dialog:
DATABASE: KINGHAMW9SR51G
URL: jdbc:sybase:Tds:kingham-w9sr51g:5000/KINGHAMW9SR51G
and a username & pwd that works connecting via SQLAdvantage tool
The Test Connection ping fails...
java.sql.SQLException: JZ00L: Login failed. Examine the SQLWarnings chained
to this exception for the reason(s).
at com.sybase.jdbc2.jdbc.ErrorMessage.raiseError(ErrorMessage.j ava:546)
at com.sybase.jdbc2.tds.Tds.processLoginAckToken(Tds.java:3629)
at com.sybase.jdbc2.tds.Tds.doLogin(Tds.java:510)
at com.sybase.jdbc2.tds.Tds.login(Tds.java:432)
at com.sybase.jdbc2.jdbc.SybConnection.tryLogin(SybConnection.j ava:247)
Tools version 0.7..0.20062241 & Ecliose 3.2.0 build I20060223-1656, Java
1.5.0_06
Googling it seems there could be an issue with the Language charset -my
Sybase is set to use cp850. Tried changing it to ISO8859 but the dbs service
wouldn't start.
Has anyone had / overcome tihs issue ?
Thks
|
|
|
| Re: Sybase connection [message #10454 is a reply to message #10421] |
Mon, 10 April 2006 17:25  |
| Eclipse User |
|
|
|
Originally posted by: brianf.sybase.com
Hi there. Though we don't currently support ASE, we are working on
specialized vendor support for this case -- look for an announcement in
the coming weeks.
--Brian Fitzpatrick
Sybase, Inc.
|
|
|
| Re: Sybase connection [message #572107 is a reply to message #10421] |
Mon, 10 April 2006 17:25 |
| Eclipse User |
|
|
|
Hi there. Though we don't currently support ASE, we are working on
specialized vendor support for this case -- look for an announcement in
the coming weeks.
--Brian Fitzpatrick
Sybase, Inc.
|
|
|
Powered by
FUDForum. Page generated in 0.03612 seconds
Home