Ocatev and MS Access

[Dominic Rau]

I am trying to connect from Ocatve to a MS Access database via ODBC. The example script works fine for creating and inserting values into the database:

default_db(odbc_db("test","",""));

sql("create table some_table (id int,str varchar);");

sql("insert into some_table (id,str) values (1,'a');");

sql("insert into some_table (id,str) values (2,'b');");

sql("insert into some_table (id,str) values (3,'c');");

sql("insert into some_table (id,str) values (4,'d');");

 

However, I always get an empty array when reading from the interface:

a=sql("select * from some_table;")

ans = {}(0x0)

 

What am I doing wrong?

 

Thanks for your support,

Dominic