After several strong recommendations, I'm interested in using SQL Anywhere
as an embedded database in our workgroup-oriented product. I'm completely
new to SQL Anywhere; I started reading up on it a couple of hours ago. I
want to find out about:
1. What are the fundamental differences between SQL Anywhere and SQL
Anywhere Workgroup? Is it just the number of seats? What is the
difference between a network seat and a personal seat?
a. I understand there is now a SQL Anywhere JDBC ColdFusion MX driver.
Does it run with all versions of SQL Anywhere? How about CF MX Pro?
b. Does one JDBC connection into SQL Anywhere count for one seat/named
c. Does the evaluation copy of SQL Anywhere (Personal server) support
JDBC? Can I use it for testing with my CF MX Pro application?
3. Licensing arrangements/requirements, both in terms of seats per site, and
volume discounts for multiple sites. Or at least the person to talk to.
Subject: SQL Anywhere: Versions, Connectivity and Pricing
Date: Wed, 25 Sep 2002 15:37:25 -0700
X-Newsreader: Microsoft Outlook Express 5.50.4133.2400
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400
NNTP-Posting-Host: adsl-66-125-228-19.dsl.sntc01.pacbell.net 188.8.131.52
Xref: forums-1-dub ianywhere.public.general:590
Article PK: 2410
Subject: Re: SQL Anywhere: Versions, Connectivity and Pricing
Date: Thu, 26 Sep 2002 09:37:40 -0400
X-Newsreader: Microsoft Outlook Express 5.50.4522.1200
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200
NNTP-Posting-Host: CPE014310004450.cpe.net.cable.rogers.com 184.108.40.206
Xref: forums-1-dub ianywhere.public.general:584
Article PK: 2403
Are you looking at SQL Anywhere version 5.5.x or SQL Anywhere Studio 8.x?
- I just want to make sure that I'm giving the answers in the right
Assuming 8.x, here are the answers:
1) I'm not sure of the packaging details. A sales rep can help you get the
right package. As a guess I suspect that you are looking at a base package
(1 server, 1 client, standalone engine,...) vs a 10 user bundle. Again the
sales reps can help you out more.
A network seat is a client seat for a client-server configuration. A
personal seat is a standalone engine.
2) SQL Anywhere ships with jConnect which is our JDBC driver. I wasn't aware
that Cold Fusion had their own JDBC driver. We certainly support JDBC and
therefore java development tools.
Seats are counted in terms of distinct machines connected, not in terms
of # of connections. For example, 10 connections from a single client
machine still only count as a single "seat"
The Personal Server eval will support JDBC connections from the same
3) Your question would be best answered by a member of the iAnywhere
Solutions sales force For product or sales inquiries you can contact
iAnywhere Solutions by calling 1-800-801-2069 within North America.
Alternatively, you can contact us by email at firstname.lastname@example.org
Sybase Adaptive Server Anywhere Developer - Version 8
Sybase Certified Professional
Sybase's iAnywhere Solutions
Please respond ONLY to newsgroup
EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all
To Submit Bug Reports: http://casexpress.sybase.com/cx/cx.stm
SQL Anywhere Studio Supported Platforms and Support Status
Whitepapers, TechDocs, and bug fixes are all available through the iAnywhere
Developer Community at www.ianywhere.com/developer