Colin Foss wrote:
I'm having problems with the latest ODBC driver. My client PC is windows XP. The server is RHEL4. The SQL client works fine as does the JDBC connection.
The ODBC driver appears to install properly but whenever I try to configure the MonetDB ODBC connection the list goes blank.
If I try to connect using MonetDB ODBC connection from Excel I get an error.
Have you tried connecting to a locally running server (i.e. on the same machine as the Excel)? We have never tried remote servers with the MonetDB ODBC driver, and I know that I have not implemented any configuration windows for the driver. When connecting to a local MonetDB server using the MonetDB ODBC driver from Excel, I can get data from the server. However, there is a problem in that setup in that Excel does not use double quotes around column names, and if those names also happen to be keywords, the MonetDB server gives an error. What used to be my standard query, importing the contents of the "columns" table does not work for this reason (you get a "General error"). The columns from the "columns" table that I need to avoid there are "null" and "default". -- Sjoerd Mullender