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,...
Hi Brad, The Detail View of the schema browser for Sybase Tables shows you the segment the tables are on. The Storage Manager Segment Usage provides a list of...
Hi John I think this is possibly related to oracle RAC, but i have a session i am running and it appears in gv$session_longops, but not in the session long ops...
Hi John It also looks like the oracle session manager in ADS doesn't account for RAC sessions. On a RAC, when you run v$ views they only look at the current...
Hi Steven, I am trying to think this through to find the best solution. ADS currently doesn't use the GV$ views. The GV$ views are Global Views for RAC. I...
John Being able to switch between them would probably be the way to go, maybe as a configuration item. It is important to be able use the gv$ views in some...
The auto-complete (ctrl-space) feature doesn't work as in previous patches. I just installed version 6.5.7_13 but I am still having the same problem: Eg:(being...
Hi Steven, I've added this request into our pipeline. We might be able to get this in 7.0. The impact is higher then just a change to use GV$ tables. Here is...
Hi I usually only have one copy of ADS running on my computer, but sometimes ads freezes (in this particular case i was compiling some plsql). I opened up a...
... Yes, but the behaviour is still different compared to previous versions. Ctrl-space was used to force autocompletion even if "go" wasn't there. In...
Hi, This is not a bug. This is a restriction. There is a feature that is a work around. Under the File menu there is an action called "New Frame Window"...
John, I've encountered this in the past as well and I was forced to end task on ADS in Task Manager. The problem I had was when a query hung, I would get a...
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.
