You are right, Anthony, when I run the file independent of R, mserver.exe shuts down immediately.

De : users-list [mailto:users-list-bounces+kaspar.burger=iukb.ch@monetdb.org] De la part de Anthony Damico
Envoyé : mardi 10 juin 2014 08:51
À : Communication channel for MonetDB users
Objet : Re: MonetDB problem with mserver.exe

kaspar has something changed?  when you and i screenshared to try to resolve this issue, mserver.exe was shutting down immediately before R ever came into the picture?

what happens when you run this file independent of R?

C:\Users\Kaspar Burger\MonetDB\test.bat

On Tue, Jun 10, 2014 at 2:42 AM, Hannes Mühleisen <Hannes.Muehleisen@cwi.nl> wrote:

This seems to fall into my backyard...

On 10.06.2014, at 08:32, Kaspar Burger <kaspar.burger@iukb.ch> wrote:
> I am working in R, configuring a MonetDB test database and trying to
> access MonetDB with the following code:
>
> batfile <- "C:/Users/Kaspar Burger/MonetDB/test.bat"
> pid <- monetdb.server.start( batfile )
> dbname <- "test"
> dbport <- 50000
> monet.url <- paste0( "monetdb://localhost:" , dbport , "/" , dbname )
> db <- dbConnect( MonetDB.R() , monet.url , wait = TRUE )
>
> When I run the “pid <- monetdb.server.start( batfile )” line, the
> mserver5.exe opens briefly but shuts down immediately afterwards (for a
> more extensive description of the R code, see:
> https://raw.githubusercontent.com/ajdamico/usgsd/master/MonetDB/monetdb%20database%20creation%20instructions.R).
> By contrast, running the batch file from C:\Program
> Files\MonetDB\MonetDB5\M5server.bat or from the Start menu works fine. I
> tried when both drivers were installed as well as when only one driver was
> installed. Could that problem be related to R or to my code?

Would not be surprised if the space in the batfile path causes the problem. Try setting up the DB into another directory without a space in it and try again.

Best,

Hannes

>
>
>>
>>
>> On 2014-06-10 00:06, Stefan Manegold wrote:
>>>> On 09/06/14 16:28, Kaspar Burger wrote:
>>>>>
>>>>> Hello,
>>>>>
>>>>> I seem to have difficulties with mserver.exe. I would like to use
>>>>> MonetDB
>>>>> on a Windows 64 bit computer, so...
>>>>>
>>>>> 1)  ...I went to
>>>>> https://www.monetdb.org/downloads/Windows/Jan2014-SP2/
>>>>>
>>>> Most likely, you need only 1 ODBC driver.
>>>> Otherwise causing a clash.
>>>
>>> For the records, as by our own documentation, on a 64-bit Windows
>>> system,
>>> both the 32-bit and the 64-bit ODBC driver *must* be installed.
>>> (As far as I understand, this is required to support both 32-bit and
>>> 64-bit
>>> applications, or simply because Windows requires it.)
>>
>> You need both in order to support both 32 and 64 bit applications.
>> That's the only reason to install both.
>>
>>> Stefan
>>>
>>>>> 2) ...and first installed the MonetDB ODBC driver, 32 bit (to
>>>>> C:\Program
>>>>> Files (x86)\MonetDB\MonetDB ODBC Driver\)
>>>>>
>>>>> 3) ...then I installed the MonetDB ODBC driver, 64 bit (to C:\Program
>>>>> Files\MonetDB\MonetDB ODBC Driver\)
>>>>>
>>>>> 4) ...and finally I installed the MonetDB SQL server and client, 64
>>>>> bit
>>>>> (to C:\Program Files\MonetDB\MonetDB5\).
>>>>>
>>>>> When I open up mserver.exe, it shuts down immediately. Does anyone
>>>>> know
>>>>> what could have gone wrong?
>>
>> Did you start the server using the start menu?  That actually runs a cmd
>> script to set a bunch of environment variables before starting the
>> actual server mserver5.exe.
>>
>>>>> I would appreciate any hint. Thanks in advance.
>>>>>
>>>>> Kaspar Burger
>>>>>
>>>>>
>>>>> _______________________________________________
>>>>> users-list mailing list
>>>>> users-list@monetdb.org
>>>>> https://www.monetdb.org/mailman/listinfo/users-list
>>>>>
>>>>
>>>> _______________________________________________
>>>> users-list mailing list
>>>> users-list@monetdb.org
>>>> https://www.monetdb.org/mailman/listinfo/users-list
>>>>
>>>
>>
>> --
>> Sjoerd Mullender
>>
>> _______________________________________________
>> users-list mailing list
>> users-list@monetdb.org
>> https://www.monetdb.org/mailman/listinfo/users-list
>>
>
>
> _______________________________________________
> users-list mailing list
> users-list@monetdb.org
> https://www.monetdb.org/mailman/listinfo/users-list

_______________________________________________
users-list mailing list
users-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/users-list