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
824
|
Aqua Data Studio comes bundled with Oracle 12c JDBC drivers. These drivers are compatible with Oracle 12c, 11g and 10g when using the Oracle (non-OCI) connection in Aqua Data Studio. To make an OCI connection or to connect to Oracle 9i or 8i, please follow the appropriate instructions below.
Aqua Data Studio is bundled with the Oracle 12c JDBC drivers. Oracle has discontinued support for Oracle 8i and 9i in their Oracle 12c drivers. Aqua Data studio still supports Oracle 8i and 9i, but you need to backdrop the Oracle drivers from 12c 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 and 9i | |
Before Deleting the Oracle 12c drivers | After Deleting the Oracle 12c drivers and pasting the Oracle 10g JDBC drivers |
Help > About > JDBC Drivers tab indicating 10g Drivers |
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 12c Release 2 Client JDBC Drivers | |
C:\ora\app\admin\product\12.2.0\dbhome\jdbc\lib>dir
02/23/2017 05:19 PM <DIR> .
02/23/2017 05:19 PM <DIR> ..
02/23/2017 10:09 PM 1,996,390 ojdbc5.jar
02/23/2017 10:09 PM 2,429,986 ojdbc5dms.jar
02/23/2017 10:09 PM 3,102,538 ojdbc5dms_g.jar
02/23/2017 10:09 PM 3,081,969 ojdbc5_g.jar
??/??/???? ??:?? ?? ?,???,??? ojdbc8.jar <- copy this
02/23/2017 10:09 PM 2,656,012 ojdbc6dms.jar
02/23/2017 10:09 PM 3,423,966 ojdbc6dms_g.jar
02/23/2017 10:09 PM 3,402,257 ojdbc6_g.jar
02/23/2017 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\12.2.0\dbhome\jdbc\lib>
|
C:\ora\app\admin\product\12.2.0\dbhome\jlib>dir
01/02/2017 05:54 PM <DIR> .
01/02/2017 05:54 PM <DIR> ..
12/28/2016 08:08 AM 55,434 ocrs12.jar
01/02/2017 07:25 PM 2,313,802 ojdbc5dms.jar
01/02/2017 07:25 PM 1,062,368 orai18n-collation.jar
01/02/2017 07:25 PM 11,057 orai18n-internal.jar
01/02/2017 07:25 PM 1,469,241 orai18n-lcsd.jar
01/02/2017 07:25 PM 82,953 orai18n-mapping.jar
01/02/2017 07:25 PM 9,799 orai18n-net-ee.jar
01/02/2017 07:25 PM 45,528 orai18n-net.jar
01/02/2017 07:25 PM 85,878 orai18n-servlet.jar
01/02/2017 07:25 PM 86,409 orai18n-tools.jar
01/02/2017 07:25 PM 1,403,740 orai18n-translation.jar
01/02/2017 07:25 PM 405,501 orai18n-utility.jar
??/??/???? ??:?? ?? ?,???,??? 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\12.2.0\dbhome\jlib>
|
What to modify in [ADS_HOME]/lib/drivers folder | |
C:\Program Files\Aqua Data Studio 18.0 - 64bit\lib\drivers>dir 02/18/2017 08:58 AM <DIR> . 02/18/2017 08:58 AM <DIR> .. 02/18/2017 11:13 AM 35,701 cassandra-clientutil.jar 02/18/2017 11:13 AM 64,465 cassandra-jdbc.jar ... 02/18/2017 11:13 AM 445,188 ncluster.jar 02/18/2017 11:13 AM 3,698,857 ojdbc7.jar <- delete before paste 02/18/2017 11:13 AM 1,659,574 orai18n.jar <- delete before paste 02/18/2017 11:13 AM 346,944 paraccel-jdbc.jar 02/18/2017 11:13 AM 561,969 postgresql.jar 02/18/2017 11:13 AM 3,516,830 sqlite-jdbc.jar 02/18/2017 11:13 AM 286,773 util400.jar 02/18/2017 11:13 AM 262,740 xdb6.jar 02/18/2017 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 18.0 - 64bit\lib\drivers> |
C:\Program Files\Aqua Data Studio 18.0 - 64bit\lib\drivers>dir 02/18/2017 08:58 AM <DIR> . 02/18/2017 08:58 AM <DIR> .. 02/18/2017 11:13 AM 35,701 cassandra-clientutil.jar 02/18/2017 11:13 AM 64,465 cassandra-jdbc.jar ... 02/18/2017 11:13 AM 445,188 ncluster.jar ??/??/???? ??:?? ?? ?,???,??? ojdbc8.jar <- paste ??/??/???? ??:?? ?? ?,???,??? orai18n.jar <- paste 02/18/2017 11:13 AM 346,944 paraccel-jdbc.jar 02/18/2017 11:13 AM 561,969 postgresql.jar 02/18/2017 11:13 AM 3,516,830 sqlite-jdbc.jar 02/18/2017 11:13 AM 286,773 util400.jar 02/18/2017 11:13 AM 262,740 xdb6.jar 02/18/2017 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 18.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 12c Release 1 Client JDBC Drivers | |
C:\ora\app\admin\product\12.1.0\dbhome\jdbc\lib>dir
02/23/2016 05:19 PM <DIR> .
02/23/2016 05:19 PM <DIR> ..
02/23/2016 10:09 PM 1,996,390 ojdbc5.jar
02/23/2016 10:09 PM 2,429,986 ojdbc5dms.jar
02/23/2016 10:09 PM 3,102,538 ojdbc5dms_g.jar
02/23/2016 10:09 PM 3,081,969 ojdbc5_g.jar
??/??/???? ??:?? PM ?,???,??? ojdbc7.jar <- copy this
02/23/2016 10:09 PM 2,656,012 ojdbc6dms.jar
02/23/2016 10:09 PM 3,423,966 ojdbc6dms_g.jar
02/23/2016 10:09 PM 3,402,257 ojdbc6_g.jar
02/23/2016 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\12.1.0\dbhome\jdbc\lib>
|
C:\ora\app\admin\product\12.1.0\dbhome\jlib>dir 01/16/2016 05:54 PM <DIR> . 01/16/2016 05:54 PM <DIR> .. 01/16/2016 08:08 AM 55,434 ocrs12.jar 01/16/2016 07:25 PM 2,313,802 ojdbc5dms.jar 01/16/2016 07:25 PM 1,062,368 orai18n-collation.jar 01/16/2016 07:25 PM 11,057 orai18n-internal.jar 01/16/2016 07:25 PM 1,469,241 orai18n-lcsd.jar 01/16/2016 07:25 PM 82,953 orai18n-mapping.jar 01/16/2016 07:25 PM 9,799 orai18n-net-ee.jar 01/16/2016 07:25 PM 45,528 orai18n-net.jar 01/16/2016 07:25 PM 85,878 orai18n-servlet.jar 01/16/2016 07:25 PM 86,409 orai18n-tools.jar 01/16/2016 07:25 PM 1,403,740 orai18n-translation.jar 01/16/2016 07:25 PM 405,501 orai18n-utility.jar ??/??/???? ??:?? ?? ?,???,??? 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\12.1.0\dbhome\jlib> |
What to modify in [ADS_HOME]/lib/drivers folder | |
C:\Program Files\Aqua Data Studio 18.0 - 64bit\lib\drivers>dir 02/18/2017 08:58 AM <DIR> . 02/18/2017 08:58 AM <DIR> .. 02/18/2017 11:13 AM 35,701 cassandra-clientutil.jar 02/18/2017 11:13 AM 64,465 cassandra-jdbc.jar ... 02/18/2017 11:13 AM 445,188 ncluster.jar 02/18/2017 11:13 AM 3,698,857 ojdbc7.jar <- delete before paste 02/18/2017 11:13 AM 1,659,574 orai18n.jar <- delete before paste 02/18/2017 11:13 AM 346,944 paraccel-jdbc.jar 02/18/2017 11:13 AM 561,969 postgresql.jar 02/18/2017 11:13 AM 3,516,830 sqlite-jdbc.jar 02/18/2017 11:13 AM 286,773 util400.jar 02/18/2017 11:13 AM 262,740 xdb6.jar 02/18/2017 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 18.0 - 64bit\lib\drivers> |
C:\Program Files\Aqua Data Studio 18.0 - 64bit\lib\drivers>dir 02/18/2017 08:58 AM <DIR> . 02/18/2017 08:58 AM <DIR> .. 02/18/2017 11:13 AM 35,701 cassandra-clientutil.jar 02/18/2017 11:13 AM 64,465 cassandra-jdbc.jar ... 02/18/2017 11:13 AM 445,188 ncluster.jar ??/??/???? ??:?? ?? ?,???,??? ojdbc7.jar <- paste ??/??/???? ??:?? ?? ?,???,??? orai18n.jar <- paste 02/18/2017 11:13 AM 346,944 paraccel-jdbc.jar 02/18/2017 11:13 AM 561,969 postgresql.jar 02/18/2017 11:13 AM 3,516,830 sqlite-jdbc.jar 02/18/2017 11:13 AM 286,773 util400.jar 02/18/2017 11:13 AM 262,740 xdb6.jar 02/18/2017 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 18.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 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 18.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 3,698,857 ojdbc7.jar <- delete before paste 11/22/2012 11:13 AM 1,659,574 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 18.0 - 64bit\lib\drivers> |
C:\Program Files\Aqua Data Studio 18.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 18.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 18.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 3,698,857 ojdbc7.jar <- delete before paste 11/22/2012 11:13 AM 1,659,574 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 18.0 - 64bit\lib\drivers> |
C:\Program Files\Aqua Data Studio 18.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 18.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 18.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 3,698,857 ojdbc7.jar <- delete before paste 11/22/2012 11:13 AM 1,659,574 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 18.0 - 64bit\lib\drivers> |
C:\Program Files\Aqua Data Studio 18.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 18.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 18.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 3,698,857 ojdbc7.jar <- delete before paste 11/22/2012 11:13 AM 1,659,574 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 18.0 - 64bit\lib\drivers> |
C:\Program Files\Aqua Data Studio 18.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 18.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