[Monetdb-developers] Another Question about use Aqua Datastudio
sjoerd at acm.org
Mon Jul 17 10:58:33 CEST 2006
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
However, you can use the SQLDriverConnect function to specify the
necessary parameters. E.g.:
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
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
> 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.
> 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
> Monetdb-developers mailing list
> Monetdb-developers at lists.sourceforge.net
-------------- next part --------------
A non-text attachment was scrubbed...
Size: 370 bytes
Desc: OpenPGP digital signature
More information about the developers-list