Hi, I have put out a new build with Visual Editing for Sequences, Synonyms/Aliases, Defaults, Rules and Data Types. I'll now be working on visual editing for...
Hi Davis, I can't beleive all this time I was under the impression that DB2 didn't support sequences, and that no one has pointed this out :) ADS doesn't even...
Hello, I can't connect to Oracle 8 or 9 from my client. I have the Oracle 91 client installed. I can successfully TNSPing and connect via other tools however I...
Hi, maybe you use not the port from the sqlnet.ora in your connection ? Mostly if you use sqlnet.ora, you take a second port for the ONAMES Server. But if you...
Hi Thomas, If I try to connect to Oracle, but use the incorrect port, then I get the error ... "Connection failed: IO Exception: The Network adaptor could not ...
Thanks for responding, I will try to provide the proper details. 1. I have Oracle Client 9i installed. 2. I CAN connect via SQL Navigator using the sqlnet.ora...
Hi Uwe, I just saw your post and I think you are correct on the ONAMES Server. Do you know I can check the second port? Thanks, Thomas ... Mostly ... which...
John and Uwe, Thanks, I'm in! If I had looked closely enough at the TNSPing results I would have seen the different port (ONAMES) there. Thanks again, Thomas ...
Hi, Although the cyrillic characters work on all stable versions of MySQL, I can't seem to get them to work on MySQL 4.1.1-Alpha. I tried a few combination of...
Is there a LOAD function in ADS? (using Mac OSx) We have an ODS with dozens of databases and I am authorized to create and update just mine, although I can...
Hi Kori, ... The LOAD command for MySQL is a client side command for the mysql command tool. The latest MySQL JDBC driver is supposed to support the LOAD...
Hi, I have added support for sequences on DB2, schema browser, scripting and visual editing. I also added the ability to create a new table withing the import...
... Hi John, I get the Choose Server Dialogue, and I am able to get the import dialogue for my MYSQL running on my computer and it works just fine (3...
... Works very well with Mysql. Couldn't get it to work with MS SQL 2000, perhaps for other reasons. I am going to try to obtain a schema that includes only...
Hi Kori, Thanks for pointing this out. It seems the permissions on the database were the problem. I did a quick fix. Can you try out this build and see if...
Hi, John! MySQL 4.0.18 works with cyrillics perfectly. Excuse, that I have taken away from you so much time. It was my mistake to use 4.1.1Alfa. Thanks for the...
John, I tried the sequence viewer on DB2. 2 suggestions : 1. the schema name doesn't look correct. 2. it doesn't show the next value. Thanks. Davis ... ...
Hi Davis, ... I am able to create sequences and different schemas, and the properties show the correct schema for each. Can you give me an example of how you...
I've been working with the XML query capability in Oracle 9.2 and find that ADS doesn't display results from these queries. I only get indicators like...
Hi Charley, I took a quick look at this and it seems that you new 2 xml libraries from Oracle. With a quick change and the 2 libraries ADS can now display the...
Hi, I'm getting messages like these in my output: Warnings: ---> W (1): Warning: execution completed with warning W (2): Warning: execution completed with...
Hi Michael, The warning itself usually occurs because there is a syntax error in the subquery. So, if you create a trigger or procedure that has a syntax ...
John, I had some difficulty with the datastudio.cfg file you sent. I think it may have been for a different OS because it keeps saying it can't find various...
Hi, On OSX it is a little different. Right-Click on your Aqua Data Studio icon and select "Show Package Contents". In the Contents folder copy this file (...
Hi, I am trying to connect to a sybase anywhere 7 database using aqua data studio and I have apparently connected to it, but there aren't any tables in the...
Hi Kim, I haven't tested Sybase Anywhere 7 specifically since it is an older version, but there are a few things you can try to isolate the problem. 1. Make...
Hi John, Thanks for responding. The Sybase is up to date with the latest EBF patches. I am using the Sybase Anywhere 8 and when I run query that you...