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.

Is ENG and DBN (connection parameters) is same for all databases in sql anywhere ? IF not then how can find a server name (ENG parameter) of a database ?

asked 09 Apr '20, 15:31

hg1735's gravatar image

hg1735
555511
accept rate: 0%


No, they are not necessarily identical - just when you do not specify a server name when starting the database server (i.e. you have not used the dbsrvX -n server name option) the server is named after the first database started...

For a running database, the following will tell you both names:

select property('Name'), db_property('Name');
permanent link

answered 09 Apr '20, 15:54

Volker%20Barth's gravatar image

Volker Barth
40.2k361550822
accept rate: 34%

edited 09 Apr '20, 16:06

thank you sir :)

(09 Apr '20, 16:28) hg1735

Is there a way in which I can find server name without connecting the database ? when I tried to open dbisql utility to run above commmand I got error that isql.jar not found.

(10 Apr '20, 07:06) hg1735
Replies hidden

You can use the DBLOCATE utility to find running servers (and running databases) in your network neighborhood.

(10 Apr '20, 08:14) Volker Barth

I don't want to find in neighbour network. I want to find servers in my machine.I able to find server using dbisql in my vm but in my client's vm there isn't sql central and dbisql utility gives error that isql.jar not found. Do you have any idea about this error ?

(10 Apr '20, 10:15) hg1735
Your answer
toggle preview

Follow this question

By Email:

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

By RSS:

Answers

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

Question tags:

×37
×28
×14

question asked: 09 Apr '20, 15:31

question was seen: 1,701 times

last updated: 13 Apr '20, 10:34