Niels Voorhoeve - 2005-10-07

Hi,

My login to sybase 12.5.0.3 failed with the following sql2java.properties below.  Are there known problems with this version of sybase?  I know that my login info is correct, so it's nothing that obvious.  I tried tweaking the schema part of the url (see comments in config below).

Any idea?

#----------------------------------------------
# (1/6) CONFIGURE YOUR DATABASE ACCESS
#----------------------------------------------
jdbc.driver=com.sybase.jdbc2.jdbc.SybDriver
jdbc.url=jdbc:sybase:Tds:DAPDB:50019
# tried above line with and without /EOR removed
jdbc.username=mylogin
jdbc.password=mypassword
# tried without schema set
jdbc.schema=EOR

$ ant generate
Buildfile: build.xml

prepare:

generate:
     [java] java.sql.SQLException: JZ00L: Login failed.  Examine the SQLWarnings chained to this exception for the reason(s).
     [java]     at com.sybase.jdbc2.jdbc.ErrorMessage.raiseError(ErrorMessage.java:439)
     [java]     at com.sybase.jdbc2.tds.Tds.processLoginAckToken(Tds.java:2877)
     [java]     at com.sybase.jdbc2.tds.Tds.doLogin(Tds.java:422)
     [java]     at com.sybase.jdbc2.tds.Tds.login(Tds.java:349)
     [java]     at com.sybase.jdbc2.jdbc.SybConnection.tryLogin(SybConnection.java:213)
     [java]     at com.sybase.jdbc2.jdbc.SybConnection.regularConnect(SybConnection.java:190)
     [java]     at com.sybase.jdbc2.jdbc.SybConnection.<init>(SybConnection.java:169)
     [java]     at com.sybase.jdbc2.jdbc.SybConnection.<init>(SybConnection.java:122)
     [java]     at com.sybase.jdbc2.jdbc.SybDriver.connect(SybDriver.java:175)
     [java]     at java.sql.DriverManager.getConnection(DriverManager.java:512)
     [java]     at java.sql.DriverManager.getConnection(DriverManager.java:171)
     [java]     at com.netkernel.sql2java.Database.load(Database.java:83)
     [java]     at com.netkernel.sql2java.Main.main(Main.java:45)
     [java] Java Result: 1

BUILD SUCCESSFUL
Total time: 1 second