Q: How do I connect to DB2 7.1?

A: Aqua Data Studio currently supports DB2 7.2 out-of-the-box, but can
support DB2 7.1 with a minor configuration change.  DB2 7.1 and 7.2 use
different version drivers.  Aqua Data Studio comes with the drivers for DB2
7.2.  To connect to 7.1 you will need to replace /datastudio/lib/db2java.jar
with the JDBC driver that comes with DB2 7.1, which is called db2java.zip.
Once you replace the driver, you may start ADS and connect to 7.1 using the
"DB2 UDB 7.2" option.

You currently may not connect to both a DB2 7.1 and 7.2 server at the same
time.  This feature will be investigated in future versions.


-John



>-------Reply Reply Message-----
>Hi John,
>I changed db2java.jar with my db2java.zip, now It works perfectly.
>
>Thanks for your help!
>
>Bye.
>
>
>-------Reply Message-----
>Hi,
>
>I have tested Aqua Data Studio with v7.2 but not 7.1.  I think everthing
>should be the same.  I have had some problems with 7.2 in which the DB2
>drivers don't acknowledge the port settings, but if you don't specify the
>port than you should be ok.  If you have DB2 installed on the default
server
>port then you should be able to connect.  Here is a screenshot of the DB2
>settings that I have ...
>
>http://www.aquafold.com/screenshots/misc/db2/registration.jpg
>
>If you still have a problem connecting, then you might need to replace the
>/datastudio/lib/db2java.jar file with the JDBC driver that comes with DB2
>7.1, which is called db2java.zip.
>
>Let me know if this helps.
>
>-John
>
>
>-----Original Message-----
>Sent: Monday, January 20, 2003 7:31 AM
>To: support@...
>Subject: how to use aqua studio with db2
>
>
>I'm trying to use aqua studio with db2 v. 7.1, but when I try to connect
>to a server I always receive a socket error. I'm sure of all parameters
>i use. Can you help me?
>
>I thank you in advance.
>
>Best regards.
>

Hi,

I released version 1.5 last week and I have received some good feedback from
users.  Below I attached a list of features that I will start working on
next week.  The list is not set in stone, but more of a guideline.  I just
wanted to keep everyone posted on the future direction of ADS.

Any other feedback, you may just email directly at JohnLH@...

thanks
-John




Installation
-----------------
1. Readme.txt & Web Instructions for installing/running application
2. Remove .bat files from OSX, Solaris and Linux packages
3. Need a better execution script for MacOSX

Options Dialog
-----------------
1. AutoCompletion (ON/OFF, AutoComplete Column on all schema or just
current)
2. Query Analyzer - Ability to turn autocommit ON and OFF, Commit, Rollback,
turn autocomplete ON and OFF, specify max results returned
3. Scripts: Ability to specifing filter for scripts (.sql, .proc)

Schema Browser
-----------------
1. A "Select All" and "Select top 100" popup item on the tables in the
browser.
2. Postgres - add primary key folder for table
3. Sort objects in schema viewer
4. Show parameters (types and default values) for stored procedures and
functions for all databases.

Query Analyzer
------------------
1. Add hot key to execute current statement even if not selected
2. SQL Query History for all executed queries
4. Auto-commit ON/OFF
5. Buttons for 'Commit' and 'Rollback' for each connection window
6. Option to fetch/show only 'X' resultset rows at a time
7. Search in text results
8. Work on Stop Button, allow for cancelling even when waiting for database
server
9. Postgres issues "WARNING:  COMMIT: no transaction in progress" after
select

Database Support
-----------------------
1. Add support for TDS5.5/jConnect5.5 for Sybase
2. Research support for Sybase Anywhere
3. Research support for Interbase
4. Unicode on Postgres ANSII/LATIN1
5. Research support for connecting to DB2 7.1 and 7.2 at the same time

BUGS
-----------------------
1. Try to isolate bug --- When creating new server group , after creating 2
groups and when creating the third group even 'Database Servers' is selected
the third group is created under the second group(happens when database
servers is expanded). Collapsing the "database servers" and creating the
third group creates the group correctly.





Post 2.0
------------------------------------------------
1. Table Data Editor for query results
2. Ability to sort table columns
2. SQL Bookmarks or enhancements of Scripts browser
3. Visual Explain Plan - Explain Plan for queries (Oracle, DB2 and SQL
Server)
4. Add ability to execute scripts from command line, so that you can
schedule scripts.
5. Add Text Editor ... quick open from text results screen and other areas
6. Visual GUI Forms for creating, altering and dropping database objects ...
including Stored Procedures and Functions
7. Capability to generate DML (insert statements) for tables/views. This
option could probably be made available via the File->Save Results menu
option.
8. Web Start of Aqua Data Studio

