I’ve just installed Servoy and SQL Anywhere on a PC and when in Servoy everytime I try to create a new sybase server I get the eror message :
jZ00L: Logib failed. Examine the SQL Warnings chained to this exception for the reasons (s).
There are no othter reasons ? I have used the default new server settings except added a password to the blank password field for the user name dba and changed the database name to match a databse I created elsewhere:
Does the database have to exist in SQL anywhere first ? The database file for canteen was created on another pc which I have copied to the new pC but I can’t seem to get Sybase to connect to this new database and I can’t import any solutions into Servoy which I created on the other PC as the import process says there is no database server created for the solution.
I can use and connect happily to the canteen databse and files from the other pc.
Do I in Sybase add the database called Canteen to the servoy_repository server ? If so I get the error request to start/stop database denied. I’ve tried all passwords I’ve used but still get the same message, but can’t see how I can create a new server called canteen from Sybase (is this what I’m supposed to do … then what is servoy creating when I try to create a new server from within servoy )
I think this has nothing to do with wrong username/password, but just this new database not yet running in the server.
What you have to check in your Servoy installation folder is: (first quit servoy/sql server)
open ‘\application_server\sybase_db\sybase.config’ with a text editor and check if your new database is already mentioned in there…
If not, just create a new line and enter it manually.
Then start servoy again, now you should be able to create the connection succesfully.
Have created the database in Sybase, but still get the error, even after updating the config file as suggested but no matter what I do I always get the same error message whenever I try and create ANY new sybase server in Servoy (there is no further explanation which gives more detail_ :
jZ00L: Logib failed. Examine the SQL Warnings chained to this exception for the reasons (s).
Think that was more some sort of copy/paste or typo error when I posted, I have used the
jdbc:sybase:Tds:localhost:2638?ServiceName=canteen&CHARSET=utf8 and no matter what database name I use whether it exists in Sybase or not I always get that error message.
I just did a create database in Servoy and that creates it with a red cross by the picture of the database and I can’t do anything.
Up shot is I’ve done an install, I have uninstalled both Servoy and Sybase but always get that Login error message.
Not sure what else I can do as I’ve uninstalled servoy, install it again then without doing anythin else right clicked to add new server and then it says login failure.
Try this:
Create a new sybase database via servoy and then stop both servoy developer and sybase.
Start servoy developer again (which will start sybase), does the login error still happen?