Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.


I've put this question inside another post, but it might be overseen in the different context of this post.

So here my direct question, whether there is an official redistributable package for this .NET component


asked 17 Nov '11, 05:15

OLeary's gravatar image

accept rate: 0%

edited 17 Nov '11, 11:25

Volker%20Barth's gravatar image

Volker Barth

I would ask you sales rep...

(17 Nov '11, 05:20) Volker Barth

We do not have "redistributable packages" à la Microsoft. If you look at the license agreement of the SQL Anywhere Client (appears when you install), you'll see the following text:

"If You, Your company, or Your public agency have signed a written software license agreement with Sybase, Inc. or Sybase Canada Limited ("Sybase") or a Sybase subsidiary or authorized reseller, covering the Use of the enclosed Program, the terms of the signed license agreement shall take precedence over any conflicting terms of this Agreement."

This means that your existing SQL Anywhere license applies here as well, which you should have because you cannot obtain the database server without a license. The terms of that license would then apply, which spell out what components you can redistribute, the number of seats that can access the server, etc.

permanent link

answered 17 Nov '11, 11:13

Jos%C3%A9%20Ramos's gravatar image

José Ramos
accept rate: 30%

edited 17 Nov '11, 11:24

Volker%20Barth's gravatar image

Volker Barth


my goal is, to develop an application which connects to a sql anywhere database and read data out of it. For me as developer its no problem to install the complete SQL Anywhere database client. I have already done this, and with this installation the component I'm asking for was also installed. I found it in the GAC. But for a customer, who get's my application, it should not be necessary to install the complete databaseclient with all stuff including Sybase Central he never will use. If my application use the iAnywhere.Data.AsaClient.dll I have to deliver it with the setup of my application to customers machine, and nothing more.

So what is the recommended way to install an application, which uses iAnywhere.Data.AsaClient.dll, and therefore have to put this dll in its setup ? Can I simply take the dll from my machine from the GAC and pack it to my setup ???

permanent link

answered 28 Nov '11, 04:10

OLeary's gravatar image

accept rate: 0%

I can't answer you question myself for .NET - but have you had a look at the 12.0.1 docs?

Deploying .NET clients

In general, I guess it's common to use the builtin Deployment Wizard tool to build a fitting MSI package for your setup, or to integrate the required files and setup steps into your own custom setup.

How are you going to setup the database server at your customer's sites?

(28 Nov '11, 04:28) Volker Barth

the hint to version 12.0 is not helpful for me. I have to deal with a database of version 5, and version 12 and all its components (ODBC drivers including) refuse to open such a database.

I was only successful to open and query the table content with a sample, delivered with version 9 wich I adapted slightly. Its the TableViewer sample in folder ASAAdo.NET

Unfortunately this sample is only installed on a x86 platform. When trying to install version SA9_Full_WIN_X64.902_EBF_3951 on Win7 64bit, no samples are installed and also no .NET component. When trying to copy the running sample from WinXP(x86) to Win7(x64) there is a load error of the dll dbdata9.dll. This dll is also not part of the x64 installation. The x64 version seems to be not fully functional. Do you see any chance to get the necessary components for a x64 platform ?

For my client I do not need to setup the database server. He has already a running system. I only need to connect to his database and read out data for datamigration into another software system.

(28 Nov '11, 11:23) OLeary
Replies hidden

>> When trying to copy the running sample from WinXP(x86) to Win7(x64) there is a load error of the dll dbdata9.dll

Yes, version 9 only supported 32-bit ADO.NET applications. (See: )

The .NET Common Language Runtime (CLR) can run as a 64-bit environment or as a 32-bit environment on a 64-bit OS.

You must compile your .NET application with the /PLATFORM switch set to 'x86' in order to access the version 9 .NET provider on an x64 system. (And force the CLR to always run in 32-bit mode).

Alternatively, set up your .NET project in Visual Studio to target the 'x86' output platform, via "Build" -> "Configuration Manager...")

(28 Nov '11, 13:08) Jeff Albion

I wasn't aware that you are using SQL Anywhere 9 and a v5 database.

IMHO, if you're looking for a version-specific answer, it's helpful to specify that version. That will allow us to give more appropriate answers:)

(29 Nov '11, 01:57) Volker Barth

I think you're looking for this:

The "SQL Anywhere Database Client Download". It includes the .NET providers.

permanent link

answered 17 Nov '11, 09:53

Dan%20Cummins's gravatar image

Dan Cummins
accept rate: 41%


Is that an "official redistributable package"?

I guess that would require a link to the according licence agreements ... but that's just me, not sales:)

(17 Nov '11, 10:44) Volker Barth
Replies hidden

The URL provided ( is 135 MB in size so I guess it is a bit more than just iAnywhere.Data.AsaClient.dll ;-)

(21 Jan '13, 09:31) hfrmobile
Replies hidden

so I guess it is a bit more than ...

Sure it is - therefore Dan has stated that it "includes" the .Net providers. It also contains all client libraries and the whole set of administration tools, AFAIK.

FWIW, the contents of that client setup (and the pros and cons vs. a customized client package) are discussed here...

(21 Jan '13, 09:59) Volker Barth

Just a quick note that this link to the client downloads is an "official redistributable package", but is subject to your existing SQL Anywhere license restrictions. If you do not have a current SQL Anywhere license, you may use the software in a 60-day evaluation mode and obtain an automatic software evaluation license, as per the notes with the download here:

Note: During installation you will be prompted to review and accept the SQL Anywhere software license agreement. If you do not accept the License Agreement you can either end the product installation or download a 60-day evaluation edition (subject to a software evaluation license).

(21 Jan '13, 11:42) Jeff Albion

Here the company were talking about this same topic. How to connect a client workstation without having to install any Sybase, using only a dll to make the connection. (use ASA with BDE / ODBC driver, SO Win), what is the solution for this?

permanent link

answered 21 Jan '13, 12:07

Walmir%20Taques's gravatar image

Walmir Taques
accept rate: 12%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:


question asked: 17 Nov '11, 05:15

question was seen: 7,998 times

last updated: 21 Jan '13, 12:07