Hi, I have placed a minor patch at
http://www.aquafold.com/download/datastudio_1_5_6.jar ... if the fixes do
not affect you then you probably don't need the patch. If you do, then you
may download the patch and overwrite your /datastudio/lib/datastudio.jar
with the patch.


change log
------------------

1.5.6 : Fixed: Query Analyzer - If the text results in the "Text Result" tab
of the Query Analyzer is selected, copied and pasted into Notepad or other
text editor the linefeeds are lost. Now Fixed.

1.5.5 : Fixed: Postgres 7.3 - Support for displaying Unicode characters.

1.5.4 : Fixed: Postgres 7.3 - Views, Users, Groups and other folders in
schema browser are not displayed (It seems 7.3 meta data schema has
changed). Now Fixed.

1.5.3 : Fixed: Generic JDBC/Interbase - Generic JDBC connection for
Interbase didn't work. Now fixed.

1.5.2 : Fixed: Postgres 7.3 - Table in schema browser are not displayed. Now
Fixed

1.5.1 : Fixed: SQL Server column auto-completion to query all tables in the
current database and not to filter on schema. This bug only affects users
who are logged into a database as a user who does not own the schema he/she
is working on.


-John

Hi, I have placed a minor patch at
http://www.aquafold.com/download/datastudio_1_5_5.jar ... if the fixes do
not affect you then you probably don't need the patch. If you do, then you
may download the patch and overwrite your /datastudio/lib/datastudio.jar
with the patch.


change log
------------------

1.5.5 : Fixed: Postgres 7.3 - Support for displaying Unicode characters.

1.5.4 : Fixed: Postgres 7.3 - Views, Users, Groups and other folders in
schema browser are not displayed (It seems 7.3 meta data schema has
changed). Now Fixed.

1.5.3 : Fixed: Generic JDBC/Interbase - Generic JDBC connection for
Interbase didn't work. Now fixed.

1.5.2 : Fixed: Postgres 7.3 - Table in schema browser are not displayed. Now
Fixed

1.5.1 : Fixed: SQL Server column auto-completion to query all tables in the
current database and not to filter on schema. This bug only affects users
who are logged into a database as a user who does not own the schema he/she
is working on.


-John

Hi, I have placed a minor patch at
http://www.aquafold.com/download/datastudio_1_5_4.jar ... if the fixes do
not affect you then you probably don't need the patch. If you do, then you
may download the patch and overwrite your /datastudio/lib/datastudio.jar
with the patch.


change log
------------------

1.5.4 : Fixed: Postgres 7.3 - Views, Users, Groups and other folders in
schema browser are not displayed (It seems 7.3 meta data schema has
changed). Now Fixed.

1.5.3 : Fixed: Generic JDBC/Interbase - Generic JDBC connection for
Interbase didn't work. Now fixed.

1.5.2 : Fixed: Postgres 7.3 - Table in schema browser are not displayed. Now
Fixed

1.5.1 : Fixed: SQL Server column auto-completion to query all tables in the
current database and not to filter on schema. This bug only affects users
who are logged into a database as a user who does not own the schema he/she
is working on.


-John

-----Original Message-----
From: Frederick_Lim@... [mailto:Frederick_Lim@...]
Sent: Wednesday, January 15, 2003 5:32 PM
To: aquadatastudio@yahoogroups.com
Subject: [aquadatastudio]

Are there any plans to support Sybase Anywhere Studio 7 & 8?

Best Regards,
Frederick Lim




To unsubscribe from this group, send an email to:
aquadatastudio-unsubscribe@yahoogroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

-----Original Message-----
From: Daniel Stutz [mailto:daniel.stutz@...]
Sent: Wednesday, January 15, 2003 3:20 PM
To: aquadatastudio@yahoogroups.com
Subject: [aquadatastudio] Interbase

Hi folks

I've sucessfully used Aquadata studio 1.5 with a MySQL database.
First I got a strange errror message from java.sql
"java.sql.SQLException: Server configuration denies access to data source",
but I solved the problem with grants for the user to the host "
computer.domain"
(host, db table in the mysql database).

Are there any plans to support Interbase/FireBird ?

