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.

Until now, we communicated with the db via standard statements or procedures. We would like to use services but are looking for more information than what the SAP documentation provides. What are the pitfalls to avoid? What have you come across that you wish had been in the documentation? Security concerns?

The web developer would have to supply me more involved questions but here's the basics. We don't have our production db open to the web. We are transitioning from a desktop app to a web app. Currently, the web app (ASPX) does all calls to the db with OLE connections / transaction based. I used to be a programmer, so I set up an http listener on our development db and gave them an example of an ajax call to fill a search autocomplete with JSON from a webservice I created. It accesses the DB via a url on a local IP. They like the speed and simplicity and want to know how we could implement it in a production environment while still protecting the DB. That's beyond my scope of knowledge, to be honest. The example was pretty simple - I added a header to get around CORS restrictions (that took awhile to figure out) and used the variables passed in on the url to run a proc that returned a result set with id, label and value. We will be starting from the ground up when it comes to web services from the DB and wanted to start off on the right track. Use cases seem difficult to find when I search for them.

asked 18 Sep '19, 09:19

mrmitch's gravatar image

accept rate: 0%

edited 20 Sep '19, 10:58

If you have specific questions, please ask them here.

Please note that this is primarily a question-and-answer site, not so much a chat room, so you might not get useful responses to open-ended "conversation starter" questions like this.

(20 Sep '19, 04:12) Breck Carter

Until now, we communicated with the db via standard statements or procedures. We would like to use services

What kind of web services? SOAP, OData, REST, ...?

(20 Sep '19, 04:35) Volker Barth

Sorry for the open ended question, I'll edit

(20 Sep '19, 10:43) mrmitch
Replies hidden

Sorry for the confusion... "please ask them here" means "post your questions on this forum, one new post per question".

Once a question has even one reply, busy people tend to assume it's been answered and skip onwards... in other words, "thread drift" might work in other forums but not in a Q&A site.

Editing is OK for fixing errors, but not changing the question.

(21 Sep '19, 07:04) Breck Carter

See this folder for working sample code:

   C:\Users\Public\Documents\SQL Anywhere 17\Samples\SQLAnywhere\HTTP\ 

Note that the built-in SQL Anywhere Monitor component, the Foxhound performance monitor product, and this site all run on the SQL Anywhere HTTP component.

The documentation certainly assumes you know everything you need to know about HTTP, HTML and so forth... the SQL Anywhere documentation describes how SQL Anywhere implements particular aspects of HTML and HTTP but no further (and that "no further" stuff is enormous... it's ALL available on the web so you have that going for you :)

Also note that the worldwide security landscape changes on an hourly basis; e.g., TLS certificate handling... it's not SQL Anywhere's fault, for example, that Firefox now almost completely refuses to handle the sample certificates shipped with SQL Anywhere.

permanent link

answered 20 Sep '19, 04:25

Breck%20Carter's gravatar image

Breck Carter
accept rate: 20%

edited 20 Sep '19, 04:34

And it is not a Firefox’ fault that the certificate is self-signed either

(21 Sep '19, 02:47) Vlad
Comment Text Removed

Did you successfully deploy web service and support CORS? Could you please publish your answers for your communication! Thank you very much!

My current visit to ASA 17.0.10 will result in errors. The documentation does not say how to create and test the environment deployment

permanent link

answered 12 Jan '20, 11:27

mfkpie8's gravatar image

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: 18 Sep '19, 09:19

question was seen: 1,583 times

last updated: 12 Jan '20, 11:27