Microsoft SQL Server JDBC Drivers - The jTDS JDBC (v1.2) drivers included with ADS
work across all versions of SQL Server. There shouldn't be any need to change or update this driver.
If there is a need to update to the latest version of the driver, you may locate the latest jTDS JDBC driver at the following location ...
Vendor: jTDS Open Source Project
Driver URL: http://sourceforge.net/project/showfiles.php?group_id=33291
To update the ADS JDBC drivers you need to overwrite the ADS jtds.jar file and ntlmauth.dll on the Windows platform.
Below is a listing of the Aqua Data Studio library directory [ADS_HOME]\lib ...
Driver Location (Windows): [ADS_INSTALL]\lib\jtds.jar & [ADS_INSTALL]\ntlmauth.dll
Driver Location (Linux): [ADS_INSTALL]\lib\jtds.jar
Driver Location (OSX): /Aqua Data Studio/Contents/Resources/Java/jtds.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
|
