Home Home Screenshots Download Documentation Contact Licensing

Documentation: Aqua Data Studio 4.7     HTML Documentation download, ZIP: ads-docs.zip (Size: 20MB) / ads-docs-no-shots.zip (Size: 368KB)
  Getting Started
  Installation
  JDBC Drivers
  I. Oracle
  II. DB2 UDB
  III. SQL Server
  IV. Sybase ASE
  V. Sybase Anywhere
  VI. Informix
  VII. PostgreSQL
  VIII. MySQL
  Character sets
  Registering Servers
  I. MSDE 2000
  II. SQL Express 2005
  III. PostgreSQL SSL
  Application
  I. Browser & Scripting 
  II. Visual Editing
  III. SQL History
  IV. Shortcut Toolbar
  V. Options
  VI. Settings
  Query Window
  I. Basics
  II. Shortcut Keys
  III. Toolbar
  IV. Server Side Comments
  V. SQL Automation
  VI. Variable Binding
  VII. Results
  VIII. Save Results
  IX. Auto-completion
  X. SQL Formatter
  XI. Permissions
  XII. Parameterized
  Visual Explain Plan
  I. Basics
  II. Explain Plan
  III. Explain Diagram
  IV. Whiteboard
  Procedure Editor
  Tools
  I. Table Data Editor
  II. Script Generator
  III. ER Diagram
  IV. Query Builder
  V. Import Tool
  VI. Export Tool

  Oracle DBA Tools
  I. Instance Manager
  II. Storage Manager
  III. Rollback Manager
  IV. Log Manager
  V. Security Manager
  VI. Session Manager
  VII. SGA Manager
  VIII. Server Statistics
Sybase Anywhere JDBC Drivers - The Sybase Anywhere JDBC drivers included with ADS work across all versions of Sybase Anywhere from 7.0 to 9.0. There is no need to change or update this driver.

You may locate the latest Sybase JDBC drivers at the following location ...

Vendor: Sybase (jConnect 6.0)
Driver URL: http://www.sybase.com/downloads

To update the ADS JDBC drivers you need to overwrite the ADS jconnect45.jar and/or jconnect55.jar & jconnect60.jar. Below is a listing of the Aqua Data Studio library directory [ADS_HOME]\lib ...

Driver Location (Windows/Linux): [ADS_INSTALL]\lib\jconnect60.jar.jar
Driver Location (OSX): /Aqua Data Studio/Contents/Resources/Java/jconnect60.jar
C:\Program Files\Aqua Data Studio 4.0\lib>dir
 Volume in drive C is Local Disk
 Volume Serial Number is 108C-AA92

 Directory of C:\Program Files\Aqua Data Studio 4.0\lib

06/06/2005  03:35p      DIR          .
06/06/2005  03:35p      DIR          ..
06/25/2002  01:07p              54,368 activation.jar
02/08/2005  08:18a           5,217,547 datastudio.jar
06/27/2003  04:23p           1,146,367 db2java.jar
08/24/2004  02:05p           1,077,696 db2jcc.jar
08/15/2004  09:48p               1,013 db2jcc_license_cu.jar
06/07/2002  08:27a             531,797 ifxjdbc.jar
07/21/2002  10:45p             303,246 jconnect45.jar
04/30/2004  02:20a             896,049 jconnect55.jar
01/25/2005  08:35p             285,111 jtds.jar
08/28/2002  02:58p             305,434 mail.jar
01/21/2005  07:47p           1,773,208 mysql-jdbc.zip
12/23/2004  08:38p             391,434 mysql.jar
03/12/2005  10:27p           1,781,898 nlscharset12.jar
03/12/2005  10:27p           1,196,109 oracle.jar
01/12/2005  07:30p             286,005 postgresql.jar
09/23/2003  01:47p             119,947 xdb.jar
09/23/2003  01:47p             660,890 xmlparserv2.jar
              21 File(s)     22,720,504 bytes
               2 Dir(s)  35,225,890,816 bytes free

C:\Program Files\Aqua Data Studio 4.0\lib>
        
The Java class path for the drivers are already configured for ADS in the datastudio.cfg for launching ADS with datastudio.exe and in datastudio.bat/.sh and datastudio-bundled.bat/.sh for launching ADS from the command line. The contents of the file are as followed ...
C:\Program Files\Aqua Data Studio 4.0>type datastudio.cfg
.
.\jre\bin\javaw.exe
-Xmx256M -cp ".\lib\datastudio.jar;.\lib\oracle.jar;
.\lib\nlscharset12.jar;.\lib\jtds.jar;
.\lib\mysql.jar;.\lib\postgresql.jar;
.\lib\jconnect45.jar;.\lib\db2java.jar;.\lib\db2jcc.jar;
.\lib\db2jcc_license_cu.jar;.\lib\ifxjdbc.jar;
.\lib\jconnect55.jar;.\lib\mail.jar;
.\lib\activation.jar;.\lib\xmlparserv2.jar;
.\lib\xdb.jar" com.aquafold.datastudio.DataStudio
        
C:\Program Files\Aqua Data Studio 4.0>type datastudio.bat
SET ADS_PATH=
SET ADS_PATH=%ADS_PATH%;.\lib\oracle.jar
SET ADS_PATH=%ADS_PATH%;.\lib\nlscharset12.jar
SET ADS_PATH=%ADS_PATH%;.\lib\jtds.jar
SET ADS_PATH=%ADS_PATH%;.\lib\mysql.jar
SET ADS_PATH=%ADS_PATH%;.\lib\postgresql.jar
SET ADS_PATH=%ADS_PATH%;.\lib\jconnect45.jar
SET ADS_PATH=%ADS_PATH%;.\lib\db2jcc.jar
SET ADS_PATH=%ADS_PATH%;.\lib\db2jcc_license_cu.jar
SET ADS_PATH=%ADS_PATH%;.\lib\db2java.jar
SET ADS_PATH=%ADS_PATH%;.\lib\ifxjdbc.jar
SET ADS_PATH=%ADS_PATH%;.\lib\jconnect55.jar

SET ADS_PATH=%ADS_PATH%;.\lib\xmlparserv2.jar
SET ADS_PATH=%ADS_PATH%;.\lib\xdb.jar

SET ADS_PATH=%ADS_PATH%;.\lib\mail.jar
SET ADS_PATH=%ADS_PATH%;.\lib\activation.jar

java -cp ".\lib\datastudio.jar;%ADS_PATH%" com.aquafold.datastudio.DataStudio
        

Home Screenshots Downloads Documentation Support Licensing Copyright© 2001-2006 AquaFold, Inc. All Rights Reserved