× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
Like  

3.10 SQL Server JDBC Drivers

JDBC Drivers - Microsoft SQL Server JDBC Drivers

JDBC Drivers - 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\drivers\ ...

Driver Location (Windows):
[ADS_INSTALL]\lib\\drivers\jtds.jar
[ADS_INSTALL]\ntlmauth.dll

Driver Location (Linux):
[ADS_INSTALL]\lib\drivers\jtds.jar

Driver Location (OSX):
/Aqua Data Studio/Contents/Resources/Java/drivers/jtds.jar

The Java class path for the drivers are already configured for ADS in the datastudio.ini 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 follows ...

C:\Program Files (x86)\Aqua Data Studio 9.0 - 32bit\lib\drivers>dir
 Volume in drive C has no label.
 Volume Serial Number is 40F4-2392

 Directory of C:\Program Files (x86)\Aqua Data Studio 9.0 - 32bit\lib\drivers

07/19/2010  02:05 PM              .
07/19/2010  02:05 PM              ..
07/19/2010  08:36 AM         1,146,367 db2java.jar
07/19/2010  08:36 AM         3,059,973 db2jcc.jar
07/19/2010  08:36 AM             1,015 db2jcc_license_cu.jar
07/19/2010  08:36 AM         2,446,767 derby.jar
07/19/2010  08:36 AM           514,328 derbyclient.jar
07/19/2010  08:36 AM           229,921 derbynet.jar
07/19/2010  08:36 AM           723,264 ifxjdbc.jar
07/19/2010  08:36 AM           562,289 jconnect60.jar
07/19/2010  08:36 AM         4,393,355 jt400.jar
07/19/2010  08:36 AM           334,207 jtds-src.jar
07/19/2010  08:36 AM           324,739 jtds.jar
07/19/2010  08:36 AM           651,205 mysql-src.jar
07/19/2010  08:36 AM           723,660 mysql.jar
07/19/2010  08:36 AM           445,188 ncluster.jar
07/19/2010  08:36 AM         1,646,178 nlscharset12.jar
09/17/2010  01:32 PM           339,634 nzjdbc.jar
07/19/2010  08:36 AM         1,555,682 oracle.jar
07/19/2010  08:36 AM           475,580 postgresql.jar
07/19/2010  08:36 AM           286,773 util400.jar
07/19/2010  08:36 AM           139,148 xdb.jar
07/19/2010  08:36 AM           839,982 xmlparserv2.jar
              21 File(s)     20,499,621 bytes
               2 Dir(s)  196,816,015,360 bytes free

C:\Program Files (x86)\Aqua Data Studio 9.0 - 32bit\lib\drivers>

The Java class path for the drivers are already configured for ADS in the datastudio.ini 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 follows ...

C:\Program Files (x86)\Aqua Data Studio 9.0 - 32bit>type datastudio.ini
working.directory=.

# JVM Properties
vm.location=.\jre\bin\client\jvm.dll

# Specify a proportion of the available physical memory to use (ie. relates to -
Xmx arg). For example, vm.heapsize.max.percent=75. Note that this will use the m
aximum memory possible.
#vm.heapsize.max.percent=

#Specify a proportion of the available physical memory to use as the minimum sta
rting heap size (ie. relates to -Xms arg).
#vm.heapsize.min.percent=

#Specify a preferred amount (in MB) for the heap size (ie. relates to -Xmx arg).
 If this amount is not available it will use the maximum amount possible given t
he physical memory available.
#vm.heapsize.preferred=

#Specifies that only one instance of the product should run at any given time
single.instance=window

vmarg.1=-Dsun.swing.enableImprovedDragGesture
vmarg.2=-Xmx256M
vmarg.3=-XX:MaxPermSize=128m

