problems creating database (sybase 10) on mac

Classic Servoy
1

Hi, newbie struggling to create a new database on the mac, using SQL anywhere 10. I simply can not create a database. In the forum i learned that there where more people with this problem, and then they hinted to do the manual dbinit command. I can then create the database, but when i then want to setup the connection in the preferences i get:

org.apache.commons.dbcp.DbcpException: java.sql.SQLException: JZ00L: Login failed. Examine the SQLWarnings chained to this exception for the reason(s).
java.sql.SQLException: JZ00L: Login failed. Examine the SQLWarnings chained to this exception for the reason(s).

I also created database on windows. Creation goes ok, and I can conect ok. So why can I not create a database via SQL Anywhere?, and why can I not connect to an local version.

Thanks for your support

Ron

2

The error sounds like you are using the wrong username or password. I think this has been changed to case sensitive in version 10, so make sure everything is correct.

3

Patrick,

thanks, do not think this is the case, as i was able to open things on the windows end. However when I try to open database via SQL anywhere I get:

[Sybase][ODBC Driver][SQL Anywhere]Request to start/stop database denied
Error code=-75
SQL state=42000

Connection parameters:
User=dba
Password=***
ENG=servoy_repository
LINKS=all
DBF=/Applications/Servoy/database/rp_solutions.db

Does this help?

rgds,

Ron

4

Maybe this forum post helps:

http://forum.servoy.com/viewtopic.php?p=11956#11956