I am attempting to create a TCP listener for an existing running database using SQL Central. The ip address for the machine is

$ ip addr
1: lo: <LOOPBACK,UP,LOWER_UP> mtu 65536 qdisc noqueue state UNKNOWN group default qlen 1000
    link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00
    inet scope host lo
       valid_lft forever preferred_lft forever
    inet6 ::1/128 scope host 
       valid_lft forever preferred_lft forever
2: enp0s3: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc pfifo_fast state UP group default qlen 1000
    link/ether 08:00:27:9a:55:ef brd ff:ff:ff:ff:ff:ff
    inet brd scope global enp0s3
       valid_lft forever preferred_lft forever
    inet6 fe80::a00:27ff:fe9a:55ef/64 scope link 
       valid_lft forever preferred_lft forever
$ cat hosts   localhost     sa

I can successfully ping the machine either as "ping sa" or "ping", but the IP address and host do not appear in the drop down when attempting to create a TCP listener using the SQL Central Listener wizard:

"Only the following address: (localhost IPv4)"

Any suggestions of how they could appear?

asked 21 Jun, 11:56

bluefrog's gravatar image

accept rate: 0%

There's no need to "setup a TCP/IP listener" for SQL Anywhere other than using the DBSRV17 executable (the networt server) - it uses TCP/IP by default, and as Ian has answered on your other question, defaults to use port 2638 if available or the first available "ephemeral port" (49152 or above).

(21 Jun, 12:06) Volker Barth

My first guess is you are starting a personal server (dbeng17). For connections from other machines, you need a network server (dbsrv17). I believe you need a different license to use a network server than a personal server.

permanent link

answered 21 Jun, 11:58

Ian%20McHardy's gravatar image

Ian McHardy
accept rate: 39%

I downloaded the developer edition. Does that mean I cannot connect from another machine ?

(21 Jun, 12:17) bluefrog
Replies hidden

You can. AFAIK, the DevEd should contain both the network server (dbsrv17) and the personal server (dbeng17). It's basically the full software package with restricted license.

(21 Jun, 15:00) Volker Barth

Hi Volker

thanks for the tip. On the server I was using dbend17, instead of dbsrv17


$ /opt/sqlanywhere17/bin64s/dbsrv17 -ga -x tcpip(port=49153) -n ftnode_sa /home/sa/sqlany17/ftnode_sa.db

I can now connect from another machine with SQL Central. I can also successfully ping the db:


$ dbping -d -c "uid=sadb;pwd=sadb;eng=ftnode_sa;links=tcpip(host=sa;port=49153);LOG=conn.log;dbn=ftnode_sa" SQL Anywhere Server Ping Utility Version Connected to SQL Anywhere server "ftnode_sa" and database "ftnode_sa" at address Ping database successful.

One more question. Is there an equivalent of a Oracle sqlplus command line utility that comes with SQL Anywhere ?

(21 Jun, 18:31) bluefrog
Replies hidden

FWIW, it's dbeng17 (for "engine"), not dbend17:)

I don't know SQL*Plus but SQL Anywhere comes with Interactive SQL (DBISQL) as a graphical SQL query tool (also available within SQL Central), and there's an older dbisqlc utility with reduced functionality and minimal resource needs. Both do not offer a classic "command line interface" but allow the interactive execution of SQL commands, so DBISQL should certainly work for you.

Both tools allow to run complex SQL scripts, too.

(22 Jun, 03:42) Volker Barth
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](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:


question asked: 21 Jun, 11:56

question was seen: 77 times

last updated: 22 Jun, 03:44