you should use different ports for different databases. for example mydb: --set "mapi_port=50001" (in m5server.bat) and -p 50001 (in mclient.bat) mydb2: --set "mapi_port=50002" (in m5server.bat) and -p 50002 (in mclient.bat) On Sat, Aug 20, 2016 at 7:55 PM, Anthony Damico wrote:

creating the batfiles is tricky. if you know R, you could simply use this code to make the batfiles for you:

https://github.com/ajdamico/asdfree/blob/master/MonetDB/ monetdb%20database%20creation%20instructions.R

otherwise, use the bat.contents object in this script as your guide to how a batfile should be structured on windows:

https://github.com/hannesmuehleisen/MonetDBLite/blob/master/R/control.R

On Aug 21, 2016 10:28 AM, "Pablo S" wrote:

...

I'm trying to run two MonetDB databases simoultaneously in Windows. I named the two databases mydb and mydb2.

I changed the database name in M5server.bat to mydb, and added -database=mydb to mclient.bat

Then I copied the M5server.bat file and changed the farm to mydb2. I also copied the mclient.bat file and added -database=mydb2.

I run the two server bats to start the two databases and that seems to work fine (no errors).

Then I run the first mclient.bat and it connects to the server with no issues.

But when I run the copied mclient.bat and try to connect using user/password monetdb/monetdb, I get the following error and cannot connect:

request for database 'mydb2', but this is database 'mydb', did you mean to connect to monetdbd instead?

How to run two databases simoultaneously in Windows? How to connect to two databases at the same time?

_______________________________________________ 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