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

I am attempting to deploy a powerbuilder/sybase anywhere application.
Following the documentation, I am using the deployment wizard. I successfully created the MSI file and copied it to the target computer. (XP Pro svc pack 3)

When I run the utility apparently works displaying a progress bar until I get the error message below:

Error writing to file iAnywhere.Data.SQL Anywhere.dll Verify that you have access to that directory

  1. Why is it referring to a DLL as a directory?
  2. I don't believe XP has any elevating issues.
  3. How can I get past this?

Thanks, Melvyn Polatchek

asked 03 Sep '11, 08:14

MelvynP's gravatar image

accept rate: 0%

The SQL Anywhere Deployment Wizard MSI will automatically call "MSIPublishAssemblies" ( ) as part of its install sequence. If you have selected the SQL Anywhere .NET Deployment components for inclusion in your MSI, it checks for the presence of the version of the .NET Framework deployed on the computer, and if found, registers the SQL Anywhere assemblies in the Global Assembly Cache (GAC). It appears that you currently do not have sufficient privileges to register assemblies into the GAC.

From the Microsoft MSDN link:

Administrators often protect the systemroot directory using an access control list (ACL) to control write and execute access. Because the global assembly cache is installed in a subdirectory of the systemroot directory, it inherits that directory's ACL. It is recommended that only users with Administrator privileges be allowed to delete files from the global assembly cache.

You will need to either re-run the install as an Administrator (alternatively, as a user with privileges to install assemblies into the GAC), or de-select the SQL Anywhere .NET Components when building your MSI install.

permanent link

answered 13 Sep '11, 16:26

Jeff%20Albion's gravatar image

Jeff Albion
accept rate: 25%

edited 13 Sep '11, 16:28

As this error seems to rely to the SQL Anywhere .NET provider - Do you need to install that component for your PB application?

If you do not, omitting the provider from the deployment may be the easy way out.

If you do, what .NET runtime version are you targetting?

As a starting point, the following doc (for v12.0.1) may help: Deploying the SQL Anywhere .NET Data Provider

permanent link

answered 03 Sep '11, 13:25

Volker%20Barth's gravatar image

Volker Barth
accept rate: 34%

Not sure why this is happening, but to work around the issue try deselecting the .NET provider from the list of client interfaces when you generate the MSI. The only client interface you need for PowerBuilder is ODBC.

permanent link

answered 03 Sep '11, 19:26

Bill%20Hillis's gravatar image

Bill Hillis
accept rate: 66%

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: 03 Sep '11, 08:14

question was seen: 3,089 times

last updated: 13 Sep '11, 16:28