I have an intel Mac and have recently eagerly installed Sybase iAnywhere 10 to finally move away from having to use iAnywhere 9 in Windows in Parallels (which had stopped working anyway - stacktrace error on startup - uninstalled / reinstalled etc.).
Trouble is that iAnywhere 10 will not create a database. I go through the wizard and at the end it just errors out and says “Could not connect to the database, Unable to start database server”. I have tried unselecting “connect to database server” as the last step, I have tried with all settings default and with variations etc. Does the database server have to be running to generate the .db file? (I’ve tried with and without dbsrv9 running) Also, if it does require the database server to be running, does it need to be dbsrv10? - does such a thing exist? How do I get Servoy to use dbsrv10?
The error in Sybase Central is as follows:
[Sybase][ODBC Driver][SQL Anywhere]Unable to start database server
Error code=-80
SQL state=08001
I’m beginning to think that I need to upgrade Servoy’s dbsrv9 to dbsrv10. Any pointers on that? Any impact that that will have on my existing development of existing solutions??
I guess I had assumed that it would be able to create .db files for dbsrv9 on the basis that iAnywhere 10 CAN connect to and interact with iAnywhere 9 .db files.
Anyone have any idea of what the impact would be (primarily on the continued development of my range of iAnywhere 9 solutions out there) if I just ran dbsrv10 in Servoy developer…
Unfortunatly I have no ansers, only questions (as you). I would like to hear from Servoy/Sybase how to move from a development environment using iAnywhere V9 to V10? What has to be done or are there already built in utilities. With what version is Servoy today delivered? Or is there already something written somewhere and I missed it?
Best regards, Robert
Thunder:
More thoughts…
I guess I had assumed that it would be able to create .db files for dbsrv9 on the basis that iAnywhere 10 CAN connect to and interact with iAnywhere 9 .db files.
Anyone have any idea of what the impact would be (primarily on the continued development of my range of iAnywhere 9 solutions out there) if I just ran dbsrv10 in Servoy developer…
Maybe I missed something but I don’t think Servoy has an installation package that includes Sybase 10 yet and I know that it won’t work straight ‘out of the pack’. You’ll have to mess around with the libraries I believe. Jan Aleman helped me get a regular Servoy CRM solution going for MacWorld in January. This is how the sybase_db directory looks of this working Servoy SQLAnywhere 10 set up. The first line in the sybase.config reads:
Also the last time I checked (about a month ago), SQLAnywhere didn’t really have everything ironed out for converting a 9 database to 10 on the MacIntel machines.
Out of curiosity whey were you using Parallels to run 9 on your MacIntel? It seems to run fine on my machine. Sybase Central is a bit touchy but with the suggestions that David Jonker gave on the Forum it does work. I only use it for creating databases but it does that fine and I think all the other things too if you need it.
I can confirm that the iAnywhere runs (or at least seems to as up to now I did not find a problem - hopefully it stays so) ok on my MacBook Pro 15" 2.16GHz (the one which is sold now).
Best regards, Robert
PS: John, I also have to check the hints from David Jonker, as my Sybase Central is also touchy
john.allen:
Hi Bevil,
Maybe I missed something but I don’t think Servoy has an installation package that includes Sybase 10 yet and I know that it won’t work straight ‘out of the pack’. You’ll have to mess around with the libraries I believe. Jan Aleman helped me get a regular Servoy CRM solution going for MacWorld in January. This is how the sybase_db directory looks of this working Servoy SQLAnywhere 10 set up. The first line in the sybase.config reads:
Also the last time I checked (about a month ago), SQLAnywhere didn’t really have everything ironed out for converting a 9 database to 10 on the MacIntel machines.
Out of curiosity whey were you using Parallels to run 9 on your MacIntel? It seems to run fine on my machine. Sybase Central is a bit touchy but with the suggestions that David Jonker gave on the Forum it does work. I only use it for creating databases but it does that fine and I think all the other things too if you need it.
I just wanted to note that you cannot run a database created with version 9 on a version 10 server. You must rebuild the version 9 database into the 10 format. You can do this from Sybase Central (the version that ships with v10), or by using the v10 command line tools (dbunload).
I am not familiar with the Servoy development environment yet, so I am not sure if it can connect to a version 10 database server, though I suspect it will be able to.
When I last checked at the time of MacWorld (Jan. 11th or so), on the Mac version at least you couldn’t do an upgrade of an earlier release through Sybase Central. The documentation said you could and described exactly how to do it but those commands (‘Upgrade’) were simply not there in Sybase Central 10 on a MacIntel machine. They told me at Mac World they would be coming out with a fix soon but I haven’t heard whether they have. Do you know anything about it?
On a separate note, I’ve found Servoy to be pretty good about only releasing database upgrades as part of their install package when it is really ready for primetime, i.e. works on all platforms, etc. I remember this was the case when moving from 9.0.0 to 9.0.1 to 9.0.2. I jumped the gun in going to 9.0.2 on the Mac. I was able to do some work arounds to get things going but in general I’d wait until Servoy includes it as part of an install unless you a) really need the upgrade and b) are OK with mucking around to fix any possible problems. I imagine it will be a separate install as 10 won’t work in non-Intel Macs. ( Supposedly you can run both (9 and 10) on the same machine which will be nice but I couldn’t get that to go: probably to do with the port or something.)
I guess I was a bit gung ho about the whole thing after not being able to run Sybase Central for so long (since getting the intel Mac in May '06). I didn’t know about the 9.02 workaround until it got mentioned in this thread. I was just holding out until 10 came out, then downloaded it, set up some Sybase 9 backups with it to demonstrate to someone (which worked just fine) and never considered the implication creating databases with the newer version of iAnywhere. It is a little troubling that intel Macs have a flaky version of 9.02 and can’t move to 10 without Servoy updating their install (and what effect will THAT have on old solutions?).
Anyway, I am going to try out the Sybase 9 workaround for now - or just create new databases on my G5 (or just make one template database and duplicate / rename it whenever I need another one).
One niggling question though is that even if I WAS able to use Sybase 10 with Servoy, how come I can’t create a Sybase 10 database with Sybase Central on my Intel Mac? Regardless of Servoy, surely it should still be able to create a .db file, no?
This whole thing seems to have opened up a can of worms though, any comments from Servoy?
As I and others have commented, 9.0.2 itself really isn’t at all ‘flaky’ on a MacIntel machine. I’ve had no problems with it whatsoever. The only problems have had to do with Sybase Central (i.e. SQLAnywhere’s own Java interface to the db). The only reason I personally use Sybase Central at all is for either creating a new database (which I do rarely as mostly I’m just copying them) or trying to do something like upgrade a database which, as mentioned, I tried unsuccessfully so far with 10 because it wasn’t available.
In other words I think you are worrying about things before they are in place. For right now 9.0.2 works just fine on all platforms and when 10 is totally ready on all platforms AND Servoy has outlined the upgrade procedure, I’m sure they will tell us like they have done in the past with iAnywhere upgrades. In the meantime however everything works fine on 9.0.2 on all platforms. As an aside and as I’ve mentioned on the Forum in the past, personally I’d highly recommend getting Aqua Data Studio to use as your main way of communicating with whatever database you are using when you want to do that outside of Servoy. It will give you a consistent look and feel for all databases and is just an outstanding tool. I integrates so well with Servoy on all my development work as well as doing all the direct database stuff I do (running complicated queries for the MD’s here, etc.).
john.allen:
When I last checked at the time of MacWorld (Jan. 11th or so), on the Mac version at least you couldn’t do an upgrade of an earlier release through Sybase Central. The documentation said you could and described exactly how to do it but those commands (‘Upgrade’) were simply not there in Sybase Central 10 on a MacIntel machine. They told me at Mac World they would be coming out with a fix soon but I haven’t heard whether they have. Do you know anything about it?
John,
I think you are referring to the “Prepare a version 9 or earlier for SA10” task that should show up in Sybase Central, but for some reason, it does not in the Mac version of SC. I am not sure if development has resolved this yet.
I just now realized wht the problem is. In 9.0.2, we only support PPC, but in version 10, we only support Intel. So to move from version 9 to version 10 is going to be a bit more involved process than on the other platforms. You have to:
Unload your database using the version 9 dbunload utility, or the v9 Sybase Central unload wizard. This generates a reload.sql script containing all of your schema, and a set of data files containing all of your data.
Create your version 10 database using the v10 Sybase Central.
Execute the reload script generated in step 1 against your newly created v10 database.
