[Monetdb-developers] Question about remote connection to MonetDB
Hi: I am a starter of MonetDB.I encountered a problem about conneting a remote MoneDB server via ODBC.The problem is discribed as follows: Given that the MonetDB server is running on a host(10.20.30.1),and,the Application program is running on a host (10.20.30.2).The MonetDB version is the windows version.I have tried to connet the server through the ODBC connect string in my appliction program,but failed,by the way,I am ensure the connect string is correct. My question is: 1.Can MonetDB server be connected via ODBC driver from a remote Application Clinet? 2.If it is so,how can I connet the MonetDB server.Wether need I do some configuration in the configure file of the MonetDB server? Waiting for your suggestion!Thanks!
best regards!
Davy China
On 16-07-2006 02:12:52 -0700, china-davy wrote:
My question is: 1.Can MonetDB server be connected via ODBC driver from a remote Application Clinet? 2.If it is so,how can I connet the MonetDB server.Wether need I do some configuration in the configure file of the MonetDB server?
You have to enable the server to listen to remote connections. This can be done by using: mapi_start(true); instead of just "mapi_start();".
I hope this helps.
Thank you very much.I have added the parameters according your suggestion.But I stil can not connet to the server from another host client.Please help me.
The conent of the MSQLserver are as follows:
@echo off rem figure out the folder name set MONETDB=%~dp0 rem remove the final backslash from the path set MONETDB=%MONETDB:~0,-1% rem start the real server "%MONETDB%\Mserver.bat" --dbinit="module(sql_server); sql_server_start();mapi_start(true);" %*
On 16-07-2006 05:39:59 -0700, china-davy wrote:
Thank you very much.I have added the parameters according your suggestion.But I stil can not connet to the server from another host client.Please help me.
The conent of the MSQLserver are as follows:
@echo off rem figure out the folder name set MONETDB=%~dp0 rem remove the final backslash from the path set MONETDB=%MONETDB:~0,-1% rem start the real server "%MONETDB%\Mserver.bat" --dbinit="module(sql_server); sql_server_start();mapi_start(true);" %*
Could you try this? "%MONETDB%\Mserver.bat" --dbinit="module(sql_server); mapi_start(true); mapi_register(sql_frontend());" %*
:( I have tried to do that,but I got the following message: !01 ERROR: interpret: no matching MIL operator to 'sql_frontend()'. !01 ERROR: interpret_params: mapi_register(param 1): evaluation error.
On Sun, Jul 16, 2006 at 06:07:48AM -0700, china-davy wrote:
:( I have tried to do that,but I got the following message: !01 ERROR: interpret: no matching MIL operator to 'sql_frontend()'. !01 ERROR: interpret_params: mapi_register(param 1): evaluation error.
A question we should have asked before givin any answer:
Which version of MonetDB and MonetDB/SQL are you using?
Stefan
-- View this message in context: http://www.nabble.com/Question-about-remote-connection-to-MonetDB-tf1950030.... Sent from the monetdb-developers forum at Nabble.com.
Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&da... _______________________________________________ Monetdb-developers mailing list Monetdb-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-developers
I use the windows version 4.10.2. by the way,why the MonetDB odbc driver cannot be configured as other odbc driver(eg.Postgresql,Ora,and so on).I mean that i can configure the connetion information via the odbc.(eg.the destnation hostname,database name,login name,password)?
On Sun, Jul 16, 2006 at 04:01:07PM +0200, Stefan Manegold wrote:
On Sun, Jul 16, 2006 at 06:07:48AM -0700, china-davy wrote:
:( I have tried to do that,but I got the following message: !01 ERROR: interpret: no matching MIL operator to 'sql_frontend()'. !01 ERROR: interpret_params: mapi_register(param 1): evaluation error.
A question we should have asked before givin any answer:
Which version of MonetDB and MonetDB/SQL are you using?
Background:
given that your MSQLserver.bat says/uses
"%MONETDB%\Mserver.bat" --dbinit="module(sql_server); sql_server_start(); mapi_start();" %*
and not (yet)
"%MONETDB%\Mserver.bat" --dbinit="module(sql_server); mapi_register(sql_frontend()); mapi_start();" %*
and that your Mserver does not seem to know sql_frontend() (yet), suggests that you're using MonetDB 4.10.2 & MonetDB/SQL 2.10.2 (or older), right?
You should consider upgrading to the latest release MonetDB 4.12.0 & MonetDB/SQL 2.12.0 cf. http://sourceforge.net/mailarchive/forum.php?thread_id=19514893&forum_id... http://monetdb.cwi.nl/GetGoing/Download/index.html
Stefan
On Sun, Jul 16, 2006 at 05:39:59AM -0700, china-davy wrote:
Thank you very much.I have added the parameters according your suggestion.But I stil can not connet to the server from another host client.Please help me.
The conent of the MSQLserver are as follows:
@echo off rem figure out the folder name set MONETDB=%~dp0 rem remove the final backslash from the path set MONETDB=%MONETDB:~0,-1% rem start the real server "%MONETDB%\Mserver.bat" --dbinit="module(sql_server); sql_server_start();mapi_start(true);" %*
you probably also what the MonetDB/SQL server to be open for remote connections, hence:
"%MONETDB%\Mserver.bat" --dbinit="module(sql_server); sql_server_start(true); mapi_start(true);" %* ^^^^ ^^^^
Stefan
-- View this message in context: http://www.nabble.com/Question-about-remote-connection-to-MonetDB-tf1950030.... Sent from the monetdb-developers forum at Nabble.com.
Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&da... _______________________________________________ Monetdb-developers mailing list Monetdb-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-developers
participants (3)
-
china-davy -
Fabian Groffen -
Stefan Manegold