hi I need to connect to MySQL servers over SSH. Is this possible yet in ADS 20? thanks Mark Response Thomas Conrad over 3 years ago Hi Mark, That...
Is SSH tunnelling available yet in ADS 20?
read more
Aqua Data Studio Questions and Answers
Bigquery Support for numeric and partition
There are some useful features in bigquery like numeric and partition. Now numeric columns support in query result but not support in DDL(create...
How do I turn off Scientific Notation in the Grid and Text Results for Sybase ASE FLOAT data type?
How do we turn off scientific notation? I’m getting this in both text and grid results for Sybase ASE servers. create table myfloat (...
How to execute IBM DB2 UDB Admin commands that are part of CLP in Aqua Data Studio ?
How to execute IBM DB2 UDB Admin Functions in Aqua Data Studio ? IBM DB2 has server SQL commands, and commands that are part of their...
Using iAnywhere Driver, how to fix conversion errors using dates which used to work with the old driver ?
In Aqua Data Studio 14.0.0, I checked the option "Use iAnywhere Driver" for a Sybase IQ 15+ Server property to test the Bulk Import Feature. The...
Why isn’t there a Procedure Editor for Sybase ASE like there is for the other database vendors?
I can right mouse click on a procedure in Oracle, DB2 and SQL Server and choose the "Edit in Procedure Editor", but in Sybase ASE this option...
Can we export data from Oracle using UTL_FILE or the SPOOL command?
How can we do this? Response Niels Gron over 10 years ago You can accomplish this functionality in Aqua Data Studio with the same or similar...
DB2 iSeries SQL and System Naming
I have a question about using "system" naming with the iSeries driver. Usually this allows you to provided a list of schemas that may contain your...
Why does Table Data Editor ask me to disambiguate column names?
When I enter a query into ADS which contains a join and the tables have common column names, the database server will not execute the query if the...
Why does selecting a file in the filechooser on OSX not select the file extension with the full file name?
I run the Import Tool, and click browse to select a file to import. When I select one of my files, which has a .CSV extension, the full file name is...
I get the warning “Server returned invalid line number (0)” when debugging a Sybase procedure, am I doing something wrong?
I am not sure why I am getting the warning "Server returned invalid line number (0)" when debugging Sybase stored procedures. Response Niels Gron...
Why are certains operations of Aqua Data Studio very slow with MySQL?
I have a server registration to MySQL and other databases. When I execute queries in the Query Window for MySQL they are fast. But If I try to...
Why isn’t there a Procedure Editor for MySQL like there is for the other database vendors?
I can right mouse click on a procedure in Oracle, DB2 and SQL Server and choose the "Edit in Procedure Editor", but in MySQL this option doesn't...
Aqua Data Studio is crashing, not responding, or showing other signs of unstable behavior. What do I do?
Aqua Data Studio is crashing, not responding, or showing other signs of unstable behavior. Response Jonathan Powers over 11 years ago Unstable...
How can I backup Aqua Data Studio settings and server connections, or move them from one computer to another?
How can I backup Aqua Data Studio settings and server connections, or move them from one computer to another? Response Jonathan Powers over 11 years...
Scripts with multiple statements return errors. Some database commands or symbols do not work in Aqua Data Studio while they do work in the database vendor’s command line tool.
Scripts with multiple statements return errors. Some database commands or symbols (such as “;”) do not work in Aqua Data Studio while they do work...
Aqua Data Studio is running out of memory. How do I increase it?
Aqua Data Studio is running out of memory. How do I increase it? Response Jonathan Powers over 11 years ago Memory Allocation in Aqua Data Studio If...
Aqua Data Studio gets disconnected after a certain period of time.
Aqua Data Studio gets disconnected after a certain period of time. Response Tariq Rahiman over 11 years ago Timeouts: ADS periodically gets...
How do I connect to PostgreSQL using SSL and my personally created certificate
I want to connect to my PostgreSQL server using SSL. I've created a certificate on my PostgreSQL server, but I can't configure Aqua Data Studio to...
How do I connect to Teradata with LDAP?
How do I connect to Teradata with LDAP authentication using Aqua Data Studio? Response Niels Gron over 11 years ago The authentication mechanism for...