Following Dean’s excellent instructions, I have correctly setup Servoy Server and Sybase to run automatically as services upon machine startup. However, I am not able to connect to my repository using Sybase Central - I get the following error message:
[Sybase][ODBC Driver][Adaptive Server Anywhere]Specified database file already in use
Hi Ben
It may be that your developer is still connected to an instance of the database.You need to exit from this then try to connect.
Hope this helps.
Marcus
LOGIsoft:
Hello everyone,
Following Dean’s excellent instructions, I have correctly setup Servoy Server and Sybase to run automatically as services upon machine startup. However, I am not able to connect to my repository using Sybase Central - I get the following error message:
[Sybase][ODBC Driver][Adaptive Server Anywhere]Specified database file already in use
The database file is already open in the Sybase iAnywere database server.
So just connect Sybase Central to the database server instance, not to the database file.
Thanks Robert, can you provide any pointers on where or how to do this exactly? I don’t know where to put the correct info in Sybase Central, so I’m attaching screen captures for clarity…
In the first Tab you put the normal username and password info.
In the second Tab you only fill in the Server info and the database name, NOT the database path/filename.
Hit connect and there you go.
And yes, like Marcel said you can use the find button.
Thanks Marcel, but if I take out the DB name, I still get the same error message, but witout the last line that says ‘DBN=servoy_repository’…
Actually, I don’t know where ‘myeng’ comes from exactly (aside from the fact that the ‘Find’ button comes up with it, listed on the correct port) - I certainly did not name my server that way!
This is going on with a machine that required a couple of tries (installing/unistalling Servoy and Sybase) before I could get my services to start up right. Are you saying I have to start from scratch - again? I’m afraid to do this, and nothing tells me I won’t be stuck with the same problem afterwards…
Here’s where I’m at so far: I think the ‘myeng’ entry was coming from my ASASERVICE Configuration Parameters in Sybase (I had ’ -n myeng -c 8m ’ - coming from Dean’s batch file - before the ‘@C:\Progra~1\Servoy\sybase_db\sybase.config’ string). Once I removed the part before the ‘@’, and after restarting the service, the ‘Find’ button comes up with ‘servoy_repository’. I’m still not connecting using Sybase Central and these new parameters, but at least it’s encouraging!
The only difference I can see with another working configuration that I can compare it to is the fact that, instead of an IP address, the machine name is showing up.
I only wish it were that easy - it just doesn’t work with Servoy server on this machine!
When I stop both services (ASASERVICE and Servoy Server) and then start Developer, I can see the repository icon next to the clock in the Windows Server icon tray, and I can connect with Sybase Central, as long as I point it to ‘servoy_repository’. Quitting Developer, starting both services and trying to connect using Sybase Central is still a no go.
Something else is weird with this machine: the repository icon doesn’t show next to the clock when started with Server, even if I checked the box to allow it to ‘interact with desktop’.
Like I said, it must be something machine-specific, because I suspect this setup shouldn’t give me so much grief…
This whole situation would probably have been resolved much sooner if I had been more clear as to my method of remotely connecting to this server. Using '/console/ did, in fact, resolve the issue. Fantastic!
As always, this forum shows that it’s made up of a vibrant and extremely helpful and responsive community of Servoy users, developers and engineers. Hats off to all of you/us!
