Question Re: SQL Anywhere 17 service without server? in Technology Q&A

SQL Anywhere 17 service without server?

former_member1352942 — Tue, 03 Jan 2023 15:57:58 GMT

dear all,
i´m completely new in SQL Anywhere, i worked with Microsoft SQL or MySQL/MariaDB before.

I should make a SCADA project for a cutomer who has a running SQL Anywhere database with production data.
Now i should read some production numbers and show them with machine data and energy data in my SCADA system.
I have set up a virtual machine on W10 and get a copy of the SQL Anywhre database from my customer running as service.
But i did not see a SQL server running?
Is this the workflow for a SQL Anywhere system or di i have to make more settings.
In case the customer did not know anything about his database because the original owner has died and the new owner did not have any passwords or documentation, the job seems to be hard to do!

Can anyone help me in this case?

kind regards

Re: SQL Anywhere 17 service without server?

Former Member — Tue, 03 Jan 2023 15:58:12 GMT

Thank you for visiting SAP Community to get answers to your questions. Since you're asking a question here for the first time, I recommend that you familiarize yourself with: https://community.sap.com/resources/questions-and-answers, as it provides tips for preparing questions that draw responses from our members.

For example, you can:

- outline what steps you took to find answers (and why they weren't helpful)

- share screenshots of what you've seen/done

- make sure you've applied the appropriate tags

- use a more descriptive subject line

The more details you provide, the more likely it is that members will be able to respond. Feel free to also take our Q&A tutorial at: https://developers.sap.com/tutorials/community-qa.html

Should you wish, you can revise your question by selecting Actions, then Edit.

By adding a picture to your profile you encourage readers to respond: https://developers.sap.com/tutorials/community-profile.html

Questions on how to draw responses from members? Check out this discussion on how to improve questions. https://groups.community.sap.com/t5/welcome-corner-discussions/advice-from-sap-champions-questions-and-answers/m-p/123609/thread-id/1094

Re: SQL Anywhere 17 service without server?

chris_keating — Wed, 04 Jan 2023 14:55:35 GMT

You will need to install /deploy SQL Anywhere software on the virtual machine. In particular, you will need to install the server, client, and perhaps the administration tools which will include SQL Central and Interactive SQL that may be helpful.

SQL Anywhere hosts databases on a server executable. There are two options

Personal Server (dbeng17.exe) which allows up to 10 local connections
Network Server (dbsrv17.exe) which allows connections over the network or locally.

The basic approach to running SQL Anywhere server is

<dbeng17> | <dbsrv17> -n <ServerName> <databasefile> -n DatabaseName.

Do you have the server running on the virtual machine as a service or simply a copy of the database?

If there is only one instance of the database server, you may only need to know the UID/PWD for local connections.

Here are some basic doc links covering the topics of how to host the database on a SQL Anywhere engine and how to connect to that database.

You will need to know the UID/PWD in order to connect to the database. There is not a default for databases created in SQL Anywhere 17. Prior versions created the UID: DBA with the PWD: sql. If you have support for SQLA, help can be provided if the login credentials are not known.

Re: SQL Anywhere 17 service without server?

chris_keating — Wed, 04 Jan 2023 15:06:19 GMT

You can download the Trial Edition (may also be referred to as the Developer Edition) from the SAP Store. It is the same product as you would purchase with the following

the network server is a three concurrent user license although as long as you adhere the licensed usage, you can increase that if needed
the software can only be used to evaluate or for development. It cannot be used in production environments so cannot be used to meet your requirements but would allow you to become familiar with the product and development of the solution you describe.

Please ensure that you read the Developer Edition licensing and adhere to the permitted usage.