I'm trying to run an OpenOffice database query against an Oracle database on the same machine via an ODBC connection. I can see tables and build queries in Open Office DB just fine, but when I try to run them, I get the following (always the same, so this is a sample from one I ran) -- SQL STATUS: HY000 Error Code: 1000 Syntax error in SQL Expression Syntax error, unexpected INVALIDSYMBOL, expecting FROM or SQL_TOKEN_INTO, Invalid symbol: ."A" The sql it put together in the Query Wizard looks like this -- SELECT "TEST_TABLE1"."A" FROM "OPS$GREGW"."TEST_TABLE1" "TEST_TABLE1" Why it wants to put the "'s around everything I don't know, but I copied this exact sql statement into the Oracle built in interactive tool (sqlplus), ran it, and it worked fine. It's actually a perfectly valid query (select table TEST_TABLE1 column A from schema.table=OPS$GREGW.TEST_TABLE1" assigning an alias to the table of TEST_TABLE1). Anybody have any clues on what could be going wrong here and why OpenOffice can build but not run this query? Thanks, Greg Wallace