[MonetDB-users] Problem using win 32 odbc driver
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
participants (1)
-
klaas@maxml.nl