Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: VB ODBC SQL Advice
In article <0zIhb.398$ca2.971335_at_newsfep1-win.server.ntli.net>,
twoshovel_at_yahoo.co.ku says...
> 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
>
>
>
If the tables are not owned by the user connecting to Oracle, then yes
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.