Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

How do I use a third party SQL IDE with ASA?

2 posts in General Discussion Last posting was on 2005-09-28 17:05:25.0Z
Bret Hackford Posted on 2005-09-28 15:10:39.0Z
Sender: 5c11.433aae5f.1804289383@sybase.com
From: Bret Hackford
Newsgroups: ianywhere.public.general
Subject: How do I use a third party SQL IDE with ASA?
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <433ab26f.5c54.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 28 Sep 2005 08:10:39 -0700
X-Trace: forums-1-dub 1127920239 10.22.241.41 (28 Sep 2005 08:10:39 -0700)
X-Original-Trace: 28 Sep 2005 08:10:39 -0700, 10.22.241.41
Lines: 14
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4817
Article PK: 17431

New to the sybase universe. I'm looking to use a more
powerful SQL editor than what is included with the SQL
Anywhere installation (Interactive SQL).

I've tried downloading two separate programs and had the
same errors in both. They both complain that I don't have
the open client library installed.

What other options are available as far as executing SQL
statements against a ASA database? Is there one that is
preferred among developers? Or, how can I get what I've
downloaded to properly connect?

Thanks.


Breck Carter [TeamSybase] Posted on 2005-09-28 17:05:25.0Z
From: "Breck Carter [TeamSybase]" <NOSPAM__bcarter@risingroad.com>
Newsgroups: ianywhere.public.general
Subject: Re: How do I use a third party SQL IDE with ASA?
Organization: RisingRoad Professional Services
Reply-To: NOSPAM__bcarter@risingroad.com
Message-ID: <2vilj1hvsr1e44207m083lh4nt1nm9g31m@4ax.com>
References: <433ab26f.5c54.1681692777@sybase.com>
X-Newsreader: Forte Agent 2.0/32.640
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 12.24.172.2
X-Original-NNTP-Posting-Host: 12.24.172.2
Date: 28 Sep 2005 10:05:25 -0700
X-Trace: forums-1-dub 1127927125 12.24.172.2 (28 Sep 2005 10:05:25 -0700)
X-Original-Trace: 28 Sep 2005 10:05:25 -0700, 12.24.172.2
Lines: 36
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4818
Article PK: 8562

AFAIK there are no 3rd party tools that work with ASA and offer access
to all the facilities that ISQL and Sybase Central do.

For example, ISQL gives you the Index Consultant and the Graphical
Plan display. Have you tried Tools - Edit Query?

Note that ISQL lets you view multiple result sets in tabs.

Also, Sybase Central gives you access to the Execution Profiler and
the stored procedure/trigger debugger.

Breck

On 28 Sep 2005 08:10:39 -0700, Bret Hackford wrote:

>New to the sybase universe. I'm looking to use a more
>powerful SQL editor than what is included with the SQL
>Anywhere installation (Interactive SQL).
>
>I've tried downloading two separate programs and had the
>same errors in both. They both complain that I don't have
>the open client library installed.
>
>What other options are available as far as executing SQL
>statements against a ASA database? Is there one that is
>preferred among developers? Or, how can I get what I've
>downloaded to properly connect?
>
>Thanks.

--
SQL Anywhere Studio 9 Developer's Guide
Buy the book: http://www.amazon.com/exec/obidos/ASIN/1556225067/risingroad-20
bcarter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com