As you requested I just tried the same thing with Access2000, and the results are similar (i.e., no results, only that particular error).

On 1/20/00 1:00 PM, Roland Reumerman at zope_ddi@hotmail.com wrote:

...

The DDL and query were really nothing special. The database I connected to is an Oracle 8.0.5 installation. I created the table with SQL*Plus:

create table zopetest( id number(9), name varchar2(255));

followed by a few inserts (and checked with a select). Then I typed the following on the Test tab page:

select * from zopetest

and clicked on the Submit Query button. The Browse Option in Zope works fine.

Any other queries I tried, with different attributes, tables and even other ZODBC database connections failed exactly the same way.

Interesting, we've never tested ODBC->Oracle..... Can you try it with a sample Access database perhaps?

Chris

______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com