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
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%20da...). 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