Need help getting free developer SQL Anywhere 16 to work

[Former Member]

I'm trying to test it with our LogicMonitor monitoring software so I downloaded the free "developer edition" and installed it on a Windows 8.1 computer.  I can successfully connect from that local PC to the demo database and do a query but I cannot connect from a different computer on my network. In fact, I don't even think that it's listening on any port (including the typical 2638) because I ran the command netstat -aon and that port doesn't show as listening. Also, nothing showed as listening in the similar "CurrPorts" freeware.

Other evidence...I would think that there SHOULD be a service for this database but I don't see any obvious in Windows Services.msc utility.

I haven't found any articles yet indicating that this free developer edition cannot do remote/network connections but I'm beginning to wonder.

Any tips and info are appreciated.

[former_member207653]

Hi Mike,

You should also check what database engine you have started.

It must be dbsrv16.exe ( DocCommentXchange ) if you want to connect from another machine. I guess, you are running dbeng16.exe that is a local server.

Thank you,

Mirco

[Former Member]

Hello Mike,

You can run dblocate utility to locate database servers on the TCP/IP network.

Also, you can create a Windows Service using dbsvc utility or Sybase Central:

Using dbsvc: http://dcx.sap.com/index.html#sa160/en/dbadmin/dbsvc-service-dbutilities.html http://dcx.sap.com/index.html#sa160/en/dbadmin/running-sectb-3454334-cmdln.html

Using Sybase Central: http://dcx.sap.com/index.html#sa160/en/dbadmin/running-sectb-3454334.html

Jinwoo Park

SAP Product Support