I have a feeling this is due to the non-ANSI feature of MySQL to use the backslash as an escape character for single quotes in strings. Consider the following...
Hi, I put out a new build with some minor fixes. Update instructions below ... ( http://www.aquafold.com/download/datastudio_3_7_9.jar ) -John 3.7.9 CHANGES ...
Hi, I checked all the databases and found that MySQL and Postgresql are the only 2 which require the backslash to be escaped. I have fixed this on both MySQL...
When I try to add a v7 database, as soon as I hit OK, Acqua Studio just freezes. I have tried several servers and several databases with the same result. When...
Hi, With DB2 it is recommended that you update your JDBC drivers to the version & fixpack of the server you have installed. The drivers comes with your DB2...
I can not edit any tables on sybase with data studio. I get the message : "table editor requires transaction support.failed to disable auto-commit.transactions...
Hi Sandy, The only time I have found Sybase to give an error stating that transactions are not supported is when the JDBC meta data has not been installed with...
I actually had done that right before I came and posted. That solution, unfortunately, was no solution in my case. Any other ideas? ... the ... comes ... ...
Hi, DB2 7.2 ... Can you tell me what is your server configuration and what setttings you are using to try to connect? I have had ADS/DB2 JDBC drivers hang on...
John, I thought I'd let you know about a issue I came across in ADS. SQL Server has a COMPUTE clause that can be used in a SELECT statement. This clause does...
John, DB2 7.2 ... Not sure what you mean with the proxy server, but, from you words, I am obviously doing something wrong, as I am indeed trying to connect ...
Hi Greg, I will put this on the list to look into in the future, but the problem right now is that the COMPUTE clause on Sybase and SQL Server are not ...
Hello, I've applied the latest java patch from apple, and the good news is all still runs, seemingly better. ... However, there have been some basic look and...
greg stasko
greg.stasko@...
Aug 12, 2004 10:41 pm
1314
After updating Java, I'm seeing this in the console when starting ADS. Never noticed it before. Still seems to work fine although the background is a darker...
Hi everyone, I'm on DB/2 8.1 (FP5) and am having a bit of trouble setting a default schema in ADS for my queries. Not seeing an option like this in the GUI, I...
Hi Greg, The screenshot on the AquaFold website is of ADS running on OSX 10.2. When I upgraded my OSX machine to 10.3 the Look and Feel changed for all of my...
Actually, I've been on 10.3.4 for awhile, and 10.3.5 as soon as it became available. That was the same time I upgraded to the latest java implementation. So I...
greg stasko
greg.stasko@...
Aug 13, 2004 2:52 am
1318
Hi Ray, DB2 7.2 -> All JDBC drivers connect directly to the server except the DB2 7.2 drivers. In your DB2 Server installation there is an application you can...
Hi David, The bottom of the error has "com.apple.macos.useScreenMenuBar has been deprecated. Please switch to apple.laf.useScreenMenuBar" If you run ADS as a...
Hi Jason, The only way to set the current schema right now is to execute the query "SET SCHEMA <SCHEMA_NAME>" in the query window. This will only set the ...
Hi John; I am double-clicking, not running from command line. The messages appear in the console log. Not a problem, just thought you would like to know. Dave...
Hi Greg, I upgraded to 10.3 only a month ago and 10.3.2 is what was installed ... then I updated to Java 1.4.2_04. So, I am not sure when Apple made the ...
John; I just edited Info.plist and changed "com.apple.macos.useScreenMenuBar" to "apple.laf.useScreenMenuBar". That eliminated the deprecated message. Still...
Hi David, ... I missed this one. This must have been a change on 10.3. I'll make that change. After the change I ran ADS with Java 1.4.2_04 and then upgraded...
John, I'm trying to connect to our new db2 server on AIX, using ADS 3.7.8 To register the database I enter the IP and the port 6789 I don't have a database...
Hi Kori, I am assuming you are using DB2 7.2 (since you are trying port 6789). Did you update your JDBC driver of ADS to the same fixpack as your server? (as...
Hi All, yes I am brand new to this list, and a brand new user to Aqua Studio. I recently installed Aqua Studion on both my Dell Laptop and Apple Powerbook. I...
John, That info was at the bottom of my first message. Sorry I should have pointed it out. Here it is again: Mac OS X 10.3.5 java version "1.4.2_05" Java(TM) 2...
Hi, This sounds a little weird. The error you are getting usually occurs when the server or the port is not available. But if you can connect from your Dell...