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:
The author of the ODBC code will definitely look at this discussion tomorrow morning (Dutch Time ;-)) and may give you some more targeted hints.
china-davy wrote:
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
------------------------------------------------------------------------- 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&dat=121642 _______________________________________________ Monetdb-developers mailing list Monetdb-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-developers
-- Sjoerd Mullender