classpath.1=.\lib\*.jar
classpath.2=.\lib\antlr\*.jar
classpath.3=.\lib\apache\*.jar
classpath.4=.\lib\apple\*.jar
classpath.5=.\lib\aquafold\*.jar
classpath.6=.\lib\aspose\*.jar
classpath.7=.\lib\dnsjava\*.jar
classpath.8=.\lib\drivers\*.jar
classpath.9=.\lib\infragistics\*.jar
classpath.10=.\lib\itext\*.jar
classpath.11=.\lib\java\*.jar
classpath.12=.\lib\jgoodies\*.jar
classpath.13=.\lib\jgraph\*.jar
classpath.14=.\lib\jide\*.jar
classpath.15=.\lib\jinterop\*.jar
classpath.16=.\lib\jna\*.jar
classpath.17=.\lib\jogl\*.jar
classpath.18=.\lib\quartz\*.jar
classpath.19=.\lib\snmp4j\*.jar
classpath.20=.\lib\ssh2\*.jar
classpath.21=.\lib\stndeditor\*.jar
classpath.22=.\lib\svnkit\*.jar

main.class=com.aquafold.datastudio.DataStudio




C:\Program Files (x86)\Aqua Data Studio 9.0 - 32bit>type datastudio.bat
ECHO OFF

SET ADS_PATH=

SET ADS_PATH=%ADS_PATH%;.\lib\ads.jar
SET ADS_PATH=%ADS_PATH%;.\lib\aqua-lib.jar

SET ADS_PATH=%ADS_PATH%;.\lib\antlr\stringtemplate.jar

SET ADS_PATH=%ADS_PATH%;.\lib\apache\apache-ant.jar
SET ADS_PATH=%ADS_PATH%;.\lib\apache\apache-ant-commons-net.jar
SET ADS_PATH=%ADS_PATH%;.\lib\apache\apache-ant-jsch.jar
SET ADS_PATH=%ADS_PATH%;.\lib\apache\apache-ant-launcher.jar
SET ADS_PATH=%ADS_PATH%;.\lib\apache\apache-ant-nodeps.jar
SET ADS_PATH=%ADS_PATH%;.\lib\apache\apache-batik.jar
SET ADS_PATH=%ADS_PATH%;.\lib\apache\apache-fop.jar
SET ADS_PATH=%ADS_PATH%;.\lib\apache\apache-log4j.jar
SET ADS_PATH=%ADS_PATH%;.\lib\apache\apache-poi.jar
SET ADS_PATH=%ADS_PATH%;.\lib\apache\apache-poi-contrib.jar
SET ADS_PATH=%ADS_PATH%;.\lib\apache\apache-poi-ooxml.jar
SET ADS_PATH=%ADS_PATH%;.\lib\apache\apache-poi-ooxml-schemas.jar
SET ADS_PATH=%ADS_PATH%;.\lib\apache\apache-poi-scratchpad.jar
SET ADS_PATH=%ADS_PATH%;.\lib\apache\apache-serializer.jar
SET ADS_PATH=%ADS_PATH%;.\lib\apache\apache-xalan.jar

SET ADS_PATH=%ADS_PATH%;.\lib\apache\commons-beanutils.jar
SET ADS_PATH=%ADS_PATH%;.\lib\apache\commons-codec.jar
SET ADS_PATH=%ADS_PATH%;.\lib\apache\commons-collections.jar
SET ADS_PATH=%ADS_PATH%;.\lib\apache\commons-configuration.jar
SET ADS_PATH=%ADS_PATH%;.\lib\apache\commons-dbcp.jar
SET ADS_PATH=%ADS_PATH%;.\lib\apache\commons-dbutils.jar
SET ADS_PATH=%ADS_PATH%;.\lib\apache\commons-email.jar
SET ADS_PATH=%ADS_PATH%;.\lib\apache\commons-httpclient.jar
SET ADS_PATH=%ADS_PATH%;.\lib\apache\commons-io.jar
SET ADS_PATH=%ADS_PATH%;.\lib\apache\commons-lang.jar
SET ADS_PATH=%ADS_PATH%;.\lib\apache\commons-logging.jar
SET ADS_PATH=%ADS_PATH%;.\lib\apache\commons-logging-adapters.jar
SET ADS_PATH=%ADS_PATH%;.\lib\apache\commons-logging-api.jar
SET ADS_PATH=%ADS_PATH%;.\lib\apache\commons-math.jar
SET ADS_PATH=%ADS_PATH%;.\lib\apache\commons-net.jar
SET ADS_PATH=%ADS_PATH%;.\lib\apache\commons-net-ftp.jar
SET ADS_PATH=%ADS_PATH%;.\lib\apache\commons-primitives.jar
SET ADS_PATH=%ADS_PATH%;.\lib\apache\commons-transaction.jar
SET ADS_PATH=%ADS_PATH%;.\lib\apache\commons-validator.jar
SET ADS_PATH=%ADS_PATH%;.\lib\apache\commons-vfs.jar
SET ADS_PATH=%ADS_PATH%;.\lib\apache\commons-xmlgraphics.jar
SET ADS_PATH=%ADS_PATH%;.\lib\apache\dom4j.jar