Best regards
Dani


To unsubscribe from this group, send an email to:
aquadatastudio-unsubscribe@yahoogroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

Hi, I have place a minor patch at
http://www.aquafold.com/download/datastudio_1_5_3.jar ... if the fixes do
not affect you then you probably don't need the patch.  If you do, then you
may download the patch and overwrite your /datastudio/lib/datastudio.jar
with the patch.


change log
------------------

1.5.3 : Fixed: Generic JDBC/Interbase - Generic JDBC connection for
Interbase didn't work. Now fixed.

1.5.2 : Fixed: Postgres 7.3 - Table in schema browser are not displayed. Now
Fixed

1.5.1 : Fixed: SQL Server column auto-completion to query all tables in the
current database and not to filter on schema.  This bug only affects users
who are logged into a database as a user who does not own the schema he/she
is working on.


-John

Are there any plans to support Sybase Anywhere Studio 7 & 8?

Best Regards,
Frederick Lim

Hi folks

I've sucessfully used Aquadata studio 1.5 with a MySQL database.
First I got a strange errror message from java.sql
"java.sql.SQLException: Server configuration denies access to data source",
but I solved the problem with grants for the user to the host "
computer.domain"
(host, db table in the mysql database).

Are there any plans to support Interbase/FireBird ?

Best regards
Dani

Hi, I have place a minor patch at
http://www.aquafold.com/download/datastudio_1_5_2.jar ... if the fixes do
not affect you then you probably don't need the patch.  If you do, then you
may download the patch and overwrite your /datastudio/lib/datastudio.jar
with the patch.


change log
------------------

1.5.1 : Fixed: SQL Server column auto-completion to query all tables in the
current database and not to filter on schema.  This bug only affects users
who are logged into a database as a user who does not own the schema he/she
is working on.

1.5.2 : Fixed: Postgres 7.3 - Table in schema browser are not displayed.

-John

Q: Do multiple SQL windows for a particular DB use the same connection
object?

A: No, each window has it's own connection so that you may have multiple
queries executing at the same time.

-John

Q: Does the "Stop" button work?

A: The "Stop" button works, well, kind-of ... if you hit the "Stop" button
it will signal Aqua Data Studio to stop, but if it is still waiting for the
database server to execute the current query it will wait until the server
returns.  So, the stop button currently only helps if you are returning a
large dataset and need to stop it, or if you have a database script which
you want to stop while executing.


Version 2.0: I will look into having the "Stop" button cancel the query even
if ADS is waiting on the database server.

-John

-----Original Message-----
From: gjhicks12 <gjhicks12@...> [mailto:gjhicks12@...]
Sent: Monday, January 13, 2003 1:15 PM
To: aquadatastudio@yahoogroups.com
Subject: [aquadatastudio] Re: Autocompletion problem

If it helps, this worked fine in the previous version.  Also, the data
explorer shows all of the tables and their columns just fine.


