Greetings, I have started using the Aqua commands .saveResults and .sendMail to automate tasks. One issue that I have discovered is that when a task is ...
Hi, ... my email application is opened and an email is created but never sent. Can you clarify and/or send a screenshot? ADS sends mail directly, so no other...
John, I have created a script which does a simple query, saves it to a file and sends the file to me. This works great in ADS and from the command line. It...
ADS 6.5.7 please add, in print Options->Section Select "chart" currently in order to print the chart from pivot table you have to have the chart maximized...
Hi, Printing of the charts in the grid or pivot grid are currently not supported. I am not sure how you printed the chart but this is not possible. In 7.0 we...
There is a UI bug in the storage manager. I didn't find any other way of submitting bug reports so please let me know if I should submit somewhere else. If you...
Hi, This works well for me. Can you provide me ... What version/build of ADS you are using? What OS/version you are using? What Java version you are running...
Hi John, Recently the hard drive on my home machine crashed. I was able to save my .datastudio directory however I chose to use my work computer account to...
Hi, ... (home and work) You can use the ADS file Compare to compare the two datastudio.properties files. But both files have the same properties with the same...
Hi, I am new to this group. I edited a very simple stored procedures create or REPLACE PROCEDURE "DatbaseA"."web_Tracking" is ID Tracking.ID%Type; D...
Hi, What syntax did you use to execute the procedure? Did you wrap it with a anonymous PLSQL block? If you find the procedure in the schema browser you can...
Thank you for response, John Yes, I can see my stored procedure in schema browser. I right clicked it and opened the SP in 'Prcocedure Editor' and hit the ...
Hi, Ah, I see ... you created your procedure with quotes ... which means Oracle uses case-sensitivity. Then you execute with out quotes so Oracle assumes all...
A while ago I was complaining about the connection problems that I get whenever the connection between ADS and SqlServer is dropped for some reason. ... It...
Hi, Try this ... in the Server Properties under the Advanced Tab on the "Driver Param:" ... add "socketTimeout=15" without quotes. See if that helps. -John...
... Yes it helps. If the connection has been dropped, I get this after ... Invalid state, the Statement object is closed. ... I/O Error: Read timed out But on...
Hi, The problem you are having is because of your network. You can try to find workarounds with ADS, but in the end the most appropriate solution would be to...
I too have similar problems and the annoying thing here is for awhile they had 'fixed' it. Now it is back again with a vengeance. I'll keep trying to get...
... You are absolutely correct. And I appreciate your effort very much. I actually got a response to my query and the recommendation from the network people...
As long as we are this seriously off topic: eWallet at http://www.iliumsoft.com/ Windows version and it sync with a Palm or Windows PDA so you can securely...
I use ADS to connect to an Informix Database and run queries. I know by defauly ADS does not accept date value in the following format (01/01/2007). Is there a...
Hi John, In ADS, I went to Server Properties --> Advanced. Under the advanced tab, there are two options. 1. Txn Isolation Level 2. Driver Parm. regards V ... ...
John, Wow. Is it possible to set up a default format for dates for oracle, in ADS? I get sick of having to use DD-Mon-YYYY ... or issuing an alter session...
Hi, Sadly enough, Oracle does not provide an option to set this value. ALTER SESSION is the only way. Or you can change the Oracle server default format if...
Tried entering the value in the Driver Param option. I get the following error after clicking on OK. Connection failed: [Microsoft][ODBC Driver Manager] Data...
Hi, The option I send was for the JDBC driver which is for the "Informix" connection type. You must be using the "Informix - ODBC" connection type. In this...
John, We have some Sybase databases that have named segments so that we can put heavily hit objects on their own devices. Storage Manager only shows data,...