SET ADS_PATH=%ADS_PATH%;.\lib\apache\hadoop-core.jar
SET ADS_PATH=%ADS_PATH%;.\lib\apache\jakarta-oro.jar
SET ADS_PATH=%ADS_PATH%;.\lib\apache\jcraft-jsch.jar
SET ADS_PATH=%ADS_PATH%;.\lib\apache\tidy.jar

SET ADS_PATH=%ADS_PATH%;.\lib\apple\aqua2.jar
SET ADS_PATH=%ADS_PATH%;.\lib\aquafold\geo.jar
SET ADS_PATH=%ADS_PATH%;.\lib\aspose\aspc.jar
SET ADS_PATH=%ADS_PATH%;.\lib\dnsjava\dnsjava.jar

SET ADS_PATH=%ADS_PATH%;.\lib\drivers\db2java.jar
SET ADS_PATH=%ADS_PATH%;.\lib\drivers\db2jcc.jar
SET ADS_PATH=%ADS_PATH%;.\lib\drivers\db2jcc_license_cisuz.jar
SET ADS_PATH=%ADS_PATH%;.\lib\drivers\db2jcc_license_cu.jar
SET ADS_PATH=%ADS_PATH%;.\lib\drivers\derby.jar
SET ADS_PATH=%ADS_PATH%;.\lib\drivers\derbyclient.jar
SET ADS_PATH=%ADS_PATH%;.\lib\drivers\derbynet.jar
SET ADS_PATH=%ADS_PATH%;.\lib\drivers\ifxjdbc.jar
SET ADS_PATH=%ADS_PATH%;.\lib\drivers\jconnect55.jar
SET ADS_PATH=%ADS_PATH%;.\lib\drivers\jconnect60.jar
SET ADS_PATH=%ADS_PATH%;.\lib\drivers\jt400.jar
SET ADS_PATH=%ADS_PATH%;.\lib\drivers\jtds.jar
SET ADS_PATH=%ADS_PATH%;.\lib\drivers\mysql.jar
SET ADS_PATH=%ADS_PATH%;.\lib\drivers\ncluster.jar
SET ADS_PATH=%ADS_PATH%;.\lib\drivers\nlscharset12.jar
SET ADS_PATH=%ADS_PATH%;.\lib\drivers\nzjdbc.jar
SET ADS_PATH=%ADS_PATH%;.\lib\drivers\oracle.jar
SET ADS_PATH=%ADS_PATH%;.\lib\drivers\postgresql.jar
SET ADS_PATH=%ADS_PATH%;.\lib\drivers\tdgssconfig.jar
SET ADS_PATH=%ADS_PATH%;.\lib\drivers\terajdbc4.jar
SET ADS_PATH=%ADS_PATH%;.\lib\drivers\util400.jar
SET ADS_PATH=%ADS_PATH%;.\lib\drivers\xdb.jar
SET ADS_PATH=%ADS_PATH%;.\lib\drivers\xmlparserv2.jar

