... Just a random thought - the "ERROR 1005 (HY000)" part isn't what's returned by SQLException.getSQLState(), is it? I'm assuming SQLException.getErrorCode()...
Andrew Stevens
ats37@...
Jan 1, 2007 9:44 pm
4470
Happy New Year, I've put out a new build which some fixes listed below. Update instructions below ... ( http://download.aquafold.com/download/ads-6.0.7.jar ) ...
Hi, ... No, that is why it is not being displayed. ... I can't reproduce the error message, but .getErrorCode() returns an int, so I would assume that it would...
Hi, I've put out a new build which some fixes & features listed below. Update instructions below ... ( http://download.aquafold.com/download/ads-6.0.8.jar ) ...
I'm using Aqua 6.0.8 against SQL Server 2000. When I try to expand "Databases" in the navigation screen I get the error: Failed to rebuild node contents:...
SQL Server 2005 Enterprise. Reproduced with ADS 4.7 and 6.0.8. Using JDBC connectivity on OS X 10.4.8. Java(TM) 2 Runtime Environment, Standard Edition...
Hello, Been using ADS for a long time and use it especially on my laptop. In this environment, I often lose my network connection. (You might remember that in...
Hi Bradley, The error you are getting is on the server side, so I am assuming this is a problem that would be fixed if you have all the service packs. What is...
Hi, ... Can you explain your environment? If your connection is being closed by the server then you shouldn't have a problem. If your physical or logical...
Hi Ian, I am unable to reproduce this bug. 1. What Service Pack do you have? 2. Can you give me an example procedure that reproduces this problem? -John...
Sounds like you may have auto-commit disabled for Query Analyzer for SQL Server. Your create proc is not being committed and holding an excluisive lock on the...
Hi, Microsoft SQL Server 2005 - 9.00.2047.00 (X64) Apr 14 2006 01:11:53 Copyright (c) 1988-2005 Microsoft Corporation Developer Edition (64-bit) on Windows NT...
Hi John, Our organization just purchased licenses and we are starting to distribute and use the application. I put ADS on a Windows 2000 Terminal Server as...
Looks like that's it. Auto Commit was off. Turning it on works around the hang. I'm used to Oracle where creating a proc is a DDL statement that commits...
Hi, Trying to use the script generator for Sybase to extact the scripts for Tables, Views, and procedures. When I check the Sort by Dependencies option, it...
Hi, Licenses are per user. You would need to have a license configured per user. Each license is stored under the user profile under <USER_HOME>\.datastudio....
SQL Server's default behavior is auto-commit any DDL or DML statements. If you turn it off, DDL statemetns are allowed in transactions and you have to issue...
Hi Ray, We need to isolate the issue a little more Can you individually do the following ... 1. Script Tables with Sort 2. Script Views with Sort 3. Script...
Hi, Oracle don't support DDL in transactions, so if a DDL is executed in a transaction, the transaction is committed. SQL Server does support DDL in...
John, Here's the resutls of the test: 1. Script Tables with Sort - Works Fine 2. Script Views with Sort - generates error 3. Script Procedures with Sort -...
Hi John, The physical and/or logical connection is being lost. I think there are a number of cases: - Firewall see no activity and closes the connection -...
Ian and John, I'm using a Powerbook with ADS 6.0.6.RC1 with JTDS 1.2 and: Microsoft SQL Server 2005 - 9.00.2047.00 (Intel X86) Apr 14 2006 01:12:25 Copyright...
Hi, I've put out a new build which some fixes & features listed below. Update instructions below ... ( http://download.aquafold.com/download/ads-6.0.9.jar ) ...
I just discovered that with Auto Commit off I can also repeatably reproduce it on: Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38 ...
Sheesh, teach me to play closer attention to these threads before jumping in... autocommit indeed - autocommit is eevul, transactions in general are tricky...
Ian, I'll check when I get home, that's where my Mac's set up, but I am pretty sure it is off (that's what I tend to set everything to in configuration). ...
Hi John, Well, when I login and use Aqua Data it doesn¹t prompt me for licensing info. When a different user logs in, it doesn¹t store the info for...