> 1. Are you connected to SQL Server 2000 with a Generic JDBC
connection or
> native? (Generic currently doesn't support autocompletion)

I have set it up to use Sql Server 2000 in the setup menu.

> 2. In the query window what is the database: ? schema: ? username: ?
(This
> is the info that ADS uses to query for the table/column info)
> 3. What package did you download from the website? What OS are you 
  unning
The schema and the username are the same as the logged in user.

> it on? (so, that I can test it with that exact distribution)

Full executable adstudio.exe with JVM. Windows 2000.

> 4. What is the version of the SQL Server? (you can get this with a
"select  @@version" from the query window)

Microsoft SQL Server  2000 - 8.00.679 (Intel X86) 
      Aug 26 2002 15:09:48 
      Copyright (c) 1988-2000 Microsoft Corporation
      Developer Edition on Windows NT 5.0 (Build 2195: Service Pack 3)

-----Original Message-----
From: James Schwacofer [mailto:jschwacofer@...]
Sent: Monday, January 13, 2003 10:13 AM
To: aquadatastudio@yahoogroups.com
Subject: [aquadatastudio] .bat file for os x?

I downloaded the OS X vesion of aqua studio and after de-compressing it I noticed that there was a .bat file in the folder. Do I have the right version? Also, how am I supposed to run the application itself?

The file I d/l was: adstudio-novm.tar.gz

Thanks for any help,
James

If it helps, this worked fine in the previous version.  Also, the data
explorer shows all of the tables and their columns just fine.




> 1. Are you connected to SQL Server 2000 with a Generic JDBC
connection or


> native? (Generic currently doesn't support autocompletion)


I have set it up to use Sql Server 2000 in the setup menu.




> 2. In the query window what is the database: ? schema: ? username: ?
(This


> is the info that ADS uses to query for the table/column info)


> 3. What package did you download from the website? What OS are you
running


The schema and the username are the same as the logged in user.




> it on? (so, that I can test it with that exact distribution)


Full executable adstudio.exe with JVM. Windows 2000.




> 4. What is the version of the SQL Server? (you can get this with a
"select


> @@version" from the query window)




Microsoft SQL Server  2000 - 8.00.679 (Intel X86)


	 Aug 26 2002 15:09:48


	 Copyright (c) 1988-2000 Microsoft Corporation


	 Developer Edition on Windows NT 5.0 (Build 2195: Service Pack 3)






--- In aquadatastudio@yahoogroups.com, "John L H" <JohnLH@a...> wrote:


> Hi,


>


> There is some info that would help.


>


>


> -John


>   -----Original Message-----


>   From: gjhicks12 <gjhicks12@y...> [mailto:gjhicks12@y...]


>   Sent: Monday, January 13, 2003 11:23 AM


>   To: aquadatastudio@yahoogroups.com


>   Subject: [aquadatastudio] Re: Autocompletion problem


>


>


>   > You type:


>   > "select * from ^" and the tables should pop-up.


>


>   Works fine.


>


>   > You type:


>   > "select * from table1 where ^" and the columns should pop-up


>


>   Does not work at all.


>


>   > You type:


>   > "select ^ from table1" and when you move back to the ^ the
fields


>   for table1


>


>   Does not work at all.


>


>   Anything I should look at to help out?  Is there a log?

-----Original Message-----
From: gjhicks12 <gjhicks12@...> [mailto:gjhicks12@...]
Sent: Monday, January 13, 2003 11:23 AM
To: aquadatastudio@yahoogroups.com
Subject: [aquadatastudio] Re: Autocompletion problem

> You type:
> "select * from ^" and the tables should pop-up.

Works fine.

> You type:
> "select * from table1 where ^" and the columns should pop-up

Does not work at all.

> You type:
> "select ^ from table1" and when you move back to the ^ the fields
for table1

Does not work at all.

Anything I should look at to help out?  Is there a log?

> You type:


> "select * from ^" and the tables should pop-up.


Works fine.





> You type:


> "select * from table1 where ^" and the columns should pop-up


Does not work at all.





> You type:


> "select ^ from table1" and when you move back to the ^ the fields
for table1


Does not work at all.




Anything I should look at to help out?  Is there a log?




--- In aquadatastudio@yahoogroups.com, "John L H" <JohnLH@a...> wrote:


> Hi,


>


> Autocompletion should work in this manner ...


>


> You type:


> "select * from ^" and the tables should pop-up.


>


> You type:


> "select * from table1 where ^" and the columns should pop-up


>


> You type:


> "select ^ from table1" and when you move back to the ^ the fields
for table1


> should popup


>


> Here is a screenshot on SQL Server 2000:


>
http://www.aquafold.com/screenshots/windows/general/autocompletion-lar
ge.jpg


>


> You need to make sure that you have selected the database you will
be


> working on (eg: "Northwind")


>


> Is there a specific manner you want the autocompletion to work?


>


> -John


>


>   -----Original Message-----


>   From: Gabe Hicks [mailto:gjhicks12@y...]


>   Sent: Monday, January 13, 2003 10:47 AM


>   To: aquadatastudio@yahoogroups.com


>   Subject: [aquadatastudio] Autocompletion problem


>


>


>   I can get it to complete table names in the from


>   clause, but it will not complete anything else.


>


>   I just installed 1.5 and am pointed at Mircosoft SQL


>   Server 2000.


>


>


>   =====


>   Gabe Hicks


>


>   __________________________________________________


>   Do you Yahoo!?


>   Yahoo! Mail Plus - Powerful. Affordable. Sign up now.


>   http://mailplus.yahoo.com


>


>         Yahoo! Groups Sponsor


>               ADVERTISEMENT


>


>


>


>


>   To unsubscribe from this group, send an email to:


>   aquadatastudio-unsubscribe@yahoogroups.com


>


>


>


>   Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service.

-----Original Message-----
From: Gabe Hicks [mailto:gjhicks12@...]
Sent: Monday, January 13, 2003 10:47 AM
To: aquadatastudio@yahoogroups.com
Subject: [aquadatastudio] Autocompletion problem

I can get it to complete table names in the from
clause, but it will not complete anything else.

I just installed 1.5 and am pointed at Mircosoft SQL
Server 2000. 


=====
Gabe Hicks

__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com


To unsubscribe from this group, send an email to:
aquadatastudio-unsubscribe@yahoogroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

I can get it to complete table names in the from
clause, but it will not complete anything else.

I just installed 1.5 and am pointed at Mircosoft SQL
Server 2000.


=====
Gabe Hicks

__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com

-----Original Message-----
From: James Schwacofer [mailto:jschwacofer@...]
Sent: Monday, January 13, 2003 10:13 AM
To: aquadatastudio@yahoogroups.com
Subject: [aquadatastudio] .bat file for os x?

I downloaded the OS X vesion of aqua studio and after de-compressing it I noticed that there was a .bat file in the folder. Do I have the right version? Also, how am I supposed to run the application itself?

The file I d/l was: adstudio-novm.tar.gz

Thanks for any help,
James

I downloaded the OS X vesion of aqua studio and after de-compressing it
I noticed that there was a .bat file in the folder.  Do I have the
right version?  Also, how am I supposed to run the application itself?

The file I d/l was: adstudio-novm.tar.gz

Thanks for any help,
James

Hi!

I downloaded Linux version WITHOUT VM, since I have
JRE 1.4.1... here's the output of "java --version":

java version "1.4.1_01"
Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.1_01-b01)
Java HotSpot(TM) Client VM (build 1.4.1_01-b01, mixed mode)

Oracle server is running ok since last year, other people in my department
are using it correctly... I'm not a java expert, but it seems to me that
it's not a ADS problem...

I asked about the installation of the Oracle Libraries, since PHP (as an
example) requires them for its OCI functions...

I can send you the output of the program when the Network Connection
Exception raises, but I wouldn't like to send it in the list, since it's about
80 lines long...
Thanks in advance!
Alex


On Monday 13 January 2003 10:28, John L H wrote:
> Hi,
>
> You do not have to install any Oracle software. Aqua Data Studio (ADS)
> should work from the installation.  If your database server is not running
> on the default port (1521) you will need to specify the port.  You will
> also need to specify the SID.
>
> If you do not have the Oracle software on your machine you can test that
> your Oracle server is running with telnet (eg "telnet <address> <port>) and
> make sure it is running.  If you have Oracle software you can do a tnsping
> (eg "tnsping <servicename>") to make sure it is running.
>
> Since I just released the 1.5 packages I can double check that the ADS
> package you downloaded is working.  Which one of the following did you
> download?
>
> -John LH
>
>
>      WINDOWS (adstudio.exe) 25.9MB
>      WINDOWS (adstudio.zip) 22.7MB
>      WINDOWS (adstudio-novm.zip) ** 5.53MB
>
>      LINUX (adstudio.tar.gz)  27.4MB
>      LINUX (adstudio-novm.tar.gz) **  4.78MB
>
>      MAC OSX (adstudio-novm.tar.gz) *  4.78MB
>
>      SOLARIS (adstudio-novm.tar.gz) **  4.78MB
>
>      JAVA ENABLED OS (adstudio-novm.zip) **  5.53MB
>      JAVA ENABLED OS (adstudio-novm.tar.gz) **  4.78MB
>
>
>

	WINDOWS (adstudio.exe)	25.9MB
	WINDOWS (adstudio.zip)	22.7MB
	WINDOWS (adstudio-novm.zip) **	5.53MB
	LINUX (adstudio.tar.gz)	27.4MB
	LINUX (adstudio-novm.tar.gz) **	4.78MB
	MAC OSX (adstudio-novm.tar.gz) *	4.78MB
	SOLARIS (adstudio-novm.tar.gz) **	4.78MB
	JAVA ENABLED OS (adstudio-novm.zip) **	5.53MB
	JAVA ENABLED OS (adstudio-novm.tar.gz) **	4.78MB

 

 

 -----Original Message-----
From: Alessandro Danti [mailto:alessandro@...]
Sent: Monday, January 13, 2003 1:08 AM
To: aquadatastudio@yahoogroups.com
Subject: [aquadatastudio] Hello!

Hi,

this is the first time I write in this mailing list.
I downloaded aquastudio because it should work with Oracle8i...
Seems to be a really nice alternative to systems like TOAD or else...
Fact is, that when I try to register a dbserver, it tells me that
"Connection failed: Io exception:
The Network Adapter could not establish the connection"
Since the address of the server is correct, I assume that I have to have
Oracle Libraries installed on my workstation... or not?
Has anyone encountered the same problem as me?

thanks in advance,
Alex

To unsubscribe from this group, send an email to:
aquadatastudio-unsubscribe@yahoogroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

Hi,

this is the first time I write in this mailing list.
I downloaded aquastudio because it should work with Oracle8i...
Seems to be a really nice alternative to systems like TOAD or else...
Fact is, that when I try to register a dbserver, it tells me that
"Connection failed: Io exception:
The Network Adapter could not establish the connection"
Since the address of the server is correct, I assume that I have to have
Oracle Libraries installed on my workstation... or not?
Has anyone encountered the same problem as me?

thanks in advance,
Alex

Q: How do I execute an Oracle stored procedure in Query Analyzer?

A: You may execute a stored procedure in Query Analyzer by wrapping the
statement in a PL/SQL block.  SQL*Plus will normally do this for you, so you
get the impression that Oracle handles the statement as is.

EXAMPLE:

>>DECLARE
>>    JOB_NUMBER NUMBER;
>>BEGIN
>>    DBMS_JOB.SUBMIT( JOB_NUMBER, 'SCHEMA.SENDEMAIL;', sysdate+1/24/60*1,
'sysdate+1/24/60*5');
>>END;
>>/

-John LH

Q: How do I connect to Microsoft SQL Server using a "Trusted Connection"?

A: You currently can't connect to SQL Server using a "Trusted Connection".
Aqua Data Studio is a 100% Java application which provides platform
portablilty.  A "Trusted Connection" is based off of Windows Authentication
and would require an OS specific integration.

-John LH

Q: How do I connect to Microsoft SQL Server Desktop Edition?

A: You may connection to SQL Server Desktop Edition in the same manner as
any other SQL Server version.  But you must make sure to enable "mixed
authentication" before you try to connect since "trusted connection" is not
supported by Aqua Data Studio.

You may identify the port number SQL Server is running on in many different
ways.  One way is to look at the registry settings
"MyComputer\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
Server\edm\MSSQLServer\SuperSocketNetLib\Tcp".

-John LH

Q: How do I connect to multiple Instances of SQL Server on the same machine?

A: You may connect to multiple Instances of SQL Server on the same machine
by identifing on what ports each Instance is running on.  For SQL Server
2000 you can run the "SQL Server Network Utility".  You may then select the
Instance of SQL Server and make sure the "TCP/IP" protocol is enabled.  Then
you may select the TCP/IP protocol and click properties, this should tell
you the default port.

Once you know the port of each Instance you may register a connection for
each Instance by specifying the hostname and the port for each
connection/Instance.

-John LH

Aqua Data Studio 1.5 Released (support for DB2, Sybase, Postgres and
Generic-JDBC)


Aqua Data Studio is a FREE SQL editor and developer tool that allows
developers to easily create, edit, and execute SQL scripts, as well as
browse database structures.

Aqua Data Studio provides an integrated database environment with a single
consistent interface to all major relational databases. This allows the DBA
or developer to tackle multiple tasks simultaneously from one application.
Aqua Data Studio's sophisticated Query Analyzer allows users to work on
database scripts with specific RDBMS syntax highlighting and auto-completion
to develop and test scripts, including detailed client statistical
information and multi-grid results. Its graphical browsing capabilities
allow you to understand the structure and dependencies of the database
schema at a click of a mouse. It also includes the ability to save your
query results in many formats including HTML and XML.

Features include:
	 - Support for any Java enabled OS (Windows, Linux, OSX, Solaris)
	 - Support for Oracle 8i/9i, DB2 7.2/8.1, Microsoft SQL Server 7.0/2000,
		 Sybase ASE 12.5, PostgreSQL and MySQL
	 - Database Schema Explorer
	 - SQL Script Explorer
	 - Query Analyzer for script execution
	 - Multi-grid support for multi-select statements
	 - Database specific syntax coloring
	 - Auto-completion for SQL statments
	 - Export query results to HTML, CSV or XML
	 - Auto-Describe with Ctrl-D Hotkey
	 - Auto-Template Insertion with F12 Hotkey


Downloads: http://www.aquafold.com/downloads.html

Screenshots: http://www.aquafold.com/screenshots.html