SET ADS_PATH=%ADS_PATH%;.\lib\infragistics\infragistics.jar
SET ADS_PATH=%ADS_PATH%;.\lib\itext\itext.jar
SET ADS_PATH=%ADS_PATH%;.\lib\java\activation.jar
SET ADS_PATH=%ADS_PATH%;.\lib\java\mail.jar
SET ADS_PATH=%ADS_PATH%;.\lib\java\servlet-api.jar
SET ADS_PATH=%ADS_PATH%;.\lib\java\tools.jar
SET ADS_PATH=%ADS_PATH%;.\lib\jgoodies\looks.jar
SET ADS_PATH=%ADS_PATH%;.\lib\jgraph\jgraph.jar
SET ADS_PATH=%ADS_PATH%;.\lib\jgraph\jgraphlayout.jar

SET ADS_PATH=%ADS_PATH%;.\lib\jide\jide-action.jar
SET ADS_PATH=%ADS_PATH%;.\lib\jide\jide-beaninfo.jar
SET ADS_PATH=%ADS_PATH%;.\lib\jide\jide-common.jar
SET ADS_PATH=%ADS_PATH%;.\lib\jide\jide-components.jar
SET ADS_PATH=%ADS_PATH%;.\lib\jide\jide-dialogs.jar
SET ADS_PATH=%ADS_PATH%;.\lib\jide\jide-dock.jar
SET ADS_PATH=%ADS_PATH%;.\lib\jide\jide-grids.jar
SET ADS_PATH=%ADS_PATH%;.\lib\jide\jide-pivot.jar
SET ADS_PATH=%ADS_PATH%;.\lib\jide\jide-shortcut.jar
SET ADS_PATH=%ADS_PATH%;.\lib\jide\jide-properties.jar

SET ADS_PATH=%ADS_PATH%;.\lib\jinterop\jcifs.jar
SET ADS_PATH=%ADS_PATH%;.\lib\jinterop\j-interop.jar
SET ADS_PATH=%ADS_PATH%;.\lib\jinterop\j-interopdeps.jar

SET ADS_PATH=%ADS_PATH%;.\lib\jna\jna.jar
SET ADS_PATH=%ADS_PATH%;.\lib\jna\platform.jar
SET ADS_PATH=%ADS_PATH%;.\lib\jogl\jogl.jar
SET ADS_PATH=%ADS_PATH%;.\lib\jogl\gluegen-rt.jar
SET ADS_PATH=%ADS_PATH%;.\lib\quartz\quartz.jar
SET ADS_PATH=%ADS_PATH%;.\lib\snmp4j\snmp4j.jar
SET ADS_PATH=%ADS_PATH%;.\lib\ssh2\ssh2.jar

SET ADS_PATH=%ADS_PATH%;.\lib\stndeditor\lib.core.jar
SET ADS_PATH=%ADS_PATH%;.\lib\stndeditor\lib.htmlcss.jar
SET ADS_PATH=%ADS_PATH%;.\lib\stndeditor\lib.java.jar
SET ADS_PATH=%ADS_PATH%;.\lib\stndeditor\lib.javascript.jar
SET ADS_PATH=%ADS_PATH%;.\lib\stndeditor\lib.xml.jar
SET ADS_PATH=%ADS_PATH%;.\lib\stndeditor\standalone-htmlcss.jar
SET ADS_PATH=%ADS_PATH%;.\lib\stndeditor\standalone-java.jar
SET ADS_PATH=%ADS_PATH%;.\lib\stndeditor\standalone-javascript.jar
SET ADS_PATH=%ADS_PATH%;.\lib\stndeditor\standalone-core.jar
SET ADS_PATH=%ADS_PATH%;.\lib\stndeditor\standalone-xml.jar

SET ADS_PATH=%ADS_PATH%;.\lib\svnkit\svnkit-cli.jar
SET ADS_PATH=%ADS_PATH%;.\lib\svnkit\svnkit-javahl.jar
SET ADS_PATH=%ADS_PATH%;.\lib\svnkit\svnkit.jar

ECHO ON

java -Xmx256M -XX:MaxPermSize=192m -cp "%ADS_PATH%" com.aquafold.datastudio.Data
Studio







C:\Program Files (x86)\Aqua Data Studio 9.0 - 32bit>
Last updated by swissarmyknife(*) on Jun 3, 2010 5:16 PM
This list is empty.

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017