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