John, When doing development, the most frequent task is "Script to New Window" => Create. I have used RapidSQL for years and getting the source code for the...
Hi, You are right. This syntax is correct, but complicates the functionality for ADS, because ADS needs to reconstruct the DDL. It will take to time to redo...
Hi Bill, There have been for requests to quickly script the DDL of objects. Also, there have been requests for default action of the double-click on the...
Hi John, I join to the request for default action of the double-click in Schema Browser. It is something that could really make use of ADS easier and more...
Hi, I've put out a new build with some features and fixes. ( http://download.aquafold.com/download/ads-6.0.20.jar ) Update instructions below. thanks -John ...
OK, I went an extreme route thinking there was a problem with the configuration, and since this was a new PC, reformatted and reinstalled...same problem. I...
I tried one additional thing, and for some reason it is working. If I choose the Non-OCI Connection, and enter the IP address instead of the Server Name...
Hi, ... of the Server Name (whether in tnsnames.ora or not), then it will connect. This connection type is not dependent on 32-bit or 64-bit. This should work...
Color me really, really clueless on this one: What is an "aqua script command?" I can't find "aqua script", "aquascript", or "script command" anywhere on the...
Hi, Currently we don't have many aqua commands. But, I ended up building an extendable mechanism so that it is easy for me to add commands as needed. The...
Hmmm. OK, so this is just for procs? It'd be darned handy outside of procs, too. This didn't work in a query analyzer pane: select count(*) from table ...
Hi, ... At first yes, but with the saveResults and saveLastResult, no longer. An aqua command is considered a separate statement, so you need to separate it...
Not sure what you are looking for, but here is the SQLNET.ora file: # SQLNET.ORA Network Configuration File: C:\oracle\OraHome10g_32\NETWORK\ADMIN\sqlnet.ora #...
Hi, Does does your "Ora81\ Network\ Admin\ Tnsnames.ora" look like? Can you send me a screenshot of your Enterprise Manager connection configuration? thanks ...
Hi John, I have a problem when I try to execute a script ending with comment on Sybase ASA. For example: create procedure a_test1 as begin return 0 end go ...
Hi, ADS will break up a script into statements. If you have an empty statement [just spaces] ADS will ignore it. If you have a statement with anything in it,...
The Ora81 directory no longer exists. Not sure what you are looking for as far as Enterprise Manager, enclosed is screen shot with Tree and configuration page...
The feature rocks. Thank you for exlaining. Needless to say, this will encourage further suggestions. The first -- and most important -- of which, for me, will...
Hi, I think Enterprise Manager also uses the pure Java driver to connect. So, this is equivalent to ADS "Oracle" connection which you can connect. So, the real...
Hi, ... parameters to a shell statement -- basically something I can use to call wscript.exe in Windows, or somesuch, and pass parameters. I have this on the...
Yes, TNSNAMES.ORA exists in path below, I had included the TNS entry for the one connection we were working (none are working), I can send more of the internal...
Hi Brock, Everything that you are doing looks right. For some reason, the OCI driver is returning this error. Can you do a few things to try to isolate where...
1. Returns C:\oracle\OraHome10g_32\BIN>tnsping OOCSVOSDB04 TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 05-APR-2 007 17:48:02 ...
Hi, If this problem is only with this computer, and it works on others then it should be much easier to isolate. Now that you mention this, there is something...
I think ADS is the best thing since bread, are far more necessary. I cannot imagine not having ADS in my toolkit. Yaaay ADS! Okay, now my question. I have a...
Hi, I installed ads-6.0.20 and I'm not able to compile a script to my package. I always have this error ... ORA-00900: invalid SQL statement the definition...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
