I need to connect this server database to Servoy:
Sybase SQL Anywhere Database Engine Version 5.5.04 Build #1867
Copyright by Sybase, Inc., and its subsidiaries, 1988, 1997.
All rights reserved. Sybase is a trademark of Sybase, Inc.
2048K of memory used for caching
Now accepting requests
Start time: Mon Sep 07 2009 16:28
Transaction log: HOTELSINGLEV200602.LOG
Starting checkpoint: Mon Sep 07 2009 16:28
Finished checkpoint: Mon Sep 07 2009 16:28
Database: C:\PROGRA~1\eversafe\HOTELM~1.01\HotelSingleV200602.Db started
Its default collation is Code page 850 latin 1.
I’ve tried with default parameter, with this URL string:
jdbc:sybase:Tds:localhost:2638?ServiceName=HotelSingleV200602&CHARSET=utf8
Servoy (the JDBC default drive) gives this error:
org.apache.commons.dbcp.DbcpException: java.sql.SQLException: JZ00L:
Login failed. Examine the SQLWarnings chained to this exception for
the reason(s).
I’ve tried in several ways to set the Charset to latin 1, if it helps, but with no results, the error changes like that:
org.apache.commons.dbcp.DbcpException: java.sql.SQLException: JZ0I5:
An unrecognized CHARSET property was specified: Latin1.
What should I do to set the right collation and to connect to the database?