Configure a System ODBC data source for the database that you want to connect to in Aqua Data Studio.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. Aqua Data Studio currently ships with Java 1.8, which no longer contains the JDBC-ODBC Bridge.Please bear in mind the following when using the JDBC-ODBC Bridge that's included in the Java distribution 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.
0 kommentar(er)
