The forum will experience an outage sometime between February 10 at 7:00pm EST and February 12 at 11:59 EST for installation of security updates. The actual time and duration of the outage are unknown but attempts will be made to minimize the downtime. We apologize for any inconvenience.

Is it possible to use the sql anywhere monitor for a personal server?

I have a .Net application that starts up a personal server and connects to a client database.

But when I try to add a resource with sql anywhere monitor, I get an unspecific error.


So I first start my application, the Personal Server is running: Version 12.0.1.3873

  • then I go to the Monitor
  • Add resource
  • give a name 'test'
  • Host: localhost
  • port: empty
  • server: 'PersonalServerName'
  • DataBase: 'c:mylocationmydatabase.db'
  • other: empty

DBA User Id: useridoflocaldb

Password: passwordOfLocalDB


then I get this Error: An error occurred configuring the resource for monitoring. Please check that the server is running and that the correct connection parameters were given.

asked 02 Dec '13, 04:16

soto's gravatar image

soto
96228
accept rate: 0%


The monitor uses TCP/IP to connect whereas the personal engine starts only the shared memory protocol by default and therefore does not listen to TCP/IP by default.

Confine the 12.0.1 doc page on the "Monitor architecture":

The monitor connects to SQL Anywhere databases over TCP/IP. To monitor a database running on the local database server (dbeng12), start the database server with the -x all or -x tcpip option.

permanent link

answered 02 Dec '13, 07:08

Volker%20Barth's gravatar image

Volker Barth
29.3k287438644
accept rate: 32%

edited 02 Dec '13, 07:09

I've been able to startup network server and attach my application to that so the monitor has been startup...

permanent link

answered 02 Dec '13, 06:02

soto's gravatar image

soto
96228
accept rate: 0%

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:

×30

question asked: 02 Dec '13, 04:16

question was seen: 855 times

last updated: 02 Dec '13, 07:09