[MonetDB-users] SyntaxException in "monetdb create demo" statement
I have installed MnetDB by downloading the file "MonetDB-ODBC-Installer-i386-20080812.msi". Then I opened MonetDB SQL Server. The last message that I got on the command prompt was "MonetDB/SQL module v2.24.0 loaded". Then I tried the statement "monetdb create demo", but I got the following error
SyntaxException:parseError:monetdb create demo SyntaxException:parseError ^';' expected
Can anybody tell me that where I was going wrong.
On 02-09-2008 23:52:27 -0700, rmaadil wrote:
I have installed MnetDB by downloading the file "MonetDB-ODBC-Installer-i386-20080812.msi". Then I opened MonetDB SQL Server. The last message that I got on the command prompt was "MonetDB/SQL module v2.24.0 loaded". Then I tried the statement "monetdb create demo", but I got the following error
SyntaxException:parseError:monetdb create demo SyntaxException:parseError ^';' expected
Can anybody tell me that where I was going wrong.
You are at the MAL prompt.
The tools merovingian and monetdb are only available on UNIX-like platforms, hence not on Windows. You cannot use them. Under windows you can just start mclient from the start menu.
The thing I can understand from your post is that I can't use this statement in the Windows environment. So, how can I create a database in Windows environment. Kindly give me the complete statement as I am new to MonetDB.
On 03-09-2008 00:49:23 -0700, rmaadil wrote:
The thing I can understand from your post is that I can't use this statement in the Windows environment. So, how can I create a database in Windows environment. Kindly give me the complete statement as I am new to MonetDB.
Sort of not. You would have to edit the monetdb5.conf configuration file to set the gdk_dbname value, and restart the server. On windows you're more or less stuck with the single default database "demo".
You mean I cannot create a new database using MonetDB in Windows platform? In the documentation I have read that MonetDB is cross platform.
On 03-09-2008 01:14:26 -0700, rmaadil wrote:
You mean I cannot create a new database using MonetDB in Windows platform? In the documentation I have read that MonetDB is cross platform.
MonetDB compiles and runs on many platforms, but it does not adapt to the platform it runs on. It keeps on having a UNIX strategy (hence the console window). The merovingian and monetdb tools are not portable to Windows. If you want to use multiple databases under Windows, you'll have to enter the console and give the proper commands to the mserver5.exe binary when starting it. Its help command should tell you --dbname controls the database the binary will serve.
participants (2)
-
Fabian Groffen -
rmaadil