I am running InteractiveSQL ( 10.0.1 ) on an IntellMac running 10.6.2. ; connecting to a database on the network works like a charm.
Running a local database, I can connect with the SQL Explorer in Servoy 5.0.1, but the thing is so slow but OK. But I can’t get some commands working ( UNLOAD comes to mind ) ; they do work in InteractiveSQL, but I am not able to connect to that local database. I get the message : can’t start the
Does anyone know how to connect to a local database using InteractiveSQL on MacOS 10.6.2 ?
A question on the side : can I connect to the database using SQLExplorer ( servoy ) and InteractiveSQL at the same time ?
In the connect wizard, “database” tab: make sure “servoy_repository” of your localhost is selected in the Server name field. Or you can select a database file directly further down the pane.
In both cases the database has to be running already – either by starting up the associated Servoy developer first or by some other method.
My experience is that InteractiveSQL is not the best app I use - to say it this way. Sometimes, if you try several times, it suddenly connects for no obvious reason - better I had said for no reason at all. The same is true for Sybase Central.
For example, we found that if you run on your local machine a database server, e. g. dbsrv11 and you are connected to a server running another dbsrv11 process as well, whatever you select when pressing the Find… button in the presented list, it connects to the local dbsrv11 process, even if you select the server side process. Since version 11 entering into the server name field ip-address:port doesn’t work anymore, very annoying. There is a new tab called Network, with Host: and Port(s) fields, but it downs’t seem to work - at least here.
No very motivating, I know, but I am quite frustrated with this piece of software, it makes no progress at all. For example simple things like connection profiles which exist in Sybase just don’t make it into InteractiveSQL, and that’s not much to ask for I think. May be a Sybase Developer is reading here as well and has the chance to make it better or could tell me where to put bug messages for these tools …
Best regards, Robert
PS: We use on a daily basis pgAdmin3 for PostgreSQL databases. This app - doing the same tasks as InteractiveSQL and Sybase Central, is on a different level - although or because it’s OpenSource. A real pleasure to use compared to the Sybase Tools.
My experience is that InteractiveSQL is not the best app I use - to say it this way. Sometimes, if you try several times, it suddenly connects for no obvious reason - better I had said for no reason at all. The same is true for Sybase Central.
For example, we found that if you run on your local machine a database server, e. g. dbsrv11 and you are connected to a server running another dbsrv11 process as well, whatever you select when pressing the Find… button in the presented list, it connects to the local dbsrv11 process, even if you select the server side process. Since version 11 entering into the server name field ip-address:port doesn’t work anymore, very annoying. There is a new tab called Network, with Host: and Port(s) fields, but it downs’t seem to work - at least here.
No very motivating, I know, but I am quite frustrated with this piece of software, it makes no progress at all. For example simple things like connection profiles which exist in Sybase just don’t make it into InteractiveSQL, and that’s not much to ask for I think. May be a Sybase Developer is reading here as well and has the chance to make it better or could tell me where to put bug messages for these tools …
Best regards, Robert
PS: We use on a daily basis pgAdmin3 for PostgreSQL databases. This app - doing the same tasks as InteractiveSQL and Sybase Central, is on a different level - although or because it’s OpenSource. A real pleasure to use compared to the Sybase Tools.
Totally agree. We dumped Sybase years ago mainly because their tools are downright ugly pieces of software. Definitely no fun to use.
If anyone ever has to work with multiple SQL vendors (MySQL, Oracle, Sybase, MSsql, etc.) I just can’t praise high enough Aqua Data Studio. All the tools are integrated now in it for developers (ER Modeler, Schema Script generator, Import/Export, your complete history of SQLs you’ve written) as well as for DBA work for Oracle, MySQL, Sybase, SQL Server and DB2. And with that you get a tool that works, gives you a common interface for all of the different vendors and outstanding support. Yes it costs money but sometimes you get what you pay for. Those involved with open source projects get it for a reduced price or maybe even free, I’m not sure which. Java, cross-platform as well , i.e. works perfectly on Macs too.
we are working a lot with DBVisualizer, but with that one, you can’t ALTER or create DB’s with SQL anywhere 9,10 or 11, so we always have to install/use Sybase Central for that (and I agree, Sybase central sucks… )
Can you create schema’s db’s & alter columns with Aquadata studio in combination with SQL anywhere 11?
Good to hear that is a good tool. As we use EOModeler from WebObjects, i. e. the current version is Entity Modeler from WOLips, we have all our designs in the eomodel format. So, I assume I can’t try AquaData Studio unless it is capable of importing this format. Otherwise, you can image, it makes no sense for us.
ADS does have a ‘create database’ GUI for SQL Anywhere (this is where you can do the normal things like deciding whether to encrypt the database, case sensitivity, page size, etc.). This will then create a separate database along the same lines that come with the default Servoy installation like ‘example’, ‘servoy_repository’, ‘udm’, etc. I’m thinking that’s what you mean. There is also a simple command line in SQL Anywhere for creating a schema (“CREATE SCHEMA <SCHEMA_NAME>”) but I don’t believe there are any particular options for that and so that can just be run as a simple command. And you can do all the normal stuff like building/altering tables, adding indexes, constraints, etc. all in very simple, intuitive GUIs. What they don’t yet have is a nice GUI for some of the regular DBA stuff. But those things generally aren’t things I really need to do a lot and sometimes I do them from the command line and sometimes I pull out Sybase Central…
Robert as for importing EOMOdeler files I’m quite sure it doesn’t. I’m kind of surprised that that’s still around. I thought Apple didn’t sell that anymore. But if that’s what you need I’m quite sure that ADS can’t help you with that part.
john.allen:
If anyone ever has to work with multiple SQL vendors (MySQL, Oracle, Sybase, MSsql, etc.) I just can’t praise high enough Aqua Data Studio. All the tools are integrated now in it for developers (ER Modeler, Schema Script generator, Import/Export, your complete history of SQLs you’ve written) as well as for DBA work for Oracle, MySQL, Sybase, SQL Server and DB2. And with that you get a tool that works, gives you a common interface for all of the different vendors and outstanding support. Yes it costs money but sometimes you get what you pay for. Those involved with open source projects get it for a reduced price or maybe even free, I’m not sure which. Java, cross-platform as well , i.e. works perfectly on Macs too.
I don’t mind paying for tools – we keep up to date with Navicat even with a plethora of free options for MySQL. And Aqua Data Studio always comes up in recommendation threads.
But my big question about a database vendor is: how good is their database product if their front-end products are so bad? It doesn’t compute that there is a terrific database behind such bad front-ends. It’s just a natural human assumption – whether it’s correct or not.
Just to chip in my two cents worth: We use dbVizualiser, personally I spend most of my hours in it, and I couldn’t be happier.
It does not do everything (most bothering, it doesn’t fetch my coffee), but what it does (wich is 98% of what I need to do) it does very very well, and it is fast, reliable and a pleasure to use.
Still need to open Sybase central (ughhh) and MS sql studio (ughhh) for some things though…
One more word to Sybase Central and the db server connections.
I can manage now several sybase db servers on different server machines by only one Sybase Central instance on my local Mac. The “Network” connection settings in Sybase Central since vers. 11 are working well. Ok, that’s not the point of this topic, but I would say I got that running with a lot of help from the sybase community at Sybase > Support&Service > Community Forums/Newsgroups > sybase.public.sqlanywhere.web [http://forums.sybase.com/cgi-bin/webnews.cgi?cmd=listitems&sort_on=none&second_sort=date&sort_method=date&sort_reverse=true&group=sybase.public.sqlanywhere.web].
Because I’m a registered user by Sybase I get emails from Sybase with the opportunity to find solutions and/or make suggestions. Perhaps this could be a good way to talk to Sybase make their tools better, or?
tgs:
Because I’m a registered user by Sybase I get emails from Sybase with the opportunity to find solutions and/or make suggestions. Perhaps this could be a good way to talk to Sybase make their tools better, or?
What can you say that would be productive? “Sybase Central was ugly six years ago when I first had to use it and it hasn’t changed much since then.” I wouldn’t know where to start except to say blow it up and start over.
The only thing I would say David is don’t judge a book by the cover. SQL Anywhere itself I’ve always found to be very robust, fast and ready and willing to add nice features to the database itself. True Sybase Central pretty much sucks and for that reason I use ADS (plus the fact that ADS gives me a common interface to all the different vendor databases). But the database itself has been rock solid for me. I sometimes think the reason they have been lazy about improving Sybase Central is most of their developers are either command line types or buy their more expensive tools. But Sybase Central for me became a non-issue a few years ago.
Hi guys,
I know it’s not totally related to this topic, but as it’s reasonably current and to do with Sybase I’ll give it a go.
I am trying to stop using the default DBA/SQL username/password on a clients Sybase 10 back-end.
In Sybase Central I have created a new user ‘servoy’ with a password.
I have given that user DBA & Resource Authorities.
I have also GRANTed ALL permissions to them on tables, BUT that user still cannot see the tables of the database!
What do I have to do to make the user just like the DBA user, but not them?
(One reason, other than good security, is that there are other processes that are accessing the back-end table and some are leaving open connections, but all are using DBA as username, so I want Servoy to have a specific username, and then do the same for the other processes so that we can see what is not closing connections properly)