Re: [MonetDB-users] external SQL clients

On 2007-03-14 06:53, Colin Foss wrote:

How do you configure MonetDB to allow SQL connections from clients on computers separate from the server?

On linux I used to do something like this: --dbinit="module(sql_server); sql_server_start(TRUE);"

but that throws an error on Windows.

i.e. I get this: C:> netstat -na | grep 50000 TCP 127.0.0.1:50000 0.0.0.0:0 LISTENING

but I want: TCP 0.0.0.0:50000 0.0.0.0:0 LISTENING

Mserver --set mapi_open=true --dbinit='module(sql_server);'

The service gets started automatically when you load module sql_server (or mapi, for that matter), so we needed a different way to start the server in open mode. Hence the option that you need to set.