Good morning,
I'm using MonetDB v5.16.2 on windows xp 32. Connecting to the database with Java clients works fine, odbc (version 10.1.12) is not.
Table DDL: CREATE TABLE _r_language( id smallint NOT NULL AUTO_INCREMENT, abbrev varchar(3) NOT NULL, name varchar(50) NOT NULL, primary key (id) );
For example in php:
<?php $conn = odbc_connect('DSN=MonetDB;HOST=localhost;PORT=50000', 'monetdb', 'monetdb') or die('unable to connect'); $result = odbc_exec($conn, 'select * from _r_language;'); odbc_result_all($result); ?>
results in: ? ?? ??? 1 English EN 2 German DE 3 French FR 4 Dutch NL 5 Polish PL
The fieldnames are not returned. Using the same ODBC driver in MS Access, the table can be linked, column_names are shown, but retrieving data generates error message: ODBC - call failed [MonetDb][ODBC Driver 1.0]TODO: column names of level >= 3 (#0)
What can you recommend? Thanks for your help,
regards, Klaas