A year or so ago, I installed an evaluation product from another company that does this based on a customer support request.
Using our Generic JDBC connection and the proper url formation it worked well for what I was testing.
Feel free to contact me independently about what product I used to do this.
@QA,
Please test 32 and 64 bit versions of the ADS installers.
@QA,
Please test 32 and 64 bit versions of the ADS installers.
Oracle removed the JDBC odbc bridge in Java 1.8. This bridge is used to make generic odbc conn. From a QA perspective, we want to ensure that the the generic odbc functionality still works under windows. We need to test under:
- windows 32-bit using 32-bit ADS.
- windows 64-bit using 64-bit ADS.
- windows 64-bit using 32-bit ADS.
How to create a generic odbc connection: https://www.aquaclusters.com/app/home/project/public/aquadatastudio/wikibook/Documentation16/page/111/Generic-ODBC
How to create a generic odbc connection to MS Access DB: https://www.aquaclusters.com/app/home/project/public/aquadatastudio/wikibook/Documentation16/page/230/Microsoft-Access-Generic-ODBC
How to create a generic odbc connection to Excel DB: https://www.aquaclusters.com/app/home/project/public/aquadatastudio/wikibook/Documentation16/page/Microsoft-Excel-Generic-ODBC/Microsoft-Excel-Generic-ODBC
Pls verify that you can create a generic odbc connection to MS Access & MS Excel as described above.
Oracle removed the JDBC odbc bridge in Java 1.8. This bridge is used to make generic odbc conn. From a QA perspective, we want to ensure that the the generic odbc functionality still works under windows. We need to test under:
- windows 32-bit using 32-bit ADS.
- windows 64-bit using 64-bit ADS.
- windows 64-bit using 32-bit ADS.
How to create a generic odbc connection: https://www.aquaclusters.com/app/home/project/public/aquadatastudio/wikibook/Documentation16/page/111/Generic-ODBC
How to create a generic odbc connection to MS Access DB: https://www.aquaclusters.com/app/home/project/public/aquadatastudio/wikibook/Documentation16/page/230/Microsoft-Access-Generic-ODBC
How to create a generic odbc connection to Excel DB: https://www.aquaclusters.com/app/home/project/public/aquadatastudio/wikibook/Documentation16/page/Microsoft-Excel-Generic-ODBC/Microsoft-Excel-Generic-ODBC
Pls verify that you can create a generic odbc connection to MS Access & MS Excel as described above.
Verified in ADS 17.0.0-dev-22
Verified on the following builds and operating system :
- windows 64-bit using 64-bit ADS.
- windows 64-bit using 32-bit ADS.
Not able to test and verify on windows 32-bit using 32-bit ADS as we do not have 32-bit operating systems.
Verified in ADS 17.0.0-dev-22
Verified on the following builds and operating system :
- windows 64-bit using 64-bit ADS.
- windows 64-bit using 32-bit ADS.
Not able to test and verify on windows 32-bit using 32-bit ADS as we do not have 32-bit operating systems.
Issue #13141 |
Closed |
Fixed |
Resolved |
Completion |
No due date |
Fixed Build ADS 17.0.0-dev-18 |
No time estimate |
4 issue links |
relates to #14210
Issue #14210JDBC-ODBC is not working with java 1.8 |
relates to #13279
Issue #13279Extend JDBC - ODBC Bridge Approach to other ODBC connections |
depends upon #13110
Issue #13110JDBC - ODBC Bridge |
relates to #13266
Issue #13266JDBC - ODBC Bridge documentation for v17 |
A year or so ago, I installed an evaluation product from another company that does this based on a customer support request.
Using our Generic JDBC connection and the proper url formation it worked well for what I was testing.
Feel free to contact me independently about what product I used to do this.