Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
Aqua Data Studio / nhilam |
Follow
825
|
Aqua Data Studio comes bundled with Oracle 11g JDBC drivers. These drivers are compatible with Oracle 11g, 10g and 9i when using the Oracle (non-OCI) connection in Aqua Data Studio. To make an OCI connection or to connect to Oracle 8i, please follow the appropriate instructions below.
Aqua Data Studio is bundled with the Oracle 11g JDBC drivers. Oracle has discontinued support for Oracle 8i in their Oracle 11g drivers. Aqua Data studio still supports Oracle 8i, but you need to backdrop the Oracle drivers from 11g to 10g. Below are the instructions to backdrop to Oracle 10g drivers.
Note: Renaming the files is not sufficient. You must either delete these files or move them to a directory outside of [ADS_HOME]
Using the Oracle 10g Drivers in Aqua Data Studio to Connect to Oracle 8i | |
Before Deleting the Oracle 11g drivers | After Deleting the Oracle 11g drivers and pasting the Oracle 10g JDBC drivers |
Help > About > JDBC Drivers tab indicating 10.2 |
To make an Oracle OCI Connection, you need to ensure that the Oracle JDBC drivers used by ADS are build compatible with the Oracle version you have installed on your machine.
Failing to do this may cause ADS to crash.
The best way to ensure compatibility is to copy the Oracle JDBC drivers from your Oracle Client installation directory into ADS's drivers directory. The set of files that need to copied vary by Oracle version. Please follow the appropriate link based upon the version of Oracle you have installed.
OSX Users: OCI Connections are not supported on OSX. There is no need to change or update the drivers on OSX.
Warning: If running 32-bit Oracle Client, you must use 32-bit Aqua Data Studio. If running 64-bit Oracle Client, you must use 64-bit Aqua Data Studio.
Renaming the files is not sufficient. You must either delete these files or move them to a directory outside of [ADS_HOME]
Location of Oracle 11g Client JDBC Drivers | |
C:\ora\app\admin\product\11.2.0\dbhome\jdbc\lib>dir
01/16/2013 05:19 PM <DIR> .
01/16/2013 05:19 PM <DIR> ..
02/23/2010 10:09 PM 1,996,390 ojdbc5.jar
02/23/2010 10:09 PM 2,429,986 ojdbc5dms.jar
02/23/2010 10:09 PM 3,102,538 ojdbc5dms_g.jar
02/23/2010 10:09 PM 3,081,969 ojdbc5_g.jar
02/23/2010 10:09 PM 2,111,338 ojdbc6.jar <- copy this
02/23/2010 10:09 PM 2,656,012 ojdbc6dms.jar
02/23/2010 10:09 PM 3,423,966 ojdbc6dms_g.jar
02/23/2010 10:09 PM 3,402,257 ojdbc6_g.jar
02/23/2010 10:09 PM 20,355 simplefan.jar
9 File(s) 22,224,811 bytes
2 Dir(s) 127,050,838,016 bytes free
C:\ora\app\admin\product\11.2.0\dbhome\jdbc\lib>
|
C:\ora\app\admin\product\11.2.0\dbhome\jlib>dir
01/16/2013 05:54 PM <DIR> .
01/16/2013 05:54 PM <DIR> ..
12/28/2005 08:08 AM 55,434 ocrs12.jar
01/02/2008 07:25 PM 2,313,802 ojdbc5dms.jar
01/02/2008 07:25 PM 1,062,368 orai18n-collation.jar
01/02/2008 07:25 PM 11,057 orai18n-internal.jar
01/02/2008 07:25 PM 1,469,241 orai18n-lcsd.jar
01/02/2008 07:25 PM 82,953 orai18n-mapping.jar
01/02/2008 07:25 PM 9,799 orai18n-net-ee.jar
01/02/2008 07:25 PM 45,528 orai18n-net.jar
01/02/2008 07:25 PM 85,878 orai18n-servlet.jar
01/02/2008 07:25 PM 86,409 orai18n-tools.jar
01/02/2008 07:25 PM 1,403,740 orai18n-translation.jar
01/02/2008 07:25 PM 405,501 orai18n-utility.jar
01/02/2008 07:25 PM 1,655,204 orai18n.jar <- copy this
13 File(s) 8,686,914 bytes
2 Dir(s) 127,050,846,208 bytes free
C:\ora\app\admin\product\11.2.0\dbhome\jlib>
|
What to modify in [ADS_HOME]/lib/drivers folder | |
C:\Program Files\Aqua Data Studio 13.0 - 64bit\lib\drivers>dir 11/23/2012 08:58 AM <DIR> . 11/23/2012 08:58 AM <DIR> .. 11/22/2012 11:13 AM 35,701 cassandra-clientutil.jar 11/22/2012 11:13 AM 64,465 cassandra-jdbc.jar ... 11/22/2012 11:13 AM 445,188 ncluster.jar 11/22/2012 11:13 AM 2,714,189 ojdbc6.jar <- delete before paste 11/22/2012 11:13 AM 1,656,248 orai18n.jar <- delete before paste 11/22/2012 11:13 AM 346,944 paraccel-jdbc.jar 11/22/2012 11:13 AM 561,969 postgresql.jar 11/22/2012 11:13 AM 3,516,830 sqlite-jdbc.jar 11/22/2012 11:13 AM 286,773 util400.jar 11/22/2012 11:13 AM 262,740 xdb6.jar 11/22/2012 11:13 AM 839,982 xmlparserv2.jar 28 File(s) 29,365,764 bytes 2 Dir(s) 88,341,790,720 bytes free C:\Program Files\Aqua Data Studio 13.0 - 64bit\lib\drivers> |
C:\Program Files\Aqua Data Studio 13.0 - 64bit\lib\drivers>dir 11/23/2012 08:58 AM <DIR> . 11/23/2012 08:58 AM <DIR> .. 11/22/2012 11:13 AM 35,701 cassandra-clientutil.jar 11/22/2012 11:13 AM 64,465 cassandra-jdbc.jar ... 11/22/2012 11:13 AM 445,188 ncluster.jar 02/23/2010 10:09 PM 2,111,338 ojdbc6.jar <- paste 01/02/2008 07:25 PM 1,655,204 orai18n.jar <- paste 11/22/2012 11:13 AM 346,944 paraccel-jdbc.jar 11/22/2012 11:13 AM 561,969 postgresql.jar 11/22/2012 11:13 AM 3,516,830 sqlite-jdbc.jar 11/22/2012 11:13 AM 286,773 util400.jar 11/22/2012 11:13 AM 262,740 xdb6.jar 11/22/2012 11:13 AM 839,982 xmlparserv2.jar 28 File(s) 28,761,869 bytes 2 Dir(s) 88,341,186,825 bytes free C:\Program Files\Aqua Data Studio 13.0 - 64bit\lib\drivers> |
Warning: If running 32-bit Oracle Client, you must use 32-bit Aqua Data Studio. If running 64-bit Oracle Client, you must use 64-bit Aqua Data Studio.
Renaming the files is not sufficient. You must either delete these files or move them to a directory outside of [ADS_HOME]
Location of Oracle 10g Client JDBC Drivers | |
C:\oracle\product\10.2.0\db_1\jdbc\lib>dir 03/06/2007 10:40p DIR . 03/06/2007 10:40p DIR .. 08/16/2005 04:38p 1,590,041 classes12.jar 08/16/2005 04:38p 1,602,539 classes12.zip 08/16/2005 04:38p 1,597,679 classes12dms.jar 08/17/2005 02:04p 1,642,006 nls_charset12.jar <- copy this 08/16/2005 04:38p 1,536,554 ojdbc14.jar <- copy this 08/16/2005 04:38p 1,544,083 ojdbc14dms.jar 08/16/2005 04:38p 1,936,238 ojdbc14dms_g.jar 08/16/2005 04:38p 1,928,225 ojdbc14_g.jar 8 File(s) 13,377,365 bytes 2 Dir(s) 28,158,951,424 bytes free C:\oracle\product\10.2.0\db_1\jdbc\lib> |
What to modify in [ADS_HOME]/lib/drivers folder | |
C:\Program Files\Aqua Data Studio 13.0 - 64bit\lib\drivers>dir 11/23/2012 08:58 AM <DIR> . 11/23/2012 08:58 AM <DIR> .. 11/22/2012 11:13 AM 35,701 cassandra-clientutil.jar 11/22/2012 11:13 AM 64,465 cassandra-jdbc.jar ... 11/22/2012 11:13 AM 445,188 ncluster.jar 11/22/2012 11:13 AM 2,714,189 ojdbc6.jar <- delete before paste 11/22/2012 11:13 AM 1,656,248 orai18n.jar <- delete before paste 11/22/2012 11:13 AM 346,944 paraccel-jdbc.jar 11/22/2012 11:13 AM 561,969 postgresql.jar 11/22/2012 11:13 AM 3,516,830 sqlite-jdbc.jar 11/22/2012 11:13 AM 286,773 util400.jar 11/22/2012 11:13 AM 262,740 xdb6.jar 11/22/2012 11:13 AM 839,982 xmlparserv2.jar 28 File(s) 29,365,764 bytes 2 Dir(s) 88,341,790,720 bytes free C:\Program Files\Aqua Data Studio 13.0 - 64bit\lib\drivers> |
C:\Program Files\Aqua Data Studio 13.0 - 64bit\lib\drivers>dir 11/23/2012 08:58 AM <DIR> . 11/23/2012 08:58 AM <DIR> .. 11/22/2012 11:13 AM 35,701 cassandra-clientutil.jar 11/22/2012 11:13 AM 64,465 cassandra-jdbc.jar ... 11/22/2012 11:13 AM 445,188 ncluster.jar 08/17/2005 02:04p 1,642,006 nls_charset12.jar <- paste 08/16/2005 04:38p 1,536,554 ojdbc14.jar <- paste 11/22/2012 11:13 AM 346,944 paraccel-jdbc.jar 11/22/2012 11:13 AM 561,969 postgresql.jar 11/22/2012 11:13 AM 3,516,830 sqlite-jdbc.jar 11/22/2012 11:13 AM 286,773 util400.jar 11/22/2012 11:13 AM 262,740 xdb6.jar 11/22/2012 11:13 AM 839,982 xmlparserv2.jar 28 File(s) 28,761,869 bytes 2 Dir(s) 88,341,186,825 bytes free C:\Program Files\Aqua Data Studio 13.0 - 64bit\lib\drivers> |
Warning: If running 32-bit Oracle Client, you must use 32-bit Aqua Data Studio. If running 64-bit Oracle Client, you must use 64-bit Aqua Data Studio.
Renaming the files is not sufficient. You must either delete these files or move them to a directory outside of [ADS_HOME]
Location of Oracle 9i Client JDBC Drivers | |
C:\oracle92\ora92\jdbc\lib>dir 02/04/2003 06:34p DIR . 02/04/2003 06:34p DIR .. 04/26/2002 12:47p 1,033,402 classes111.jar 04/26/2002 12:47p 1,043,528 classes111.zip 04/26/2002 12:47p 1,371,600 classes111_g.jar 04/26/2002 12:47p 1,381,728 classes111_g.zip 04/26/2002 12:47p 1,196,109 classes12.jar 04/26/2002 12:47p 1,207,068 classes12.zip 04/26/2002 12:47p 1,201,552 classes12dms.jar 04/26/2002 12:47p 1,438,406 classes12dms_g.jar 04/26/2002 12:47p 1,432,813 classes12_g.jar 04/26/2002 12:47p 1,443,734 classes12_g.zip 04/26/2002 12:47p 1,781,005 nls_charset11.jar 04/26/2002 12:47p 1,810,518 nls_charset11.zip 04/26/2002 12:47p 1,781,898 nls_charset12.jar <- copy this 04/26/2002 12:47p 1,811,415 nls_charset12.zip 04/26/2002 12:47p 36,640 ocrs12.jar 04/26/2002 12:47p 36,664 ocrs12.zip 04/26/2002 12:47p 1,174,976 ojdbc14.jar <- copy this 04/26/2002 12:47p 1,383,922 ojdbc14_g.jar 18 File(s) 22,566,978 bytes 2 Dir(s) 35,225,325,568 bytes free C:\oracle92\ora92\jdbc\lib> |
What to modify in [ADS_HOME]/lib/drivers folder | |
C:\Program Files\Aqua Data Studio 13.0 - 64bit\lib\drivers>dir 11/23/2012 08:58 AM <DIR> . 11/23/2012 08:58 AM <DIR> .. 11/22/2012 11:13 AM 35,701 cassandra-clientutil.jar 11/22/2012 11:13 AM 64,465 cassandra-jdbc.jar ... 11/22/2012 11:13 AM 445,188 ncluster.jar 11/22/2012 11:13 AM 2,714,189 ojdbc6.jar <- delete before paste 11/22/2012 11:13 AM 1,656,248 orai18n.jar <- delete before paste 11/22/2012 11:13 AM 346,944 paraccel-jdbc.jar 11/22/2012 11:13 AM 561,969 postgresql.jar 11/22/2012 11:13 AM 3,516,830 sqlite-jdbc.jar 11/22/2012 11:13 AM 286,773 util400.jar 11/22/2012 11:13 AM 262,740 xdb6.jar 11/22/2012 11:13 AM 839,982 xmlparserv2.jar 28 File(s) 29,365,764 bytes 2 Dir(s) 88,341,790,720 bytes free C:\Program Files\Aqua Data Studio 13.0 - 64bit\lib\drivers> |
C:\Program Files\Aqua Data Studio 13.0 - 64bit\lib\drivers>dir 11/23/2012 08:58 AM <DIR> . 11/23/2012 08:58 AM <DIR> .. 11/22/2012 11:13 AM 35,701 cassandra-clientutil.jar 11/22/2012 11:13 AM 64,465 cassandra-jdbc.jar ... 11/22/2012 11:13 AM 445,188 ncluster.jar 04/26/2002 12:47p 1,781,898 nls_charset12.jar <- paste 04/26/2002 12:47p 1,174,976 ojdbc14.jar <- paste 11/22/2012 11:13 AM 346,944 paraccel-jdbc.jar 11/22/2012 11:13 AM 561,969 postgresql.jar 11/22/2012 11:13 AM 3,516,830 sqlite-jdbc.jar 11/22/2012 11:13 AM 286,773 util400.jar 11/22/2012 11:13 AM 262,740 xdb6.jar 11/22/2012 11:13 AM 839,982 xmlparserv2.jar 28 File(s) 28,761,869 bytes 2 Dir(s) 88,341,186,825 bytes free C:\Program Files\Aqua Data Studio 13.0 - 64bit\lib\drivers> |
Warning: If running 32-bit Oracle Client, you must use 32-bit Aqua Data Studio. If running 64-bit Oracle Client, you must use 64-bit Aqua Data Studio.
Renaming the files is not sufficient. You must either delete these files or move them to a directory outside of [ADS_HOME]
You must change the .zip file extensions of classes12.zip and nls_charset12.zip to .jar for use in Aqua Data Studio
Location of Oracle 8i Client JDBC Drivers | |
C:\oracle\ora81\jdbc\lib>dir 07/03/2002 10:33p DIR . 07/03/2002 10:33p DIR .. 09/14/2000 03:03p 1,778,452 classes111.zip 09/14/2000 03:21p 1,932,480 classes12.zip <- copy this 08/23/2000 05:58p 97,158 jndi.zip 08/23/2000 05:58p 14,810 jta.zip 06/28/2000 03:58p 10,155,207 nls_charset11.zip 06/28/2000 05:25p 12,097,171 nls_charset12.zip <- copy this 6 File(s) 26,075,278 bytes 2 Dir(s) 2,054,410,240 bytes free C:\oracle\ora81\jdbc\lib> |
What to modify in [ADS_HOME]/lib/drivers folder | |
C:\Program Files\Aqua Data Studio 13.0 - 64bit\lib\drivers>dir 11/23/2012 08:58 AM <DIR> . 11/23/2012 08:58 AM <DIR> .. 11/22/2012 11:13 AM 35,701 cassandra-clientutil.jar 11/22/2012 11:13 AM 64,465 cassandra-jdbc.jar ... 11/22/2012 11:13 AM 445,188 ncluster.jar 11/22/2012 11:13 AM 2,714,189 ojdbc6.jar <- delete before paste 11/22/2012 11:13 AM 1,656,248 orai18n.jar <- delete before paste 11/22/2012 11:13 AM 346,944 paraccel-jdbc.jar 11/22/2012 11:13 AM 561,969 postgresql.jar 11/22/2012 11:13 AM 3,516,830 sqlite-jdbc.jar 11/22/2012 11:13 AM 286,773 util400.jar 11/22/2012 11:13 AM 262,740 xdb6.jar 11/22/2012 11:13 AM 839,982 xmlparserv2.jar 28 File(s) 29,365,764 bytes 2 Dir(s) 88,341,790,720 bytes free C:\Program Files\Aqua Data Studio 13.0 - 64bit\lib\drivers> |
C:\Program Files\Aqua Data Studio 13.0 - 64bit\lib\drivers>dir 11/23/2012 08:58 AM <DIR> . 11/23/2012 08:58 AM <DIR> .. 11/22/2012 11:13 AM 35,701 cassandra-clientutil.jar 11/22/2012 11:13 AM 64,465 cassandra-jdbc.jar ... 11/22/2012 11:13 AM 445,188 ncluster.jar 09/14/2000 03:21p 1,932,480 classes12.jar <- paste 06/28/2000 05:25p 12,097,171 nls_charset12.jar <- paste 11/22/2012 11:13 AM 346,944 paraccel-jdbc.jar 11/22/2012 11:13 AM 561,969 postgresql.jar 11/22/2012 11:13 AM 3,516,830 sqlite-jdbc.jar 11/22/2012 11:13 AM 286,773 util400.jar 11/22/2012 11:13 AM 262,740 xdb6.jar 11/22/2012 11:13 AM 839,982 xmlparserv2.jar 28 File(s) 28,761,869 bytes 2 Dir(s) 88,341,186,825 bytes free C:\Program Files\Aqua Data Studio 13.0 - 64bit\lib\drivers> |
Be sure to follow the above steps first to ensure that you have the proper drivers installed for ADS to make an OCI connection. In most situations, following the above steps will result in successful OCI connection.
Be aware that if more than one Oracle client has been installed on the same computer as Aqua Data Studio, you must make sure that only one Oracle Client appears in the windows path. Having multiple versions of the OCI DLLs in the path will prevent Aqua Data Studio from successfully connecting and will generate an error message similar to the following when attempting to make a connection:
About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017