Hi John, thanks for you quick answer. I agree the ODBC driver is the probable culprit, or rather the way it interacts with ADS. What possible interaction could...
Hi, ADS has one extra layer then MS Access does. ADS uses the JVM JDBC-ODBC Bridge to connect to the ODBC driver. If it is working with MS Access but not...
As far as I know the JDBC ODBC Driver has never been of production quality and Sun itself recommends not using it. ...
Sarel Botha
sarel.botha@...
Dec 1, 2004 7:06 pm
1649
Hi, I recommend the same thing as Sun ... "The JDBC-ODBC Bridge driver is recommended only for experimental use or when no other alternative is available." I...
Actually, it looks like there is a JDBC driver. I did a quick search and this came up: http://www.oracle.com/technology/products/rdb/htdocs/rdb_jdbc/index.html...
Sarel Botha
sarel.botha@...
Dec 1, 2004 8:17 pm
1651
John, Thanks for the quick reply! Your suggestion below worked great. David...
Hi Sarel, The URL did have a description page (http://www.oracle.com/technology/products/rdb/htdocs/rdb_jdbc/rdb_jdbc_more_info.html) and it states that it...
Hi, I am migrating to DB2 from another database and just started using Aquastudio. How can I call db2 stored procs that have out parameters in Aqua Studio QA. ...
Hi, You currently can not do this. This is one of the features I am currently working on. So that you will be able to define a variable, bind it and execute...
Hi, I'm evaluating ADS for my team and really like it so far. We use DB2 8.1 and the included Control Center toolset is terrible. However, there are a couple...
Hi Adam, ... You currently can't do this. I do have this on the feature list for a future version, but currently the key mappings are hard coded. ... ADS...
Theres seems to be a bug reg. sorting Grids by a short column. Order results are a bit confused ;-) And a feature request: It would be great to have the...
Hi Andreas, ... It looks like sorting was broken in build 3.7.18 (for all datatypes except strings). I have been on a quest to modularize the SortTable so I...
<apologies if i missed this in the docs ;> i'm trying to connect to an MS SQL Server 2000 database instance called "csgpq2\sixteenCharacter". however when i...
Hi Andreas, Here is a new build with the Sorting fixed if you need it before Monday ... http://www.aquafold.com/download/datastudio_3_7_18_5.jar -John...
Great ! Thanx for that. Regards Andreas ... Monday ... datatypes ... SortTable ... am ... when I ... classic "Last ... to ... Order ... classic "Last ... hard ...
In a recent move to decrease overall server load our databases were moved to a separate SQL server that only allows hostssl connections. Unfortunately it...
When will bind variables be supported? Allowing the user to execute a sql statement with binds, and then pop-up a window asking for the values. ? thanks, j...
You don't have to shutdown your local postgresql. Just change the local port you use in your SSH tunnel and also change the port ADS connects to. That way you...
Sarel Botha
sarel.botha@...
Dec 9, 2004 6:25 pm
1666
John, I keep getting this message 'Error: JZ0CU: getUpdateCount can only be called once after a successful call to getMoreResult, or execute methods.' This is...
Hi Jay, I am currently working on two features: Detailed Views for the schema browser, and Bind Variables. These are the two priority features for the next...
Hi Colin, I have seen this error occur on Sybase servers that do not have the latest EBF patches. A Sybase server comes with the JDBC meta data scripts under...
Hi Robert, Although the ADS UI currently doesn't support SSL for Postgres, with some manual configuration you should be able to configure it to do so. The only...
John, That's very unfortunate, mostly because its such an awesome tool otherwise. Just as a note, the "--" character is the SQL-92 standard single line comment...
Hi Adam, I do understand, but do keep in mind that ADS does support "--" comments. It is acutally configurable. The primary problem is that ADS and the DB2...
Hi; I just installed in my Windows 2003 MSDE 2000 Sp3a and AquaStudio and I can't connect with database. When I try set my connection, AquaStudio said...
hi, I'm evaluating Aqua Data Studio (v.3.7.6, OSX) for connecting to an Oracle 8i database. First I tested connecting via jdbc (I didn't know what SID to ...
list-aquastudio@...
Dec 10, 2004 5:49 pm
1674
Hi, ADS does support MSDE, but it only supports Windows Authentication through ODBC. If you are using SQL Authentication then you should be able to connect ...
Hi Johan, ... All Oracle installations require a unique SID, your DBA should be able to provide you with this. This SID is required whether you connect using...
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.
