SQL from both OE and sqlexp

[JustMe]

Newbie, on progress day 4 continued ...
(Is this SQL or DB problem?, should it be moved to DB forum?)


The version is 10.2b 05
I am running eclipse on windows XP servicepack 3 (Admin programs also)
The database is running on SLES11 linux

After setting up a second broker for SQL only I can connect from both OE and sqlexp.

But when I send a query from either I get the error:
[DataDirect] [OpenEdge JDBC Driver] [OpenEdge] Table/View/Synonyum not found (7519)
the OE will let be "browse" the tables.

Any and all help appreciated ...

JustMe (Rich)

 

[Rob Fitzpatrick]

But when I send a query from either I get the error:
[DataDirect] [OpenEdge JDBC Driver] [OpenEdge] Table/View/Synonyum not found...

It would help if we knew the query in question...

 

[JustMe]

it is very complex ...

SELECT tablename.field FROM tablename;

specifically (SELECT item.BAR-CODE FROM item

 

[Rob Fitzpatrick]

Try qualifying the table references with the schema, e.g. PUB.tablename.field.

Also, enclose the table or field names in double quotes if they contain a hyphen. E.g. ... PUB.item."bar-code". Or ...PUB."table-name"...

 

[JustMe]

Very cool, you got it. So take a big prize off of the top shelf

Thanks ...

JustMe (Rich)

 

[abevoelker]

Try qualifying the table references with the schema, e.g. PUB.tablename.field.

Also, enclose the table or field names in double quotes if they contain a hyphen. E.g. ... PUB.item."bar-code". Or ...PUB."table-name"...

Since you're using the JDBC driver, you can set the "defaultSchema" property to "PUB" before you connect, and you won't have to preface your table names with it.