[Monetdb-developers] Another Question about use Aqua Datastudio
When I use Aqua Data Studio 4.7 as a SQL client,I must register a database first. If I want to connect a remote server,I must fill in all the blank in the Server Properties . For example:I must fill in the following information Name: Remote-monet-server Type: Production Login Name: monetdb Password:monetdb Datasource: this field I don not know how to write :( Can you tell me how to fill in this field? When I use "MonetDB",I can only connect localhost server, if I want to connetct the remote server, how to write the Datasource? "MonetDB@10.78.90.17" is right?? Davy China -- View this message in context: http://www.nabble.com/Another-Question-about-use-Aqua-Datastudio-tf1950599.h... Sent from the monetdb-developers forum at Nabble.com.
The latest documentation is shown below. I'm trying out version 4.7 to see if there are changes we should know about. regards, Martin 2.8.1 Aqua Data Studio Aqua Data Studio is a graphical user interface to interact with MonetDB/SQL. It is available on Windows, Linux, and MacOS platforms from the distribution site. Download the Version 4.5 executable and install the software. The first step to make Aqua Data Studio aware of MonetDB is to register the database server . Go to the Server->Register Server panel and select the Generic- JDBC RDBMS theme. It requires the following additional field settings: Name: MonetDB SQL Type: Whatever you want Login Name: monetdb Password: monetdb URL jdbc:monetdb://localhost/database Driver: nl.cwi.monetdb.jdbc.MonetDriver Driver Location: C:\Program Files\CWI\MonetDB\share\MonetDB\lib\monetdb-1.3-jdbc.jar The location of the JDBC driver under Linux and OSX is by default /usr/share/MonetDB/lib/monetdb-1.3-jdbc.jar. Once the settings has been completed, start the MonetDB server and try to connect. If necessary extend the heap size of your java engine, e.g. use -Xmx1024M . china-davy wrote:
I am using vserion 4.7 as the client,it is runnig on machine-1(say,10.78.90.1),and the server is running on another manchine-2(say,10.78.90.2).Have you tried this ?If I want to connect the MonetDB server via odbc,how to do then ?That is just the question I asked before. Thank you best regards Davy China -- View this message in context: http://www.nabble.com/Another-Question-about-use-Aqua-Datastudio-tf1950599.h... Sent from the monetdb-developers forum at Nabble.com.
ok,you are right.Aqua Datastudio can connect the MonetDB via jdbc,I have tried it ,there is no problem. Let me describe the background of my question I asked before. I have a TPC-C benchmark test program,it is used for testing the performance of a DBMS. I have use this program tested some DBMS(say,ORA,DB2,Postgres,and so on),all the DBMS were connected via the odbc driver,and all these DBMS odbc driver can be configured easily.I only need tell the odbc some connect information,say,destanation host name,database name,login name,and so on. So,I want to connect the remote MonetDB server.That is why i ask so many question about odbc driver and connect to a remote MonetDB server. Davy China -- View this message in context: http://www.nabble.com/Another-Question-about-use-Aqua-Datastudio-tf1950599.h... Sent from the monetdb-developers forum at Nabble.com.
There is currently no way to configure MonetDB/ODBC through a configuration dialog. On the other hand, there would be very little to configure. There is currently only one user (monetdb) with a fixed password (monetdb), and there is only one database available (MonetDB). The only choices you have are the host and the port. The server, by default, only accepts connections from the localhost, and on a fixed port (50000). However, you can use the SQLDriverConnect function to specify the necessary parameters. E.g.: SQLDriverConnect(dbc, NULL, "DSN=Monetdb;UID=monetdb;PWD=monetdb;host=10.78.90.17;PORT=50000", SQL_NTS, NULL, 0, NULL, SQL_DRIVER_NOPROMPT); As to using Aqua Studio, I don't know whether that uses SQLDriverConnect (in which case it might be possible to have it use the above form), or SQLConnect (in which case it is not possible to specify a different host name). On 2006-07-16 17:32, Martin Kersten wrote:
-- Sjoerd Mullender
participants (4)
-
china-davy -
Fabian Groffen -
Martin Kersten -
Sjoerd Mullender