Posted on orafaq as well...

I am working on an _existing_ VB App connecting to an Oracle database (JBA)
via ODBC and just wanted to be sure I understand the syntax.

The SQL statement is executing is:

SELECT OSLPDF3.MSWRKHDR.*, OSLD1F3.PARTS.* FROM ...
.... WHERE OSLPDF3.MSWRKHDR.CONO40 = 'D1' ...

Is this just [database].[table].[field]?

Do you need to reference the database if the tables are unique across the
ODBC?

Thanks
Ken

In article <0zIhb.398$ca2.971335 (AT) newsfep1-win (DOT) server.ntli.net>,
twoshovel (AT) yahoo (DOT) co.ku says...
you have to specify the "database" (in fact this is called the
"schema"). Search google groups for "public synonym" and "schema" if you
don't want to specify schemas every time.

-- Tom