I have been using ADS for a while and it really replaced my old/individual tools for each DB Engine out there. I would just love (and ask if its cooming)...
Hi, There are plans for a Query Builder (http://www.aquafold.com/download/futurefeatures.txt). Some users have been asking for this. Although I don't have an...
John, 1) May be it would be beneficial to open and close database connection on per-request basis, i.e. open connection, execute request, and close connection....
Thanks for replying John. Check out WebMatrix's 'create a new table' dialog boxes. It doesn't ask for constraints, it just creates them based on the options...
Hi Michael, ... request, and close connection. This would ... establishing more than one This wouldn't work with all the current features of the Query...
... It would also slow things down a lot, wouldn't it ? I don't personally see a why multiple connections to the database is a problem, in and of itself. -- ...
Thomas Chiverton
thomas.chiverton@...
Apr 6, 2005 3:02 pm
1959
I'e installed a local copy of Informix Dynamic Server V. 10 on my Fedora Core 3 Linux box. Ive also installed AquaFold Data Studio v4 to evaluate / for ...
kevin.kempter@...
Apr 6, 2005 8:31 pm
1960
The server isn't where you are saying. Most probably the port is wrong - informix isn't listening on port 1526. Next most likely problem is a wrong or...
Hi, I hadn't tested ADS with Informix v10 so I downloaded and installed it for testing. Initially I was unable to connect, so I updated the ADS JDBC driver...
Hi John,
I've been given a MySql database, and some of the fields are Enum, is there a way to display the values associated with the field?? Thanks in...
I'm using Aquadata against an IBM iSeries (AS/400) wich JDBC generic. DB2 UDB don't work (it was commented in this forum). When you Describe (Ctrl+D) a table,...
Turns out it was neither of these. Using the hostname resolves out fine and the port (1555) is correct via the /etc/services file. I ended up re-installing the...
kevin.kempter@...
Apr 7, 2005 4:52 pm
1965
Hi Tomo, ADS currently doesn't support displaying of the enum values. The only way to see them is to execute a SHOW command ("show columns from table_name")....
Hi, In the Generic JDBC connection type ADS gets the column info from the DatabaseMetaData. ADS currently doesn't display the comment information, but I will...
John, I would like to be able to "export data" -> Format: "INSERT Statements" to a new window instead of the file. Thanks, Michael ... ADS ... Analzyer. ... ...
Hi, After some time working on other things I have upgraded to the latest MySQL: mysql Ver 14.7 Distrib 4.1.10a, for apple-darwin7.7.0 (powerpc) This...
Hi Frank, From the error message that you are getting I believe the problem is that you need to grant access to your user for that machine. ... *Register MySQL...
John,
Thanks, that's brill:) Can't think why I didn't think of that... Can also use "describe table".
Thanks again!
Tom
John LH wrote:
> Hi Tomo,
>
>...
John, Found a small bug. Nothing that causes any problems to the outcome. If there are two or more select statements together, the 'rows selected' count is...
Hi all, i'm a new ADS user (with Sybase ASE 12.5) and i have a problem with a query. I have a stored procedure containing the following syntax : select...
Hi, I found the problem, it occurs when "Display Query Stats" is false and "Always display record count" is true. I have fixed the problem and it will be in...
Hi, MySQL 5.0 beta is now out so I have started adding support for the new features. I have added support for views, procedures, functions and new user...
Hi, Is there a way to view/edit the packages. procedures, and otther db objects in a pane/tab, rather than in a separate window? Often times it's very useful...
Hi Frank, Currently, you can do a Script Object - CREATE OR REPLACE to a new query window, which works well but won't give you compilation errors. A...
Hi all, I am running Aqua Studio 4.0.1 on OS X 10.3.8. I am trying to get things done with a mysql 4.1 database. I connected successfully to the mysql server...
Philipp Ringli
lists@...
Apr 12, 2005 3:13 pm
1980
Hi Phil, ... highlighted gray but I cannot edit anything. ADS currently doesn't support the ALTERing of columns. This will be in the next version of ADS. You...