I am working with DevExpress components, specifically their report writer wizard.

They have an option for using SAP Sybase Advantage. When I choose the DD and user/password to connect, I get a 'Optima.add is in use' error.

I have found out the connection string that they are building which is as follows :-

"XpoProvider=Advantage;Data source=fileName.add;servertype=local;user id=;Password=;TrimTrailingSpaces=true"

They are using local server. Obviously when creating reports, I want the DD to be opened shared because it may already be in use by someone else.

My question is, does local server open a DD exclusively or is there something else I can tell them to add to the connection string to make it work.

If I select the custom connection option in their wizard I can use my normal remote server connection string.

Or should I ask them to put a drop down in to select server type?



asked 25 Jul '14, 02:29

Mike's gravatar image

accept rate: 12%

edited 25 Jul '14, 02:30

I agree with Jens that the processes lock the file (at least remote) but I don't think that necessarily using remote is a requirement.

When you say the following statement:

When I choose the DD and user/password to connect, I get a 'Optima.add is in use' error.

Are you browsing to a file? what happens if you type in the connection string manually? Some dialogs that browse for files actually try to open the file in the dialog which can fail if the file is in use. ARC and the ODBC setup screen had that issue. The dialog had to be changed to not open the file, just grab the file name.


answered 25 Jul '14, 07:45

Edgar%20Sherman's gravatar image

Edgar Sherman
accept rate: 25%

+1 Unnecessary file locking can be a big problem, indeed.

(25 Jul '14, 08:19) Jens Mühlenhoff

Yes, the local server (ALS) locks the data files (dictionaries, tables, memo files, indexes) it uses. (As does ADS, the remote server, but it acts as a multiplexer to allow many clients to access the same data at once over the network)

It's only meant as a single user replacement where the real network server is not available.

ALS and the ADS can't be used both at the same time on the same dictionary / tables.

The DevExpress component should have an option to use the remote server and that should probably be the default as well.


answered 25 Jul '14, 03:15

Jens%20M%C3%BChlenhoff's gravatar image

Jens Mühlenhoff
accept rate: 18%

edited 25 Jul '14, 03:21


I will go back to them.

(25 Jul '14, 03:33) Mike
Your answer to the original question.
If responding to a request for additional information, please edit the question or use the comment functionality.
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](http://url.com/ "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



Asked: 25 Jul '14, 02:29

Seen: 2,859 times

Last updated: 25 Jul '14, 08:19

Advantage Developer Zone Contact Us Privacy Policy Copyright Info

Powered by Advantage Database Server and OSQA
Disclaimer: Opinions expressed here are those of the poster and do not necessarily reflect the views of the company.