Quite some time ago I installed Sybase Central 9.0.2 without (then) realizing that it won’t work with Mac OS X 10.4.x. I could never connect to my Sybase DBs and hoped, someday it would be fixed. It doesn’t seem so till today? Or am I wrong? How to uninstall 9.0.2? What are the consequences for already created DBs in 9.0.2?
Isn’t it a bit painful that such things don’t get fixed for such a long time or am I missing something here?
Quite some time ago I installed Sybase Central 9.0.2 without (then) realizing that it won’t work with Mac OS X 10.4.x. I could never connect to my Sybase DBs and hoped, someday it would be fixed. It doesn’t seem so till today? Or am I wrong? How to uninstall 9.0.2? What are the consequences for already created DBs in 9.0.2?
Isn’t it a bit painful that such things don’t get fixed for such a long time or am I missing something here?
I just meant with painful and fixed that if Sybase leds me as default to download Version 9.0.2 on their web site (I just checked it if that’s still the case, and it is: http://crm.sybase.com/sybase/www/iAS/de … sp?tpl=ias) I can assume it should work - but as you say, I have to use 9.0.1 to have a workable version on Mac OS X.
The important question is how to properly uninstall version 9.0.2 and I assume I have to create the database from scratch with version 9.0.1 (I did create it in version 9.0.2)?
Thanks for your help/hint and best regards, Robert
jaleman:
Robert Huber:
Hi All
Quite some time ago I installed Sybase Central 9.0.2 without (then) realizing that it won’t work with Mac OS X 10.4.x. I could never connect to my Sybase DBs and hoped, someday it would be fixed. It doesn’t seem so till today? Or am I wrong? How to uninstall 9.0.2? What are the consequences for already created DBs in 9.0.2?
Isn’t it a bit painful that such things don’t get fixed for such a long time or am I missing something here?
I wish iAnywhere would update their database versions as quickly and consistently as we do our product! The problem is that the latest version for Mac is 9.01, and with Sybase Central they ship 9.02 (for everything BUT the Mac).
So… we ship with 9.01 to be compatible.
Hopefully they will update it and allow us to get everyone “on the same page” without additional downloads.
Alternatively, you can use any other DB you want as well.
I wish iAnywhere would update their database versions as quickly and consistently as we do our product! The problem is that the latest version for Mac is 9.01, and with Sybase Central they ship 9.02 (for everything BUT the Mac).
So… we ship with 9.01 to be compatible.
Hopefully they will update it and allow us to get everyone “on the same page” without additional downloads.
Alternatively, you can use any other DB you want as well.
Looks like a great product and works on other databases too…
The only thing you can’t do with it is create a new database but for the rest it looks like a great alternative to the sybase (and other) admin products (if you need/want a GUI)
I am interested to hear about your experience with AquaDataStudio. For the immediate moment, I would like to hear from someone who has done the same mistake as I did about how to uninstalling SybaseCentral version 9.0.2 on a Mac (accidentally installed it, as I did not know better and if I have to recreate the database and all tables with version 9.0.1 or if I can still use these created with version 9.0.2?
I am not sure if throwing the SQLAnywhere9 folder in Applications away is enough or if I need an uninstaller to properly clean it from the system.
Thanks and good success, Robert
IT2BE:
I think it is said before…
But, I am testing AquaDataStudio.
Looks like a great product and works on other databases too…
The only thing you can’t do with it is create a new database but for the rest it looks like a great alternative to the sybase (and other) admin products (if you need/want a GUI)
By removing /Applications/SQLAnywhere9 and clearing the trash, you almost remove SQL Anywhere from the Mac OS X machine. There is one more file created under your home folder within the “.MacOSX” folder named environment.plist which can also be removed to be thorough.
I can also praise Aqua Data Studio. I have been using it for around two years and it does bascially everything you want to do. Plus it connects to all major databases and does even support “their specialties”.
I have bought ‘eSuite4X J’. Looked good and promising at the time and they promised me support for iAnywhere. To date the support of iAnywhere goes no further than just simple sql queries. Their support sucks to say the least. In other words after I bought the product they never bothered giving an answer…
I have used Aqua Data Studio on Mac OS X for the last 18 months and it is great. It works with all(?) the SQL databases you are likely to come across in your Servoy work.
For PostgreSQL there is the free pgAdmin3, which does create new databases, and does a good job of warning you when you are about to forget something , setting primary keys, always using UTF8 when creating databases etc…
I also use DBViz just for diagramming schemas… look much neater than the Aqua Data Studio ones.
I did that and installed version 9.0.1 - without succces It did just install one folder named System and the log file, that was it.
I use Mac OS X 10.4.5 and Java 1.5. I also tried only to install the tools as I already have the database from the Servoy installing, as far as I understand. Did not work either. Any hints what I did wrong?
Best regards, Robert
chris.gruber:
By removing /Applications/SQLAnywhere9 and clearing the trash, you almost remove SQL Anywhere from the Mac OS X machine. There is one more file created under your home folder within the “.MacOSX” folder named environment.plist which can also be removed to be thorough.
Just to chime in I too would emphatically recommend Aqua Data Studio. I have been using it for just about three years now and it is an almost perfect complementary tool to Servoy - indispensable in my view if you want to get into the SQL at all. Besides all of its neat features the other thing that is very good about it - like Servoy I would add - is the support. It seems to be mostly or completely one guy doing it and he is really good about taking suggestions. His development cycle is about as rapid as Servoy’s too! He is also very knowledgeable about the different db’s and the different drivers. Of course it helps that ADS is free for educational institutions but even without that I would gladly pay for it.
, setting primary keys, always using UTF8 when creating databases etc…