
The process for using the Easysoft JDBC-ODBC Bridge with Aqua Data Studio is as follows: Note that the Easysoft JDBC-ODBC Bridge only supports 32-bit ODBC drivers. It is fully supported by Easysoft and is currently being deployed in production environments throughout the world. The Easysoft JDBC-ODBC Bridge has a Java component and a 32-bit native component. For example, the NVARCHAR column value, Production.Product, is returned as (null), when the SQL Server AdventureWorks database is accessed by using the JDBC-ODBC Bridge.Īs an alternative, if you need to connect Aqua Data Studio to an ODBC driver, you can also use the Easysoft JDBC-ODBC Bridge instead. Instead of the expected value for a Unicode column, "(null)" is returned. There appears to be an issue with Unicode data retrieved via the JDBC-ODBC Bridge.The JDBC-ODBC Bridge is not recommended for production use.
You need to download a 1.7 version of the Java Runtime Environment (JRE) from AquaFold to use the JDBC-ODBC Bridge with Aqua Data Studio.
#To view stored procedure in aqua data studio driver#
For example, if you wanted to analyse data in Aqua Data Studio, you could connect to in the following way:Īqua Data Studio > JDBC-ODBC Bridge > ODBC Driver > For example, Aqua Data Studio can work with data stored in Amazon Redshift and ships with a dedicated connector for this data store.Īqua Data Studio can also use the JDBC-ODBC Bridge that's included in the Java distribution as a generic connector for data stores for which there is an ODBC driver. Aqua Data Studio can analyse data stored in a number of back ends and includes a number of dedicated connectors for this purpose.
